Balancing payment tendering accounts

The GL Balance Order Entry Report provides detail transactions against the Tendering GL accounts that are set up in SA Table Code Value Setup-Payment Type. Ranges and options enable you to process by merchant ID, payment type, credit card accounts only, and to sort by division, warehouse, merchant ID, or payment type.

In addition, the report output lists expired authorizations. If the credit card authorization has expired, ‘Authorization’ is displayed. This column is included in the report when you select Print Detail.

  1. Select General Ledger > Reports > GL Reports > Balance Order Entry Report.
  2. Click New > One Time.
  3. Specify the report, printing, and scheduling information.
  4. Click Next.
  5. Optionally, specify one or more ranges and click Next.
    Note: Merchant IDs are set up in SA Table Code Value Setup-Merchant ID (Credit Card). They are associated with a warehouse in Product Warehouse Description Payment Type Setup, or at the company level with payment types in SA Table Code Value Setup-Payment Type. The report checks for a merchant ID within the range in Product Warehouse Description Payment Types Setup first, then in SA Table Code Value Setup.
  6. Specify these options:
    • Print the report in detail or in summary.
    • Print open journals.
    • In Credit Card Accounts Only, select Yes to only print detail for the Tendering GL accounts defined in SA Table Code Value Setup-Payment Type-Additional Information for all credit card payment types. Balancing information for any non-credit card GL accounts will be excluded from the report.
    • In Sort By W)hse, D)iv, M)erch or P)rocessor, specify whether to sort the detail by warehouse, division, merchant ID or processor. Specify a sort method if you have selected Yes to Print Detail?.
  7. Click Save.