Set up parameters to calculate invoice issue due dates [AX 2012]

Updated: May 23, 2014

Applies To: Microsoft Dynamics AX 2012 R3

This topic explains how to set up parameters to calculate the due dates for issuing customer invoices and vendor invoices.

You can set up a date interval code, and then set up an invoice issue date calculation rule by assigning the date interval code to a country/region type. The calculation rule is used to calculate the due date for issuing invoices for the following transactions:

  • Intra-European Union (EU) shipments

  • Domestic shipments within an EU member state

You can also set up date controls to ensure that customer invoices and credit notes for customer transactions are generated within the specified time period after the delivery is made.

To set up Microsoft Dynamics AX to calculate invoice issue due dates for Intra-EU shipments on the 15th day of the next month after the supply is delivered, create a date interval code and a calculation rule with the following settings:

  • Date interval code

    Field

    Value

    Date interval code

    15-NM

    Description

    15th day of the next month

    Before 
    (In the To date field group)

    Month

    Start/End 
    (In the To date field group)

    End

    +/- 
    (In the To date field group)

    15

    Days, months, years or periods 
    (In the To date field group)

    Days

  • Invoice issue due date calculation rule

    Field

    Value

    Country/region type

    EU

    Start date

    Set up the date from which the current setup line is valid.

    Date interval code

    15-NM

The following table shows the prerequisites that must be in place before you start.

Category

Prerequisite

Version

Microsoft Dynamics AX 2012 R3

Country/region

The primary address for the legal entity must be in the following countries/regions: EU member state

Related setup tasks

  • Set up a date interval that is used to calculate the invoice issue due date. For more information, see Date intervals (form).

  • Set up foreign trade properties for various countries or regions in the Foreign trade parameters form. For more information, see Foreign trade parameters (form).

Use the Set up calculation for invoice issue due date form to set up an invoice issue due date calculation rule by assigning a date interval code to a country/region type.

To perform this task, follow these steps:

  1. Click General ledger > Setup > Set up calculation for invoice issue due date.

  2. Click New or press CTRL+N to create a record.

  3. In the Country/region type field, select one of the following options for the country/region type:

    • EU – The calculation rule applies to shipments within the EU.

    • Domestic – The calculation rule applies to the domestic deliveries within a single EU member state.

    • EFTA – The calculation rule applies to countries in the European Free Trade Association (EFTA).

    • Third country/region – The calculation rule applies to a country/region that is not domestic, a member of the EU, nor a member of the EFTA.

  4. In the Start date field, enter the starting date from which the calculation rule is valid.

  5. In the Date interval code field, select the date interval code that is used to calculate the invoice issue due dates for the selected country/region type.

Use this procedure to set up date control parameters that are used to ensure that customer invoices and credit notes for customer transactions are generated within the specified time period after the delivery is made.

NoteNote

This procedure applies only if the primary address of your legal entity is in an EU member state other than Poland or Hungary.

To perform this task, follow these steps:

  1. Click Accounts receivable > Setup > Accounts receivable parameters.

  2. In the Accounts receivable parameters form, click Updates.

  3. In the Updates area, specify the date control for customer invoices and credit notes.

    Field

    Description

    Invoice date control 
    (In the Invoice dates control field group)

    Select one of the following options to indicate the date control that is applied when the invoice date on the customer invoice is later than the invoice issue due date on the packing slips that are included in the invoice:

    • None – No date control is displayed.

    • Warning – A warning message is displayed when you attempt to post the customer invoice. However, you can complete the posting process.

    • Error – An error message is displayed when you attempt to post the customer invoice. In this case, you cannot complete the posting process.

    Document date control 
    (In the Invoice dates control field group)

    Select one of the following options to indicate the date control that is applied when the document date on a customer invoice is later than the invoice issue due date on the packing slips that are included in the invoice:

    • None – No date control is displayed.

    • Warning – A warning message is displayed when you attempt to post the customer invoice. However, you can complete the posting process.

    • Error – An error message is displayed when you attempt to post the customer invoice. In this case, you cannot complete the posting process.

    Invoice date control 
    (In the Credit note dates control field group)

    Select one of the following options to indicate the date control that is applied when the invoice date on the credit note is later than the invoice issue due date on the packing slips that are included in the credit note:

    • None – No date control is displayed.

    • Warning – A warning message is displayed when you attempt to post the customer invoice. However, you can complete the posting process.

    • Error – An error message is displayed when you attempt to post the customer invoice. In this case, you cannot complete the posting process.

    Document date control 
    (In the Credit note dates control field group)

    Select one of the following options to display a message when the document date on the credit note is later than the invoice issue due date on the packing slips that are included in the credit note:

    • None – No message is displayed.

    • Warning – A warning message is displayed when you attempt to post the customer invoice. However, you can complete the posting process.

    • Error – An error message is displayed when you attempt to post the customer invoice. In this case, you cannot complete the posting process.

  4. Optional: In the left pane, click Summary update.

  5. Optional: In the Summary update area, select the Delivery information check box for the Packing slip to produce one packing slip per sales order line delivery address when posting.

Use this procedure to set up date control parameters that are used to ensure that customer invoices and credit notes for customer transactions are generated within the specified time period after the delivery is made.

NoteNote

This procedure applies only if the primary address of your legal entity is in Poland.

To perform this task, follow these steps:

  1. Click Accounts receivable > Setup > Accounts receivable parameters.

  2. In the Accounts receivable parameters form, click Updates.

  3. In the Updates area, specify the date control for customer invoices and credit notes.

    Field

    Description

    Invoice date control 
    (In the Invoice dates control field group)

    Select one of the following options to indicate the date control that is applied when the invoice date on the customer invoice is later than the invoice issue due date on the packing slips that are included in the invoice:

    • None – No date control is displayed.

    • Warning – A warning message is displayed when you attempt to post the customer invoice. However, you can complete the posting process.

    • Error – An error message is displayed when you attempt to post the customer invoice. In this case, you cannot complete the posting process.

    Document date control 
    (In the Invoice dates control field group)

    Select an option to indicate the date control that is applied for the following conditions:

    • The document date on a customer invoice is later than the invoice issue due date on the packing slips that are included in the invoice.

    • The document date is later than the sales date plus the number of days that you specified in the +/- field for the date interval.

    The options for this field are:

    • None – No date control is displayed.

    • Warning – A warning message is displayed when you attempt to post the customer invoice. However, you can complete the posting process.

    • Error – An error message is displayed when you attempt to post the customer invoice. In this case, you cannot complete the posting process.

    Invoice date control 
    (In the Credit note dates control field group)

    Select one of the following options to indicate the date control that is applied when the invoice date on the credit note is later than the invoice issue due date on the packing slips that are included in the credit note:

    • None – No date control is displayed.

    • Warning – A warning message is displayed when you attempt to post the customer invoice. However, you can complete the posting process.

    • Error – An error message is displayed when you attempt to post the customer invoice. In this case, you cannot complete the posting process.

    Document date control 
    (In the Credit note dates control field group)

    Select one of the following options to display a message when the document date on the credit note is later than the invoice issue due date on the packing slips that are included in the credit note:

    • None – No message is displayed.

    • Warning – A warning message is displayed when you attempt to post the customer invoice. However, you can complete the posting process.

    • Error – An error message is displayed when you attempt to post the customer invoice. In this case, you cannot complete the posting process.

  4. Optional: In the left pane, click Summary update.

  5. Optional: In the Summary update area, select the Delivery information check box for the Packing slip to produce one packing slip per sales order line delivery address when posting.

Use this procedure to set up date control parameters that are used to ensure that customer invoices and credit notes for customer transactions are generated within the specified time period after the delivery is made.

NoteNote

This procedure applies only if the primary address of your legal entity is in Hungary.

To perform this task, follow these steps:

  1. Click Accounts receivable > Setup > Accounts receivable parameters.

  2. In the Accounts receivable parameters form, click Updates.

  3. In the Updates area, specify the date control for customer invoices and credit notes.

    Field

    Description

    Invoice date control 
    (In the Invoice dates control field group)

    Select one of the following options to indicate the date control that is applied when the invoice date on the customer invoice is later than the invoice issue due date on the packing slips that are included in the invoice:

    • None – No date control is displayed.

    • Warning – A warning message is displayed when you attempt to post the customer invoice. However, you can complete the posting process.

    • Error – An error message is displayed when you attempt to post the customer invoice. In this case, you cannot complete the posting process.

    Document date control 
    (In the Invoice dates control field group)

    Select an option to indicate the date control that is applied for the following conditions:

    • The document date on a customer invoice is later than the invoice issue due date on the packing slips that are included in the invoice.

    • The document date is later than the sales date plus the number of days that you specified in the +/- field for the date interval.

    The options for this field are:

    • None – No date control is displayed.

    • Warning – A warning message is displayed when you attempt to post the customer invoice. However, you can complete the posting process.

    • Error – An error message is displayed when you attempt to post the customer invoice. In this case, you cannot complete the posting process.

    Invoice date control 
    (In the Credit note dates control field group)

    Select one of the following options to indicate the date control that is applied when the invoice date on the credit note is later than the invoice issue due date on the packing slips that are included in the credit note:

    • None – No date control is displayed.

    • Warning – A warning message is displayed when you attempt to post the customer invoice. However, you can complete the posting process.

    • Error – An error message is displayed when you attempt to post the customer invoice. In this case, you cannot complete the posting process.

    Document date control 
    (In the Credit note dates control field group)

    Select one of the following options to display a message when the document date on the credit note is later than the invoice issue due date on the packing slips that are included in the credit note:

    • None – No message is displayed.

    • Warning – A warning message is displayed when you attempt to post the customer invoice. However, you can complete the posting process.

    • Error – An error message is displayed when you attempt to post the customer invoice. In this case, you cannot complete the posting process.

  4. Optional: In the left pane, click Summary update.

  5. Optional: In the Summary update area, select the Delivery information check box for the Packing slip to produce one packing slip per sales order line delivery address when posting.

After you have finished setting up the parameters to calculate invoice issue due dates, you can create and post the following transactions to automatically calculate and update the due dates to issue invoices:

  • Sales orders – When you create a sales order and post a packing slip, the due date for issuing the invoice is calculated and updated on the packing slip. The due date is calculated based on the date interval that is associated with the country that is specified in the delivery address of the sales order. You can post the packing slip, and then verify the invoice issue due date in the Invoice issue due date field in the Packing slip journal form. (Click Sales and marketing > Inquiries > Journals > Packing slip.) For more information, see Packing slip journal (form), Create or edit a sales order, and Sales posting (form).

    You can view all of the packing slips that are not invoiced and their invoice issue due dates in the Packing slips not invoiced form. (Click Sales and marketing > Inquiries > Journals > Packing slips not invoiced.)

  • Purchase orders – When you create a purchase order and post a product receipt, the due date for issuing the invoice is calculated and updated on the product receipt. The due date is calculated based on the date interval that is associated with the country that is specified in the primary address of the vendor. You can post the product receipt, and then verify the invoice issue due date in the Invoice issue due date field in the Product receipt journal form. (Click Procurement and sourcing > Inquiries > Journals > Product receipt.) For more information, see Product receipt journal (form) and Create a purchase order.

    You can view all of the product receipts that are not invoiced and their invoice issue due dates in the Product receipts not invoiced form. (Click Procurement and sourcing > Inquiries > Journals > Product receipts not invoiced.)

If you don't have access to the pages that are used to complete this task, contact your system administrator and provide the information that is shown in the following table.

Category

Prerequisite

Configuration keys

Click System administration > Setup > Licensing > License configuration. Click the General ledger configuration key.

Security roles and duties

To perform this task, you must be a member of a security role that includes the following duties:

  • CustInvoiceInvoiceAndCashProcessEnable (Enable invoice and cash process)

  • VendInvoiceInvoicePaymentProcessEnable (Enable invoice and payment process)

Security roles and privileges

To perform this task, you must be a member of a security role that includes the following privileges:

  • CustPackingSlipJournalView (View sales packing slips)

  • VendPackingSlipJournalView (View product receipt journal from purchase order)

  • LedgerInvoiceIssueDueDateSetupMaintain_W (Calculate invoice issue due dates)


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

Community Additions

ADD
Show: