Accounts Receivable β€” Create Batch from Invoices
Combine invoices into a single customer statement.

Overview

Create Batch from Invoices groups invoices by customer into a single Statement# (also called Batch#) using a date range. You may run it for a specific customer or for all customers flagged for Batch Billing.

Create Batch from Invoices screen
Figure 1. Create Batch β€” parameters and posting commands.

Prompts & Parameters

  • 1. Department# or (A)ll β€” Limit to a single Department code or enter A for all.
  • 2. Customer or (A)ll β€” Enter a customer code or A for all customers that are marked for Batch Billing in Customer Setup.
  • 3. Invoice Start Date β€” Beginning of the invoice created date range.
  • 4. Invoice End Date β€” End of the invoice created date range.
  • 5. Maximum Statement Amount β€” (Optional) Cap statements at this amount.
  • 6. Statement Date β€” Date printed on the resulting statement(s)/batch header; must be in an open period.

NOTE: The system selects invoices created in the specified range which have not previously been placed in a batch.

Create Batch β€” Steps

  1. Fill in the Department and Customer (or choose A for All).
  2. Enter Invoice Start Date and Invoice End Date.
  3. (Optional) Specify a Maximum Statement Amount if you want large totals split across statements.
  4. Enter the Statement Date.
  5. At the command prompt choose:
    • Line# β€” Jump back to a prompt number to revise it.
    • Q β€” Quit without posting.
    • P β€” Post to create batches/statements.

After posting, system will display the View Batches screen allowing you to Edit or Print statements.

Notes & Rules

  • Only invoices within the date range and not already in a batch are eligible.
  • If Customer = A, only customers flagged for Batch Billing are included (see the Billing screen in Customer Setup).
  • Statement Date must be in an open accounting period.
  • Each created batch receives a unique Statement# (Batch#) used later in Cash Posting to apply deposits to all invoices at once.

Troubleshooting

  • No statements created β†’ Check your date range and confirm selected invoices aren’t already in a batch.
  • Some customers missing β†’ Ensure they are flagged for Batch Billing in Customer Setup.
  • Totals exceed cap β†’ Lower the Maximum Statement Amount or allow multiple statements.