(JPN) About consolidating invoices

Article
11/29/2021

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

You can consolidate several vendor invoices, purchase orders, purchase returns, and purchase journals into a consolidated vendor invoice for payment instead of issuing payments for the separate vendor transactions. You can also consolidate customer invoices, sales orders, sales returns, and sales journals into a customer consolidated invoice that you can send to the customer.

You can create two or more consolidated invoices on the same day for a customer or for a vendor. After you create a consolidated invoice for a customer or for a vendor, you can pay the vendor or receive payment from the customer and settle the consolidated invoice for the amount of the payment.

The following calculations are performed for a consolidated invoice:

Invoice amount
Due date

Calculating the invoice amount for a consolidated invoice

After you create and confirm a consolidated invoice in the Consolidated invoice form, the following amounts are calculated:

Previous invoice amount – The total invoice amount for the previous consolidation period.
Previously paid amount – The total amount paid for the previous consolidation period.
Adjustment amount – The adjustment amount for the previous consolidation period. The adjustment amount includes cash discounts and bank charges.
Outstanding amount – The total outstanding amount for the current consolidation period. The outstanding amount is calculated by using the following formula:

Previous invoice amount – Paid amount – Adjustment amount
Invoice amount during consolidation period – The total invoice amount in the current consolidated invoice. This amount includes the sales tax.
Total invoice amount – The new total invoice amount for the current invoice. This amount is calculated by using the following formula:

Outstanding amount + Invoice amount during consolidation period

Calculating the due date for a consolidated invoice

Invoices are consolidated each month, based on the consolidation day that you specify for each vendor or customer. This consolidation day determines the day and period for which invoices are consolidated, and the date that payment is due.

If the last day of the month falls on a date that is earlier than the consolidation day that you specify, the invoices are consolidated on the last business day of the month. If you specify 31 for the consolidation day, and the current month has fewer than 31 days, the invoices are consolidated on the last business day of that month. For example, the invoices for June 2012 are consolidated on June 29, 2012, because that is the last business day of the month.

The following table shows how the payment due date is calculated for invoices that are generated on different days. The consolidation day is 10, and the payment date is the end of the month.

Invoice number	Invoice date	Consolidation day	Due date
INV001	May 04, 2012	May 10, 2012	June 29, 2012
INV002	May 10, 2012	May 10, 2012	June 29, 2012
INV003	May 18, 2012	June 10, 2012	July 31, 2012
INV004	June 08, 2012	June 10, 2012	July 31, 2012

(JPN) About consolidating invoices

Calculating the invoice amount for a consolidated invoice

Calculating the due date for a consolidated invoice

See also

Additional resources