How to complete a drop shipped purchase order currently in Open status in Sage 100
Resolution
- If the purchase order has not been invoiced completely, then a Receipt of Invoice for the remaining amount must be created and updated in order to complete the purchase order.
- Open Purchase Order, Main, Receipt of Invoice Entry to enter the Receipt of Invoice for the Purchase Order. Accept and Update
- If the purchase order has been invoiced in full or if the original ordered quantity was overstated and no more invoices will be received, then the “Ordered” quantity must be changed to match the “Invoiced” quantity (found on the Open P/O Report) in Purchase Order entry, and then a $0 Receipt of Invoice must be created and updated to change the PO status from “Open” to “Completed”.
- Open Modules, Purchase Order, Reports, Open Purchase Order Report and print this report for All Statuses to review the reason why the PO is still open. In order for a PO to be “completed”, the Ordered, Received and Invoiced quantities should match. In the case of a drop shipped Purchase Order (where the items are not received), only the quantity ordered and quantity received should match.
- Open Purchase Order Entry, enter the PO number in question, go to the Lines tab and change the Ordered quantity for the item(s) in question to match the Invoiced quantity from the report. Accept the order.
- Open Receipt of Invoice Entry and create a new invoice for the purchase order referenced above. Enter a new Invoice number, then go to the Lines tab and click Yes to the Invoice complete purchase order? prompt.
- Since the Ordered quantity now matches the Invoiced quantity, the Invoice Total in the Totals tab should be $0. Accept the Invoice.
- Select Daily Receipt Registers/Update to print/preview the Register. Update the Register.
- Print/Preview the Daily Transaction Register. Since this was a $0 dollar invoice, the message “The file is empty” should appear unless there were other receipts being updated.
- Open Purchase Order Entry and enter the purchase order number. The order status should have changed from Open to Completed
- If the quantity invoiced is equal to the quantity ordered for all items on the Lines tab of the purchase order and the order status will not change to Completed enter and update an additional receipt of invoice with only a comment line.
- Add one more receipt of invoice and add a comment line
- Open Purchase Order, Main, Receipt of Invoice Entry
- Enter a new receipt of invoice
- On the Lines tab enter a new /C comment line
- On the Totals tab verify that all amounts are $ 0.00
- Click Accept
- Select Daily Receipt Registers/Update to print/preview the Register. Update the Register.
- Print/Preview the Daily Transaction Register. Since this was a $0 dollar invoice, the message “The file is empty” should appear unless there were other receipts being updated.
- Add one more receipt of invoice and add a comment line