@lubos, First a very HAPPY NEW YEAR TO YOU
The problem being encountered is exactly as described in the Subject. The problem relates to adjustment of consumed q’ty of certain items of bill of materials entered in production orders in selected location. It came to our notice while making a check recently of transaction in inventory locations. It is noticed that in occasional instances, quantities of certain item of bill of material in production orders are not adjusted correctly in selected inventory location according to input q’ty in production orders (rather partial q’ty adjusted or sometimes zero “0” in selected inventory location and rest q’ty in unspecified location ). We don’t know why and we don’t see any reason/logic for the system to show partial quantity adjustment in selected location and the rest in a different “unspecified location” when we can see that there is balance q’ty available in those location. Strangely, once, this anomaly occurs, then quantities in all subsequent transaction for that item is entered as ZERO “0” and corresponding q’ty gets posted to unspecified location . We tried to delete and create the production orders again & again, but the problem continues and transaction doesn’t seem to be corrected for its behavior of erroneous input. Further, from thereon till today, the quantity is always adjusted as ZERO “0” quantity regardless of whatever contained in Production Order. This is true for all locations affected with the above problem.
Please see screen shots of scenario A B & C
In scenario “A” – Reference Inventory Item : [LOG ROLL – LION ]; Inventory location: Production (Factory), transaction were going on smoothly until 21/12/2018. On 21/12/2018, as may be seen in screen shot of “production order” , the consumed quantity of first item of bill of materials is 1000 but it adjusted 369 in selected location while the balance was sent to unspecified location.
In scenario “B” – Refer to Inventory Item: CUT ROLL - DEER 10Y ; Inventory location: Lalbagh Warehouse & Production (Factory), transaction were going on smoothly until 15/11/2018. Interestingly, the trouble started in the two locations from the same date on 17/11/2018 simultaneously for the same inventory item.
Location : Lalbagh Warehouse
As may be seen from screen shot of “production order", the consumed quantity of first item of bill of materials is 13800 but it adjusted as 0 in selected location while the same q’ty was sent to unspecified location. From thereon, all the quantity takes as zero “0” regardless of the consumed q’ty in the production order.
Location : Production (Factory)
As may be seen from screen shot of “production order” , the consumed quantity of first item of bill of materials is 13800 but it adjusted as ZERO “0” in selected location while the same q’ty was sent to unspecified location . From thereon, all the quantity takes as ZERO “0” regardless of the consumed q’ty in the production order.
- In scenario “C” – Refer to Inventory Item: M/CTN - DEER-10Y ; Inventory location: Lalbagh Warehouse, This is a different case.** The transaction was opened on 04/10/18. From the very first day, the adjustment quantity was Zero “0” regardless of the input of consumed quantity in the Production Order and the corresponding q’ty was posted in unspecified location.
We are very concerned & confused with the above situation that could be disastrous for our accounting & inventory management. Please do something fast to correct the problem.
@lubos, anticipating that you may need the back up file for replicating the problem, we are sending the same by separate email.
Rgds / M. Sultan