Due Date calculation

[umairsy]

As received from Lumi.

In the Sales Invoice, Payment Due Date is correctly updated based on Credit Days mentioned in the Customer. But if user amends Posting Date of Sales Invoice, Payment Due Date is not updated.

Same way, on the purchase side, user expects item's "Required By Date" to be updated, after changing Posting Date of Material Request/Purchase Order.

[ghost]

Need to add Lead Time Days (lead_time_days) field value to the 'Required By Date' on changing Posting date.

[jevonearth]

Having javascript update the due date immediately, based on invoice date would be very useful.

When editing an existing invoice, it may not be desirable for the due date to be updated automatically, as it might have been previously set explicitly. Xero has a 'Reset to Default Date' link for this purpose.

I recorded a quick video of the Xero behavior that you guys might find useful.
http://youtu.be/Jyk-rdtdViI

I also opened #2147 and #2146 today, that both relate to due date behavior. :)

-Jev

[rmehta]

@jevonearth thanks for the nice video - clear documentation and expectations should result in increased priority :)

[sbkolate]

Hi,
In the Sales Invoice, Payment Due Date is correctly updated based on Credit Days mentioned in the Customer. But if user amends Posting Date of Sales Invoice, Payment Due Date is not updated.

This can be solved using custom script

cur_frm.add_fetch('customer','credit_days','credit_days');
cur_frm.cscript.posting_date = function(doc){
        cur_frm.set_value("due_date", frappe.datetime.add_days(doc.posting_date,doc.credit_days));
}

I think this should be added in ERPNext. Can I send pull request for this feature?

Thanks,

Sambhaji
Systematrix Solutions

[nabinhait]

@sbkolate
Actually the code is already there ( https://github.com/frappe/erpnext/blob/develop/erpnext/accounts/party.py#L127 )
It sets due_date based credit_days, on selection of customer or posting_date. But the problem is, if there is already a value selected in due_date field, it does not reset it. It is because system could not identify the due_date is entered by the user or calculated based on credit days. If it was set by user, system should not reset it.

[nabinhait]

Same as #3451
WIP