Specifying Search Criteria for Transactions for Inclusion in the Invoice Summary

You must first specify a search criteria for transactions you want to include in the invoice summary to be generated.

To specify search criteria for transactions to be included in the invoice summary:

  1. Using the Classic Center, go to Transactions > Customers, and at the bottom of the list, click Generate Invoice Summary.

    If you're using the Accounting Center, go to Customers > Accounts Receivable.

    If you're using the Sales Center, go to Customers > Transactions.

  2. On the Generate Invoice Summary page, specify the search criteria for transactions to be included in the invoice summary:

    1. If you're using a OneWorld account, in the Subsidiary field, select a subsidiary whose customers you want to generate an invoice summary for. Change the default value of the Subsidiary field, which initially indicates your subsidiary.

      You must first specify a value for the Subsidiary field before the Customer field.

    2. In the Customer field, select a customer. You can select only one customer at a time.

      Another option is to select a customer saved search from the Customer Saved Search field. To use this field, you must have created a customer saved search and select it. Or, you can select the ready-made Japan Customer Saved Search, which comes with the Japan Localization SuiteApp.

      You can only specify a value for either the Customer field or Customer Saved Search field, not both. If both Customer Saved Search and Customer fields are left blank, the search result will display the transactions of all customers that belong to the subsidiary you selected.

      If you're using a OneWorld account, clicking Search without selecting any customer will include in the search result all customers associated with the subsidiary. If you're not using a OneWorld account, and didn't specify a customer, the search result will include all customers.

    3. In the Closing Date field, specify the closing date. Enter a date, or pick a date using the calendar icon next to the field. The Closing Date you selected is indicated as the Statement Date in the search results page.

      If a value you selected for a search filter causes an error or if there are no search results, click Return to Search Criteria to edit the filters and select a different subsidiary or closing date.

    4. (Optional) If you want to include in the invoice summary customers with no invoices, credit memos or closed or canceled sales orders created in the current billing period, check the Include Customers With No Current Invoices and Credit Memos box. Only customers with closing date in their payment terms that is the same as the closing date used in the search filter will be included. Generating an invoice summary even if there are no transactions in the current billing period can be useful if you want to inform a customer about any of these:

      • an unpaid balance from previous a billing period,

      • payments received in the current billing period (full payment or overpayment), or

      • no recent transactions (no unpaid balance from previous billing or payments received in the current billing period).

    5. (Optional) If you want to include overdue invoices, those not paid on or before the due date, check the Include Overdue Invoices box. If this box is checked, overdue invoices from the previous invoice summary that are open as of the closing date and whose transaction closing date is the same as the closing date of the payment term, will be included. In case of partial payments, only the unpaid amount is displayed in the Invoice Details section of the generated invoice summary PDF file.

  3. Click Search.

    A search results page is displayed that list customers and details of invoice summary generation.

General Notices