sop to gl reconcile when using batch date

(0) Share

Report

Posted on by Community Member

Was thinking of using posting date from batch. However, I’m wondering how to reconcile sop to gl if the gl uses the batch date and the sop module is using the transaction date? How do people reconcile sop to gl if they use posting date from batch? thanks!

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Lyn Barr 1 on at

Like (0)

Report

RE: sop to gl reconcile when using batch date

I love your scripts, Mahmoud!

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: sop to gl reconcile when using batch date

You can print your HATB based on the GL posting date instead of the document date to make reconciliation easier. There is a radio button inside the report options window where you can specify the report to use the GL posting date regardless of the document date.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: sop to gl reconcile when using batch date

Why? For control. All current period transaction go in the current period batches and all last period transactions go in the previous period batches. This way the user does not have to play around with dates. They simply enter the transaction, and since they must select a batch, the select the correct batch. Let’s say it’s the first week of February and we receive an invoice for work done in January. They select the batch called JAN_TRX, the batch is set with a posting date for January. Only January trx go into this batch. Now, if they just select any old batch, and they don’t change the posting date on the trx and we’re not posting by batch date then the trx posts in the wrong period.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (1)

Report

RE: sop to gl reconcile when using batch date

Well, Frank has touched upon an essential point. Why would you be thinking of the option "Posting Date from Batch" ! I can never count the numbers when this option was left incorrectly and the pain to correct the journals in the GL to match the originating document date.

Another thing that would be related to the topic, a simple script to reconcile sales invoices and returns between the SOP and the GL module Sales Invoices and Returns with General Ledger Journals Details

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,615 Super User 2025 Season 2 on at

Like (0)

Report

RE: sop to gl reconcile when using batch date

Okay, I think I misread your post the first time I read it. Let's clear the terminology first. When a transaction is posted to the sub-ledger, it's called 'Posted Date'. When it's posted to the GL, it's called 'Posting Date'.

I agree with you, I would not use Batch Date as the Posting Date to the GL. Why would anyone want to take the risk that transactions in a batch may cross fiscal periods but have all the transactions post to one period?

Why were you thinking of using Posting Date from Batch?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: sop to gl reconcile when using batch date

Frank, thanks for answering. I thought the transactions always use the transaction date (docdate I believe) and the gl uses the gl posting date. Now, when you enter a transaction the transaction date and gl posting date will be the same unless you click on the blue arrow and change one of them. And if you change the posting setup to use posting date from batch and you have a different batch date then the transaction date, you will have timing issues. So what is best practice? Never change the posting date on the transaction and don’t use posting date from batch?

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,615 Super User 2025 Season 2 on at

Like (0)

Report

RE: sop to gl reconcile when using batch date

That only works if the Batch Posted Date is the same as the GL Posting Date. Otherwise, you'll have timing differences for sure.

Was this reply helpful? Yes No