Stock in Transit quantity discrepancy with PO Quantity while doing Delivery.
Issue:
When conducting deliveries based on purchase orders (PO), such as stock transfer orders, the PO may consist of multiple line items with varying quantities and different units of measures. Occasionally, quantities, particularly for food products, may involve decimals.
In such instances, the accurate transfer of quantities to transit and the proper updating of the corresponding MSSQ table may encounter challenges due to rounding issues.
Due to these discrepancies, there will be slight variations between the quantity specified in the purchase order (PO) and the stock in transit.
This leads to a quantity discrepancy that prevents users from performing the Post Goods Issue (PGI).
The specific error is as follows:
The Root Cause of the Issue:
Typically, in such instances, the stock in transit appears accurate, but discrepancies arise in the MSSQ table due to rounding issues stemming from the purchase order (PO).
According to the current calculation, 10.140 B17 equals 0.511 MT. However, the MSSQ table reflects only 0.506 MT, leading to an error during the Post Goods Issue (PGI) process, indicating that the quantity exceeds by 0.005 MT.
When attempting to post the differential quantity using 561, it should impact the Work Breakdown Structure (WBS) as the material is associated with project stock.
Solution:
The resolution involves executing MIGO with movement type 558.
Below fields are the Inputs in MIGO
- Transaction code: MIGO.
- Type: Goods Issue.
- Reference Document: Others.
- Movement type: 558 with Project Stock – Q
- Material: - XXXXXXXXXX
- Quantity: - 0.005
- WBS: XXXX.XX.XXX.XXXX
- Batch: 7XXXXXXXXX
After MIGO:
Following the MIGO process with movement type 558, the stock will be corrected, and the system will permit the Post Goods Issue (PGI).
Implementing this solution will have no impact on the actual quantity and budget.
Parameters required:
- Difference Quantity.
- WBS Element.
- Movement type 558.
Summary:
In instances where stock discrepancies arise between purchase orders (PO) and deliveries, caused by rounding issues, and particularly for Work Breakdown Structure (WBS) based materials, the recommended solution is to use the MIGO transaction with movement type 558 to post the differential quantity.
This approach ensures that the stock is adjusted without affecting the actual quantities or budget.
