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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (14)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!

The point is straightforward, if you have chosen at the posting setup level to retrieve posting date from batch, then it should be the batch date appearing on the GL Journal Entry.

Although, what if you posting setup is configured to allow transaction posting ! In this case, you have not batch and not date at the batch level as well.

I have just tested this scenario, and It was clear that the Journal entry created on the GL level has the posting date retrieved from the AP document date since no batch was created initially.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Mahmoud,

Thanks for the posting. I have verified the transaction was posting using a Batch, but not using a transaction level posting. Do you see any other reason?

Regards,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Here is additional information where Document Date and Posting Dates for the transaction is showing. However this transaction is posted based on Document Date.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Moderator on at

Like (0)

Report
Copy link

Link copied!

Mohan, where are you seeing that the Posting Date = Document Date?

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report
Copy link

Link copied!

Frank is correct.

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

Your reply is much appreciated.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Heather Roggeveen 9,150 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No