Entry posted with blank account number?

(0) Share

Report

Posted on by Mike Bresnan

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

All responses (2)

Answers (1)

Mike Bresnan 65 on at

Like (0)

Report

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!
Verified answer

Cheryl Waswick on at

Like (0)

Report

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