Address: GLRBP
MENU: General Ledger > Reports > GL Reports > GLRBP
This report lists all PO line items that were received (either purchases or returns) that an invoice or credit has not yet been issued by the vendor.
Items are on this report because the vendor never invoiced or the quantity received was too much in error.
If the total of all uncosted purchase order lines does not equal the balance in the Uninvoiced Inventory account, the difference prints, as well as a notation as to whether the General Ledger is high or low.
There are 2 reasons why this report is used @ CentralTIS:
- To make sure that our subledger and general ledger are in balance for uninvoiced inventory. This only goes out of balance if a human makes an error.
- Notify the branches of items that may have returned to a vendor that credit was not given. When the credit comes, it is applied to the appropriate items and the rest open is left open.
- Twice annually these are closed out that credit was not issued. The branches are notified so they can try to dispute with the vendor to get the credit issued. If they are unsuccessful, it is closed out and the branch takes it as a loss because the credit was issued to the customer. Occasionally the branch will decide to bill back the customer for the returned item because we did not get credit from the vendor.
- Alternately, PO receipts are closed out that were not invoiced by the vendor. This is done twice annually. First the vendor statement is reviewed to see if there are any unpaid invoices that may have been missed. If not, the open PO receipt is closed. Generally, these are receiving mistakes (branch receives 100 in the system but only physically received 50 – vendor invoices for 50 leaving the 50 remaining uncosted). These errors offset cycle counts where the other 50 were ‘lost’ in a negative inventory adjustment. First and foremost, we try to correct receiving mistakes through corrections, but if the branch insists they got the extra it gets closed out and works itself out in the GL.
How to manually run the report
Select the existing stored report
Click <Copy> <One Time>
Update the email address, if necessary.
Click <NEXT>
Click <NEXT>
Click <NEXT>
Options page:
Example 1: The PO has been received. Vendor Invoice has not been processed against the Received PO. Per the PO entry and receipt, operations says that we owe the vendor 574.64 for line 2 and 1055.04 for line 1.
This is the most common occurrence.
POIP – PO Inquiry
This POIP > Header display shows that the PO is in received stage.
POIP > Line Detail shows the same values as the report.
Example 2: The credit granted by the vendor was less than what was entered and received on the RM PO. This is one of 5 items out of on this Return PO on the report. Items are not always listed together on the report.
Notice below: both lines 12 and 13 have a Received Quantity different than Invoiced Quantity.
Example 3: The Return PO is in the received stage and the Vendor Credit has not yet been processed. There are actually a total of 17 line items on the PO and the Report. These individual line items do not group themselves together.
Example 4: Item Received. Vendor did not invoice for this item. Other items on the PO receipt were invoiced and paid.
Example 5: Item received Qty 7 @ 117.81. Vendor has not yet invoiced. Item has a ZERO Average cost.
ICIP > General > BALANCES
