Erpnext: Invoice Due Date calculated from posted date instead of Supplier Invoice Date

[dboobisMF]

The due date for Purchase Invoices is being calculated from the posted date of the document and not the invoice date. In the Payment Terms doctype, the wording for "Due Date Based On" is precisely "Days After Invoice Date" but the current behaviour does not do this.

There is scope to incorporate the current behaviour as an additional drop down option, but primarily this is a bug and needs to be fixed.

Given a supplier invoice has a document date
And payment terms are net of this date
When entering the invoice into the ERPNext system
Then the automatically calculated due date should be based on the invoice date

[umairsy]

Hi,

By invoice date, are you referring to Supplier Invoice Date? If yes, it cannot be made to work as expected. The Due Date will be set based on the Posting Date of the invoice only. The Supplier's Invoice Date is added there just for the reference and not considered in the calculation of due date. If needed, you can create Post Dated Purchase Invoice as well by amending Posting Date of the invoice.

[dboobisMF]

This is unacceptable, that's not how international accounting works. If the system can't handle setting the due date off the supplier invoice date then the system is broken.

The accruals principle requires that you can post invoices into a different period than they are dated for. It's a fundamental tenet of International Accounting Standards. For the user to have to manually calculate the due date for every invoice is unacceptable.

How would I best go about getting this resolved?

[umairsy]

Can you please mention which field are you referring to from Invoice Date? Is it Supplier Invoice Date?

[dboobisMF]

Yes, supplier invoice date is the field.

[nabinhait]

@dboobisMF I agree that due date should be calculated based on supplier invoice date instead of posting date. We will make necessary changes.

[dboobisMF]

Just tested this and it doesn't entirely work. It still fails to validate if the due date is before the posting date, and the due date at the top of the page doesn't update (only the date on the payment terms child table).

What's the best way to resolve these issues?

[ChipwizBen]

Agreed, this is an annoying issue and also affects Subscriptions. Every repeat seems to fail due to this bug.