The Order_Cl field determines whether a Purchase Order (PO) has been fully cleared. A value of “Y” indicates that all items from the PO have been received and no outstanding quantities remain. If the field is blank, the PO may still have pending items or requires verification.
Follow the steps below to review and update the status accordingly.
Open Housekeeping, Manual Update Trancode.
Select Manual Update Trancode (iclink.dbf) from ARPSO.
From the ARPSO table, select Purchase Order only.
From the Top row table, look for column Order_Cl.
This column requires the value "Y" when all outstanding orders from the PO are cleared.
If blank, check, for example, ItemNo for the RefNo. has QTY= 20 ToShip(PO) = 0 and Shipped (SO)=20.
This means shipped goods are equal in quantity in the bill.
The status of this bill should carry the value "Y" in Order_Cl Column.
You can also check the Bill Refno at the bottom table, how much QTY received should match Shipped (SO).
If there is an outstanding ToShip(PO), please clear off the outstanding Purchase Order in the goods received note bill when the stock arrives.
Order_Cl item will automatically be updated to value "Y" when all outstanding is cleared.
You can manually assign the value "Y" to order_cl for your own reasons.