Calculating Due Dates

  • Article

In Spain, there is a legal limit for the number of days that a payment can be delayed. You must submit an annual report of purchases and sales for payments that were made before or after the due date. The legal requirements depend on whether the customer is a private company or a public administration. For more information, see the official declaration BOE-A-2010-10708 on the Boletín Oficial del Estado website.

Payment Terms

To help you meet the legal requirements, you can set up payment terms so that the due dates are calculated correctly. This includes specifying the maximum number of calendar days that a payment can be delayed after delivery. For example, you can create separate payment terms for sales to the public sector and sales to private companies. The following table illustrates how you can set up payment terms.

Field Public sector Private company

Code

1M(8D) PUB

1M(8D) PRI

Due Date Calculation

1M

1M

Max. No. of Days till Due Date

30

60

For each customer and vendor, you must select the appropriate payment term code. Then, when you create a document for that customer or vendor, Microsoft Dynamics NAV will calculate a due date that does not exceed the limit for the relevant payment term.

Important

You cannot post a document that creates a bill where one or more installments have a due date that is later than the limit that is specified in the Max. No. of Days till Due Date field.

If a due date cannot be calculated based on the limit, the due date is set to blank. For example, if the calculated due date falls in a non-payment period and there is no available date before that period, you must specify a due date manually. You cannot post a document that has an empty due date.

You can change the calculated due date manually, but you cannot make it later than the limit that you specify for the payment term. For example, the due date can be calculated to be very late because of conflicts with non-payment periods. In that case, you can decide to make the due date earlier than the non-payment period.

Overdue Payments

You must include information about overdue payments in the annual reports for the government. Microsoft Dynamics NAV includes two reports to help you identify overdue payments from customers and payments that you are late in making.

The Customer - Overdue Payments and Vendor - Overdue Payments reports include a section for each customer or vendor that lists the payments with the following information:

  • Invoice number

  • Invoice description

  • Document number

  • Posting date

  • Due date

  • Days overdue

  • Currency code

  • Amount

  • Amount in the local reporting currency (LCY)

Each section has a summary section with the following information.

Information Description

Weighted average term exceeded

This formula is calculated based on the number of posted payments for the specified period, the number of days that payments were delayed, and the paid amount in (LCY). For more information, see the official declaration BOE-A-2010-10708 on the Boletín Oficial del Estado website.

Payments within the legal limit

The amounts in LCY and the percentage of the total payments that were made before the maximum allowed due date for each transaction.

Payments outside the legal limit

The amounts in LCY and the percentage of the total payments that were made after the maximum allowed due date for each transaction.

At the end of these reports, there is a section that summarizes this information for all payments. These reports will show information based on applied detailed customer ledger entries or applied detailed vendor ledger entries. The information is based on the date filters that you specify. For more information, see Customer - Overdue Payments and Vendor - Overdue Payments.

See Also

Tasks

How to: Set Limits for Due Dates

Reference

Customer - Overdue Payments
Vendor - Overdue Payments

Other Resources

How to: Set Up Payment Terms
Apply Purchase Transactions
Apply Sales Transactions