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
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.
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.
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.
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
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?
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
Sorry Frank there is a typo error, I was referring to Posting Date.
Posted Date = date posted to the subledger. Posting Date = date posted to the GL.
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,
Frank is correct.
Where did you seen the transaction was posted to document date instead of posting date?
Your reply is much appreciated.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156