(JPN) About consolidating invoices [AX 2012]

Updated: July 27, 2012

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

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

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


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

社区附加资源

添加
显示: