| | Qty On PO is incorrectly calculated when using Rebuild Sort Files |
| Cause | Defect causes an erroneous calculation on Purchase Orders where the PO is open and all lines are complete/received. |
| Resolution | | Engineering is working to resolve the issue |
| Steps to duplicate | | Assumes a Purchase Order exists in a open state
1. Go to Inventory Management, Main, Inventory Inquiry
2. Select Part 147100
3. Library Master, Utilities, Rebuild Sort Files
4. Rebuild Inventory Sort files for Purchase Order
5. Click "Yes" to "Do you want to recalculate open purchase order quantities in the item warehouse file?
6. Go to Inventory Management, Main, Inventory Inquiry
7. Select Part 147100
8. Notice the quantity on PO is still incorrect.
Using the SQL Management Console run the following query:
select distinct PO_PurchaseOrderHeader.PurchaseOrderNo from PO_PurchaseOrderHeader inner join PO_PurchaseOrderDetail on PO_PurchaseOrderHeader.PurchaseOrderNo = PO_PurchaseOrderDetail.PurchaseOrderNo where PO_PurchaseOrderDetail.QuantityOrdered = PO_PurchaseOrderDetail.QuantityReceived and PO_PurchaseOrderHeader.OrderStatus = 'O' and PO_PurchaseOrderDetail.ItemCode = '147100'
Note the PO number open the PO in Purchase Order Entry
Notice the lines are complete and received but the PO is listed as open |
|