SOP Invoice Due Dates incorrect

(0) Share

Report

Posted on by Community Member

We transfer orders to invoices and are experiencing a problem with the calculation of the due date. In some cases the date due is even before the invoice date. It appears to be using the original order date in the calculation, but I can't figure out why....or what to change. Has anyone one else seen this? We are on GP 10.0.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Josh P 2,895 on at

Like (0)

Report

Does this happen when the invoice is posted or in work status?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It appears to be happening in SOP, prior to posting. I have a list of about 15 invoices that have a due date equal to the invoice date that all originated with orders.

Was this reply helpful? Yes No
Suggested answer

Josh P 2,895 on at

Like (0)

Report

Well the data is pushed from the order, so it is conceivable this is happening until you post. The invoice should update the due date based on the payment terms and date. Try recreating this scenario in a test company, and see if posting the invoice changes the date for you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Actually I also have many examples of posted invoices that have a due date of the same date, or even less than the date of the invoice.

Was this reply helpful? Yes No
Josh P 2,895 on at

Like (0)

Report

Have you checked the customer cards and set up to make sure everything is good there?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes, we only have one terms for our Company so it defaults in with the class setup. The terms are Net 15th of the following month. All the customers have their terms in tact, and when the invoices are created without originating on an order, the terms are fine. Same customer, just the difference of the originating order.

Was this reply helpful? Yes No
Josh P 2,895 on at

Like (0)

Report

When looking at the SOP invoice that has been posted, can you see if Smart List also shows the RM transaction record created with the same due date as the SOP invoice?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yep. That was the view I was looking at when I told you I had 10 un-posted transactions that had the same due date as invoice date. I used the field comparison in SmartList to return documents that had an equal Document Date and Due Date.

Was this reply helpful? Yes No
Josh P 2,895 on at

Like (0)

Report

Interesting, let me see if I can find my GP 10 install and confirm what you are seeing. Does this happen on the Fabrikam company for you as well?

Was this reply helpful? Yes No
Victoria Yudin 22,769 on at

Like (0)

Report
Christina,

I cannot duplicate this on GP 2010, and I know this was not a problem for us when we were on GP 9.0 before that. I cannot imagine this was different in GP 10.0. We often transfer orders to invoices and we always print our invoices before they are posted, so I know there is no issue with the due date before or after posting the invoice on our system. And I have created many custom SOP invoices for different companies, I am confident I would have heard about this if this was an issue others have experienced. Some questions to try to troubleshoot this:

Do you have any customizations or 3rd party products installed?

Is this happening or every invoice transferred from an order, or some? If some, can you see if there is any pattern?

Can you recreate this in the Fabrikam company? (Try it with the same terms you use and also with something more generic, like Net 30.)

Was this reply helpful? Yes No