RE: Sales Order Import Integration Lot ID
Hello Dimitryi,
Interesting project.
Just to correct one of your constraints which may simplify your problem: I just tested release to warehouse for an imported line with a manually assigned LotID (through import) and it worked without problem. So I dont think that Release to warehouse cares that lotID was auto-generated or entered manually.
I think you will need to use one of two approaches:
1) Specify a LotID on import using a unique number that is avaliable on the Sales order line in your other ERP (maybe concatenate line number and SO number). Use that number for creation and for any subsequent updates. The LotID number sequence will need to be configured for the number of digits and to allow to change the number (higher and lower). As LotID are used everywhere there are inventory transactions, you will still need to a number sequence but configure it so it will not interfere with the imported manual LotID
2) Use two different Import Projects depending on whether you are doing a initial import (auto-generate LotID) or updating existing lines.
a. the first import is waht you are currently doing
b. for the second, you will need to recuperate the LotID from the previously imported line. Rule of thumb is that the LotID is unique fdr teh sales line so if you know the sales line you should be able to find the LotID.
Good luck!
