Posting Dates vs Document Dates = Due Dates

(0) Share

Report

Posted on by Community Member

Is it possible to make vendor payment due dates and customer payment due dates based on "Posting Dates" instead of "Document Dates". In our company with our vendor and customers we pay based on Posting Date not on Document date.

Example: vendors submit invoices to us on 5 September 2016 for expenses that were incurred by our employees on month July or August 2016. Same with our customers, we perform the work on Jan 2017 but can only invoice in Feb 2017. Customer payment due date is based on Feb 2017 + terms, not Jan 2017 + terms.

Right now we set the document and posting date as the same dates. Which completely nullifies the purpose of having to date fields. Any help greatly appreciated.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Maneesha 5,891 on at

Like (0)

Report
Copy link

Link copied!

Is this mainly effect you while generating Invoice / Printout

or are you worrying about system details (data) also ?

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report
Copy link

Link copied!

Hi,

In this case, what is the value date of your transaction, "Posting Date" or "Document Date"?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (1)

Report
Copy link

Link copied!

By looking at your scenario you do not want to change document date but based on posting date you would like to calculate due date for payment.

As default system calculates due date based on document date and if you would like to calculate due date based on posting date then you need to change the program for this

Check the code on Payment terms code OnValidate trigger in Sales header table

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (1)

Report
Copy link

Link copied!

By default, the due date is calculated from the Document date. If you want it to be calculated from the Posting date, you need to modify OnValidate trigger in the Payment Terms Code field in the Purchase/Sales Header Table.

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report
Copy link

Link copied!

Survivor ,

Agreed with said by "Alexander Ermakov"

If you worry about the Print (Print order) : just change the report also

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks to everyone for providing valued feedback to my question. The objective is to use the document date for the date work is completed (or date on document) and posting date for date the transaction hits the GL. On sales side the date between actual completion of work and invoicing can be months. When reporting need to be able to flip between document date and posting date financial reporting. Is it possible to import pictures here?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

Hi

In which screen you would like to import pictures ? It is possible to import pictures.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

by this advice

it works. but after converting Sales Quote >> Sales Order, "Due Date" on Sales Order does not exist. I have to change "Posting Date" on Sales Order so "Due Date" will be updated.

How can I fix this?

Thank you in advance

Was this reply helpful? Yes No
Suggested answer

Indikauk 1,759 on at

Like (0)

Report
Copy link

Link copied!

Hi Survivor

by default system calculate payment due date based on the Document Date but if you need to change it to posting Date i'm agree with Amol Salvi suggestion.

Thanks

Indika

Was this reply helpful? Yes No
Sumit Kalia on at

Like (0)

Report
Copy link

Link copied!

Go to Accounts payable-->Setup--> Parameter-->Invoice Tab and disable the option "Update vendor accounting using the invoice date". Then it will post the voucher based on posting date.

Was this reply helpful? Yes No