(JPN) About consolidating invoices
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 |
See also
(JPN) Set up a consolidated invoice for a customer
(JPN) Set up the terms of payment and the cutoff day for a customer
(JPN) Create, confirm, reopen, and print a consolidated customer invoice
(JPN) Mark sales invoices for consolidation and calculate due dates
(JPN) Settle customer consolidated invoices by using a payment journal
(JPN) Settle customer consolidated invoices by using a payment proposal
(JPN) Set up a consolidated invoice for a vendor
(JPN) Set up the terms of payment and the cutoff day for a vendor
(JPN) Create, confirm, reopen, and print a consolidated vendor invoice
(JPN) Mark purchase invoices for consolidation and calculate due dates
(JPN) Settle vendor consolidated invoices by using a payment journal
(JPN) Settle vendor consolidated invoices by using a payment proposal
Tareas clave: carta de crédito o remesa documentaria para la importación de artículos
Tareas clave: carta de crédito para la exportación de mercancías