Batches show in Transaction Entry but not in Series Posting

Question Status

Suggested Answer
Nhi Nguyen asked a question on 12 Sep 2017 11:10 AM

Hi folks,

Could you please advise me on this issue? I am seeing some sales batches in Transaction Entry in Financial Module but cannot find it in Series Posting.

We set up Post to GL for Sales and we all post the batches at month end in GL but today I see some sales batches in previous months still sitting there.

Thank you in advance for your time and suggestions.

Nhi

Reply
Suggested Answer
Leslie Vail responded on 12 Sep 2017 11:50 PM

The batches in your screenshot are general ledger entries that have not been posted. The origin was sales, but you won't be able to find them in sales because they are already posted. Were any of the sales posted directly from the transaction entry window? Sales posting using transaction posting will not post through the GL regardless of your Posting Setup setting. You've got transactions in your Financial series posting coming from several modules - have you set it up so that it will not post through GL, or are your people doing transaction posting?

Kind regards,

Leslie

Reply
Suggested Answer
Leslie Vail responded on 13 Sep 2017 12:32 AM

Hi,

I modified the General Entry window such that it displays the master ID and Master Name information. Sometimes that will help you research unposted GL entries. I think I uploaded into the share my code section of GPUG, but in case I didn't, you can get it at this link: app.box.com/.../xrd0fmz7b6rj6yoacfb8

Please let me know of any changes that you would like to the form and if helped you at all.

Kind regards,

Leslie

Reply
Nhi Nguyen responded on 13 Sep 2017 12:45 AM

Hi Leslie,

All sales postings are set up as Post to GL. We always do batch posting because somehow we get hung up eveytime we do transaction posting. The problem here is many batches are from 2016 and we already submitted financial documents to the CPAs. I found them when I tried to close the year 2016.

Reply
Suggested Answer
Leslie Vail responded on 13 Sep 2017 5:15 PM

Hi,

If the setting is Post 'To' general ledger, you will need to post the transaction twice. First in the sub-module and then in the general ledger. The setting of Post 'Through' general ledger will post the batch to the general ledger automatically. Again, I noticed there are unposted general ledger batches from more than just the Sales module. Are you able to reconcile sales in the sales module to sales in the general ledger?

Kind regards,

Leslie

Reply
Nhi Nguyen responded on 19 Sep 2017 12:27 PM

Hi Leslie,

When I ran Reconcile to GL for RM, the balance is off by those invoices. I tried to post them but it says 'Transaction contains intercompany distributions; mark as an IC transaction". I ran this script "select * from GL10000 where ICDISTS <> 0 or ICTRX <> 0 " and found those invoices in question. Now I need to update their ICDISTS from 1 to 0 but cannot find a script. Could you please advise?

Thank you so much,

Reply
Suggested Answer
Leslie Vail responded on 12 Sep 2017 11:50 PM

The batches in your screenshot are general ledger entries that have not been posted. The origin was sales, but you won't be able to find them in sales because they are already posted. Were any of the sales posted directly from the transaction entry window? Sales posting using transaction posting will not post through the GL regardless of your Posting Setup setting. You've got transactions in your Financial series posting coming from several modules - have you set it up so that it will not post through GL, or are your people doing transaction posting?

Kind regards,

Leslie

Reply
Suggested Answer
Leslie Vail responded on 13 Sep 2017 12:32 AM

Hi,

I modified the General Entry window such that it displays the master ID and Master Name information. Sometimes that will help you research unposted GL entries. I think I uploaded into the share my code section of GPUG, but in case I didn't, you can get it at this link: app.box.com/.../xrd0fmz7b6rj6yoacfb8

Please let me know of any changes that you would like to the form and if helped you at all.

Kind regards,

Leslie

Reply
Suggested Answer
Leslie Vail responded on 13 Sep 2017 5:15 PM

Hi,

If the setting is Post 'To' general ledger, you will need to post the transaction twice. First in the sub-module and then in the general ledger. The setting of Post 'Through' general ledger will post the batch to the general ledger automatically. Again, I noticed there are unposted general ledger batches from more than just the Sales module. Are you able to reconcile sales in the sales module to sales in the general ledger?

Kind regards,

Leslie

Reply