When Attribute Set Instance and Attribute Set Instance To on Movement Line are not same, new StorageOnHand record is created with Date Material Policy from source ASI. This could be problem during Movement Completization - correct StorageOnHand is not found and negative inventory is created.
Thanks - can you please test the attached alternate patch IDEMPIERE-2564_CR.patch
Hi , your patch looks fine, can be commited.
Hi , first of all, sorry for my late response.
Few weeks ago we merged with latest community version and noticed that you and Deepak made some additional patches on this ticket. I can confirm that it's working fine on Movements - Movement can properly deal with these Storages, where DateMaterial Policy is different than ASI.Created.
But error persists on other documents - Physical Inventory or Material Receipt. There is no such logic as in Movement. There is simply used created date of attribute set instance - that's mean in our case Storage is trying to create negative records, but thankfully we are using validation for Negative Inventory.
Do you think that similar logic should be applied on all other documents which are manipulating with Storage On Hand?
as tomas wrote we updated our system and generates daily wrong data, correcting by sqls. not too much data related but if any option then pls help to identify our direct us to right way to fix it. bb n