web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Document Date and Due Date out of whack

(0) ShareShare
ReportReport
Posted on by

Within the past month we have switched the way we handle receipt/invoice using out procurement system where a receipt was entered then matched within DGP to an invoice. We have now moved to a full match/invoice using our procurement system POPTYPE = 3 now. As a result we are seeing tables taht are no longer populated, broken reports etc.

A more concerning issue is the one I want to layout. Document Date and Due Date are completely missing on specific vendors (see image). Here is a specific example of a vendor invoice that was initiated with a document date of 5/5/17 but demonstrates a “Due Date” of 2/11/2016. 

What could be the cause of this? I do know that some of the payment terms were updated by AP but at this point I am left with broken pieces.

Any help to resolve this would be greatly appreciated.

Thank you

Mark

pop-matching.pngpopmatching2.png

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Bill Campbell Profile Picture
    12 on at
    RE: Document Date and Due Date out of whack

    This is always a challenge to figure out where dates come from in the PO system, but in this case the first place to look is at the PO itself.  The Dates (in figure one) are to the best of my knowledge created and populated on the PO ( blue arrow dates ) when the PO is first created.

    If you are getting required dates that are that old - that out of line - then you need to look at the PO and see what is there.

    When you can, please post a copy of the orginal PO document along with the expansion to the PO Dates page as well.

    Good luck for now.

  • Community Member Profile Picture
    on at
    RE: Document Date and Due Date out of whack

    POdetail02.PNGPOdetail02.PNGPOdetail03.PNGThank you Bill, here are the details you requested.

  • Suggested answer
    Bill Campbell Profile Picture
    12 on at
    RE: Document Date and Due Date out of whack

    Manelson, the date you are referring to is the date that was originally created on the PO when first prepared.  As a blanket PO you do end up with some strange looking dates.  

    My question would be how does it effect the creation of the actual Invoice entry in GP?  The document date on the invoice should be coming up at 05/17 and the due date should be calculated based on the Terms for the specific Vendor.

    Have a look at the INVOICE document once you have this processed and post the results.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans