225
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
*This post is locked for comments
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,
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
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.
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (