Payment Terms Code

Business Central/NAV Developers Forum
1

Hi,

If changing in Payment Terms code (suppose from 30 days to 60 days) .Will it change the historical data of Customer/Vendor automatically. (i.e Due Date of Invoices)

Thanks in advance

Regards

Amol

2

The answer is NO .

There is no impact on the Historical date (Posted Invoices - sales iNvoice and Purc hase Invoice).

Where u want to chage the Payment terms code ?

3

Hi

Thanks for reply

But when we are talking to Microsoft they are saying it will change Retrospectively.

If we change payment terms code in between then what will hapeen to previous O/S amount of Customer/Vendor.

Regards

Amol

4

Nothing will happen. The Payment Terms which was in effect when you did you sale/purchase will not be changed. The order document can be changed manually, but when the document has been posted as an invoice, then you’re no longer allowed to change it.

5

Actually there is one minor exception. You can change the “Due Date” in the “Customer Ledger Entry” table manually after the document has been posted. This allows you to make an appointment with a customer that an invoice is paid later (or earlier!) than stated on the invoice.

6

Hi Erik,

Thanks for your reply.

But logically speaking if we change Payment terms code in between then will it require to change due date of past invoices which already been posted with other payment terms code.

Is there any batch available or we need to write a code .

Over that Microsoft is saying that we can change it Retrospectively. How ??

Regards

Amol

7

YOU ARE NOT ALLOWED TO CHANGE THE PAYMENT TERMS OR ANY OTHER DATA OF ALREADY POSTED DOCUMENTS!

The invoice is to be seen as a contract between you and the customer/vendor and will not be changed. Changes to payment terms will only be in effect for new invoices.

So there is no batch job or anything available as it will be against the law (at least according to general international accounting laws, but I cannot imagine that Indian law is that different from the rest of the world) as there MUST BE an exact match between the invoice document printed and send to the customer AND your system.

The only except is that you manually can change the due date of selected invoices.

8

Hi Erik,

Thanks for detail explanation.

Regards

Amol