Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Becky Wollner]

Good Morning All-

We posted a bank transaction through GP and it has not posted to the General Ledger and now our accounts are not reconciling because of that transaction.  The transaction did post through the bank reconciliation module and has since been reconciled for April.  Because of this, we can no longer void the transaction.  I am unsure how to push the transaction through to the general ledger.  Currently, our sub ledger and ledger are not tying out.   Are there any suggestions or work-arounds?

Thanks,
Becky

——————————
Becky Wollner
Spaulding Clinical Research, LLC
West Bend
——————————

[Cecile Dinh]

?Hi Becky,

If you go to Setup >> Posting >> Posting >> Financial >> origin:  Bank Transaction Entry, do you see Post to and Post Through checkboxes marked?

Have you checked all unposted batches in GL? 

You can also try to run Reconcile by going to Tools >> Utilities >> Financial >> Reconcile.
If still not resolved, you can just enter an adjusting Journal Entry in GL – and make a note that is your Bank Transaction entry with reference number.
That will tie up your GL and Bank Recon.

Hope this helps.

?

——————————
Cecile Dinh
Microsoft Dynamics GP Administrator
ARC (Airlines Reporting Corporation)
Arlington VA
——————————
——————————————-

[Becky Wollner]

Thank you for the response.  If i got to the set-up that you listed, the post to general ledger field is checked, but the post through to general ledger files is not.  Based on your response, I would guess they should both be checked.   Do you know what the difference between those two fields?

——————————
Becky Wollner
Spaulding Clinical Research, LLC
West Bend
——————————
——————————————-

[Bert Green]

Becky,

The post to gl creates the batch in Financials.
The post through gl actually takes the batch and posts it.

If you look in Financials > Series Posting you might see a batch that has not been posted that will be for the bank transactions. Would start with a CMTRX I believe.

——————————
Bert Green
GP Developer/GP Administrator
Berger Transfer & Storage, Inc.
Saint Paul MN
GP2015/MR CU11
GPUG All Star 2017
——————————
——————————————-