Automatic Calculation and Adjustment of Closing Date and Payment Due Date on Transactions

The system automatically calculates the closing and payment due dates on transactions based on the Japan payment terms defined on their corresponding customer, vendor or employee records. These entity records must have defined payment terms to trigger automatic calculation of closing and due dates on their transactions, while for invoices and credit memos, Include in Invoice Summary must also be checked.

Upon creation of transactions for entities with defined payment terms, the system automatically calculates the closing date nearest the transaction date as well as its corresponding payment due date. For example, an invoice created for a customer with defined payment terms will set automatic calculation of closing date and due date on that invoice. The same automatic calculation is set for the closing date and due date of a bill created for a vendor with payment terms, or an expense report created for an employee with payment terms. This is applied in all transactions of entities with payment terms, even if the transaction is created through the user interface, CSV import, SuiteScript or web service.

If you want to move the transaction to a different billing period, you can change the closing date in an invoice and credit memo to a different date, and the system will automatically calculate its corresponding payment due date. The automatic calculation of the payment due date based on the selected closing date doesn't prevent you from changing the payment due date. When changing the due date, the closing date must be on or after the transaction date, and the same as the closing date in the payment terms. These are validated in every calculation; otherwise, an error is displayed and you won't be able to save the transaction.

Editing invoices with Include in Invoice Summary box checked triggers automatic calculation if you change the customer or transaction date. Automatic calculation is also applied in a new invoice created as standalone, from sales order or estimate, or copied from an old invoice.

Likewise, for credit memos with Include in Invoice Summary checked, the same automatic calculation is performed for the Invoice Summary Date and Invoice Summary Due Date, based on the payment terms. The Invoice Summary Date in a credit memo corresponds to the Closing Date in an invoice, and the Invoice Summary Due Date corresponds to the Due Date. You can change the Invoice Summary Due Date to specify a different date, provided that is it on or after the transaction date.

You can't edit the closing date on bills and expense reports.

General Notices