Hi,
Jiwa 7.0.157
The task is to merge 2 items into 1.
We built SQL script that updates all inventory ID field on transactional tables (soh, so_lines, po_lines etc etc) from A to B.
Then user can delete the item A from inventory maintenance screen.
Currently I'm having issue with "PO_Lines.IN_SupplierWarehouse_RecID". Ideally I will need to update that with item B's IN_SupplierWarehouse_RecID, however, I'm not sure what logic should I use or it even matters if I just set it to Null...
The logic I'm thinking is (from Item B)
- find region the PO is in,
- find creditor on PO
- find the default supplier warehouse record
I can think of all sorts of exceptions from logic above, e.g. region order not enabled, no default supplier setup etc etc. In those case, I would just have use NULL.
My question how PO is using that ID and what if, the field value is NULL on open POs.