Mismatch between Created (Attribute Set Instance) and Date Material Policy (Storage On Hand)

Description

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.

Environment

None

Activity

Show:
Carlos Ruiz
April 8, 2015, 5:01 PM

Thanks - can you please test the attached alternate patch IDEMPIERE-2564_CR.patch

Tomáš Švikruha
April 9, 2015, 5:45 AM

Hi , your patch looks fine, can be commited.

Tomáš Švikruha
December 18, 2015, 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?

Norbert Bede
December 18, 2015, 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

Assignee

Tomáš Švikruha

Reporter

Tomáš Švikruha

Labels

Tested By

None

Due date

2015/04/07

Priority

Major
Configure