Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

AP Invoice has been posted based on Document Date instead of Posting Date

Posted on by Microsoft Employee

Hi!

I have a strange issue in GP10. AP Invoice transactions which is posted based on Document Date instead of Posting Date. The posting setup is set to determine posting date from Batch.

I tried to do some research to understand when exactly it is happening, but couldn't figure out any pattern.

Did anyone face similar issue? Any thoughts?

Thanks,

*This post is locked for comments

  • soma Profile Picture
    soma 24,406 on at
    RE: AP Invoice has been posted based on Document Date instead of Posting Date

    Can you attach the AP invoice inquiry and GL Inquiry screenshot for the posted transaction which is posted in document date instead of posting date?

    your reply is much appreciated.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP Invoice has been posted based on Document Date instead of Posting Date

    Dear all,

    Thanks again for additional replies. In fact I also never come across this sort of issue before. It happened for couple of transactions. Let me do some more research.

    Thanks once again.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: AP Invoice has been posted based on Document Date instead of Posting Date

    I'm with Heather all the way on this one.  Do you have a GP Partner you can run this by?  That would be much quicker than trying to troubleshoot this in the venue.

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: AP Invoice has been posted based on Document Date instead of Posting Date

    Hi

    I am struggling to see the issue based on the earlier screen shot.  In that shot, the Document Date is 11/12/2013 and the Posting Date is 14/01/2014 which I am assuming is the posting date from the batch based on the setup of the batch ID.  There is no indicator that this has posted to the GL at the document date.

    Essentially this sort of issue is very hard to identify via this sort of format - and even then there may be no definite answer.  As noted above, posting is determined based on either the batch ID or transaction date dependent on setup in the Posting Setup.

    If these are one offs, then you may spend more time investigating that is worth.  I personally have never seen an instance where it isn't working properly based on these setups.

    Regards

    Heather

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP Invoice has been posted based on Document Date instead of Posting Date

    Dear all,

    Thanks for your replies. I am verifying individual transaction from AP enquiry and comparing with GL enquiry where it is posted to. As shown in the screen short which were posted earlier, one particular Invoice is posted to GL based on document date instead of Posting Date. Any clue?

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: AP Invoice has been posted based on Document Date instead of Posting Date

    Hi Mohan

    Dates can get really confusing in GP - especially if you are looking at the dates from e.g. SmartList.  Posting Date and Posted Date are definitely different.

    It would probably be more helpful to let us know how you are looking for the patterns - have you created a SmartList or are you just verifying individual transactions.

    The fields to compare:  TRX Date in GL should equal the Posting Date as per the Batch or Transaction (depending on setting).

    Cheers

    Heather

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP Invoice has been posted based on Document Date instead of Posting Date

    Sorry Frank there is a typo error, I was referring to Posting Date.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: AP Invoice has been posted based on Document Date instead of Posting Date

    Posted Date = date posted to the subledger.  Posting Date = date posted to the GL.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP Invoice has been posted based on Document Date instead of Posting Date

    Hi Frank & Soma,

    The posting date is captured with the AP Invoice. I also verified in GL it is posted based on Document Date but not posting date. I know posted date is meant for GL posting. Not sure why GP using document as base to post to GL?

    Thank you,

  • soma Profile Picture
    soma 24,406 on at
    RE: AP Invoice has been posted based on Document Date instead of Posting Date

    Frank is correct.

    Where did you seen the transaction was posted to document date instead of posting date?

    Your reply is much appreciated.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans