GL Balance Purchase Order Report overview

General Ledger > Reports > GL Reports > GLRBP

Function acronym: GLRBP

Use this report to compare the balances in the Uninvoiced Inventory account codes (commonly known as Accrued Accounts Payable) to the total of all purchase orders that have been received but not fully costed (Stage 5 and Stage 6).

The Uninvoiced Inventory accounts are set up in GL Account Setup and posted to based on setups in SA Operator Setup-GL, Product Extended GL Distribution Setup, and SA Table Code Value Setup (PO Addons). The accounts are accrued liability accounts. Primary postings occur as credits during purchase order receiving and occur as debits during purchase order costing.

On the report, postings in Vendor Invoice Center Entry, and postings from GL Transaction Entry or other non-costing functions, are displayed as memos when the account is out of balance. Costing detail is also included on the report.

If you change the General Ledger setups in Product Extended GL Distribution Setup, SA Operator Setup-GL or SA Table Code Value Setup while any purchase orders are in Stage 5 (Received) or Stage 6 (Costed), you run the risk that a posting is made to one IC Uninvoiced Inventory account but taken out of a different account. This is considered to be an out-of-balance condition, but the cause of the problem cannot be determined from the report.

If you are using foreign currency, the purchase order uninvoiced addon amount, as well as the purchase amount, is converted to domestic currency.

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.

Close all open journals before you run this report. If a journal is open, the journal number, operator, function name, date and time print at the top of the report. Find the journal, close it, and then rerun the report.