Mismatch between Created (Attribute Set Instance) and Date Material Policy (Storage On Hand)
Description
Environment
Attachments
relates to
Activity
Norbert Bede December 18, 2015 at 1:43 PM
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

Tomáš Švikruha December 18, 2015 at 6:22 AM
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?

Tomáš Švikruha April 9, 2015 at 5:45 AM
Hi , your patch looks fine, can be commited.
Carlos Ruiz April 8, 2015 at 5:01 PM
Thanks - can you please test the attached alternate patch IDEMPIERE-2564_CR.patch
Details
Details
Assignee

Reporter

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.