web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Entry posted with blan...
Finance | Project Operations, Human Resources, ...
Answered

Entry posted with blank account number?

(0) ShareShare
ReportReport
Posted on by Mike Bresnan 65

We had a bank transaction post through our 3rd party reconciliation plugin, (Easy e-Bank Rec) with 2 lines, but one of them has a null account number. i think the issue of how this happened lies with the vendor, but i'm not sure how to fix it. We aren't able to do anything to that posted voucher (correct, etc)

I think deleting the entry in SQL and creating a new/correct one may cause other issues since that bank rec entry will have no GL counterpart.

It seems like updating that particular distribution line in the SQL table with the right ACTINDX value is probably the best solution? but aside from running reconcile in GP, i'm not sure if anything else needs to be done.

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Verified answer
    Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: Entry posted with blank account number?

    HI Mike,

    I agree, you can update the ACTINDX in the GL20000 and reconcile the year to get the GL summary tables updated.   If it was a bank transaction, you can also update the Bank Rec distribution table (CM20400) if it's in there (find it from looking at the CM20200 first to get the cmrecnum).  This is just an informational table if you were to drill back on the distributions from the bank transaction.    Just have a backup of the live company first, just in case.   If you have Analytical accounting installed, you would have to check the AAG30000/AAG30001/AAG30002 tables as well.  I can't speak for any other 3rd party products  you may have installed.

    Hope that helps.  

    Cheryl Waswick

    Microsoft Dynamics GP Support  

  • Mike Bresnan Profile Picture
    Mike Bresnan 65 on at
    RE: Entry posted with blank account number?

    Yep, that's what we ended up doing.

    It was due to the 3rd party application allowing the entry to go through without an account number specified. so we're hoping they can button up that hole in their code. I assume it goes around the controls within GP.

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 753

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 752 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 534 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans