Cannot void Inventory Move when Disallow negative inventory is active
Description
1. We have product Elm and it located at: warehouse Fertilizer = 122 each (DateMaterialPolicy = 08/18/2015) warehouse HQ = 15 each (DateMaterialPolicy = 01/22/2003)
Tick the check-box "Disallow Negative Inventory" at warehouse Furniture.
2. Create document Internal Move #10000002 and complete it HQ -> Furniture Elm 10 each
Then we have at M_StorageOnHand: warehouse Fertilizer = 122 each (DateMaterialPolicy = 08/18/2015) warehouse HQ = 5 each (DateMaterialPolicy = 01/22/2003) warehouse Furniture = 10 each (DateMaterialPolicy = 01/22/2003)
3. Create document Internal Move #10000003 and complete it Furniture -> Store Central Elm 10 each
Then we have at M_StorageOnHand: warehouse Fertilizer = 122 each (DateMaterialPolicy = 08/18/2015) warehouse HQ = 5 each (DateMaterialPolicy = 01/22/2003) warehouse Furniture = 0 each (DateMaterialPolicy = 01/22/2003) warehouse Store Central = 10 each (DateMaterialPolicy = 01/22/2003)
4. Create document Internal Move #10000004 and complete it Fertilizer -> Furniture Elm 10 each
Then we have at M_StorageOnHand: warehouse Fertilizer = 112 each (DateMaterialPolicy = 08/18/2015) warehouse HQ = 5 each (DateMaterialPolicy = 01/22/2003) warehouse Furniture = 0 each (DateMaterialPolicy = 01/22/2003) warehouse Furniture = 10 each (DateMaterialPolicy = 08/18/2015) warehouse Store Central = 10 each (DateMaterialPolicy = 01/22/2003)
Total at warehouse Furniture we have 10 each now. But if we try to void (reverse correct) document Internal Move #10000002 we take exception "Negative inventory disallowed in this warehouse". It occur because system try to take 10 each from Furniture with DateMaterialPolicy = 01/22/2003.
all documents have MovementDate = 08/19/2015
Environment
None
Activity
Show:
Anna Fadeeva September 17, 2015 at 10:57 AM
, Thank's for link
Anna Fadeeva September 17, 2015 at 10:55 AM
I think it's not right.
Anna Fadeeva September 17, 2015 at 10:54 AM
Edited
, , In Palichmos we have next example: 1) complete inventory movement from WH 1 to WH 2 with movement date 10-09-2015 and DateMaterialPolisy 01-08-2015. We have 10 products in WH2 at 10-09-2015 2) Next complete inventory movement from WH 2 to other WH with earlier then 10-09-2015, for ex. 08-09-2015, and DateMaterialPolisy 01-08-2015. But we had no these products at 08-09-2015. The System completed movement because the DateMaterialPolisy more early then movementdate 08-09-2015. 3) If DateMaterialPolisy was equal to movementdate of second movement, than the System could not complete it
WDYT?
Deepak Pansheriya September 17, 2015 at 10:37 AM
Anna,
Look at ticket for understanding DateMaterialPolicy.
Anna Fadeeva September 17, 2015 at 7:40 AM
Hi Carlos, can you tell me where I can read about concept of DateMaterialPolicy?
1. We have product Elm and it located at:
warehouse Fertilizer = 122 each (DateMaterialPolicy = 08/18/2015)
warehouse HQ = 15 each (DateMaterialPolicy = 01/22/2003)
Tick the check-box "Disallow Negative Inventory" at warehouse Furniture.
2. Create document Internal Move #10000002 and complete it
HQ -> Furniture
Elm 10 each
Then we have at M_StorageOnHand:
warehouse Fertilizer = 122 each (DateMaterialPolicy = 08/18/2015)
warehouse HQ = 5 each (DateMaterialPolicy = 01/22/2003)
warehouse Furniture = 10 each (DateMaterialPolicy = 01/22/2003)
3. Create document Internal Move #10000003 and complete it
Furniture -> Store Central
Elm 10 each
Then we have at M_StorageOnHand:
warehouse Fertilizer = 122 each (DateMaterialPolicy = 08/18/2015)
warehouse HQ = 5 each (DateMaterialPolicy = 01/22/2003)
warehouse Furniture = 0 each (DateMaterialPolicy = 01/22/2003)
warehouse Store Central = 10 each (DateMaterialPolicy = 01/22/2003)
4. Create document Internal Move #10000004 and complete it
Fertilizer -> Furniture
Elm 10 each
Then we have at M_StorageOnHand:
warehouse Fertilizer = 112 each (DateMaterialPolicy = 08/18/2015)
warehouse HQ = 5 each (DateMaterialPolicy = 01/22/2003)
warehouse Furniture = 0 each (DateMaterialPolicy = 01/22/2003)
warehouse Furniture = 10 each (DateMaterialPolicy = 08/18/2015)
warehouse Store Central = 10 each (DateMaterialPolicy = 01/22/2003)
Total at warehouse Furniture we have 10 each now.
But if we try to void (reverse correct) document Internal Move #10000002 we take exception "Negative inventory disallowed in this warehouse".
It occur because system try to take 10 each from Furniture with DateMaterialPolicy = 01/22/2003.
all documents have MovementDate = 08/19/2015