GL Balance Order Entry Report overview

General Ledger > Reports > GL Reports > GLRBO

Function acronym: GLRBO

Use this report to compare the balances of the OE Uninvoiced Cash Sales and OE Down Payments account codes to Sales Order Entry orders.

The OE Uninvoiced Cash Sales and OE Down Payments account codes are set up in SA Operator Setup-GL. The Sales Order Entry orders are in Stage 1 (Ordered), Stage 2 (Picked), or Stage 3 (Shipped) and are cash sales or orders with down payments. Received on account orders are not included in this report.

The OE Uninvoiced Cash Sales and OE Down Payment accounts are clearing accounts. They store the amount of cash receipts until an invoice is processed. GL Balance Order Entry Report identifies unprocessed orders. The operator's initials from the transaction are used to identify which General Ledger account was updated. This helps to identify orders that may have updated GL Suspense accounts in error, if the correct defaults were not set up in SA Setup Operator-GL.

If an operator's GL defaults are changed after the initial set up of SA Setup Operator-GL records, you cannot balance any uninvoiced cash orders or down payment transactions posted by that operator before the GL defaults were changed. If you expect to change an operator's General Ledger defaults, run all GL Balancing Reports first.

The report displays information about the order; such as customer, date, and tendered and invoice totals if you select to print detail.

Accounts are considered out of balance if the balances of the OE Uninvoiced Cash Sales and OE Down Payments accounts do not match the amounts of open Sales Order Entry orders.

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.

When you use a warehouse range with no orders to run this report, it does not include GL account numbers. If you run this report by division range and without a warehouse range, the report prints GL account numbers within the division range. This occurs even when no orders fall within in the division range.

A payment type code from SA Table Code Value Setup or zero for tendered amount that is adjusted to a back order is displayed in the Media column. If the transaction is an adjustment, (Adj) is displayed next to the code in the Media column. If there was a refund, the refund payment type code and the label (Chg) are displayed. The (Chg) label indicates the "change due" GL transaction for the refund.

This table shows an example of what displays on the report for a fully tendered order with a backorder. In the example, cash is media code 4 and a check is media code 5.
Order # Media Amount Tendered Invoice Amount
5894-00 0 (Adj) 10.42 15.32
5 15.32-
5894-01 0 (Adj) 10.42-
This table shows an example of what displays on the report for an order that was $15.32. A customer tendered a $20.00 check and received a refund of $4.68.
Order # Media Amount Tendered Invoice Amount
5894-00 5 20.00 15.32
4 (Chg) 4.68