Need to change/Clear the balance from Reconciliation account posted incorrectly/

[amit_goel3]

Hi Folks,

One of my client is migrating from classic G/L to new G/L.

As pre-migration activities we got an issue where a vendor open item got cleared with the incorrect recon account.

Example:

The vendor invoice

Cr. Vendor 1(Recon Account: 12345678😞 100

Dr. Purchase account:100

Then the clearing doc

Dr. Vendor Account(Special G/L Recon account 87654321) Special G/L "L": 100

Now the issue is that though the vendor got cleared in the system but the balance reflect in wrong Recon accounts i.e. Credit 100 in G/L Account 12345678 and Debit 100 in G/L Account 87654321.

As on date these documents are already archived however before migrating to New G/L customer wants to rectify the balance inconsistency from these G/L accounts.

I need help/Suggestions here as how we can correct this balance inconsistency from the two difference reconciliation accounts.

Any help would be highly appreciated.

Regards,

Amit

[Gustavo_Vazquez · Accepted solution]

Hi Amit,

As it's cleared and archived, it's time to move on.

Is there any impact on tha balance statement ?

Do programs for NewGL migration give a red flag ?

Kind Regards

PS: You could post 2 documents to correct the error and use "Postings with alternative reconciliation account"; but i will try to keep things as they are if there is no impact on Balance statement.

IMG: Financial Accounting (New) -> Accounts Receivable and Accounts Payable -> Business Transactions -> Postings with Alternative Reconciliation Account

[amit_goel3 · Accepted solution]

Hi Gustavo,

Thanks for your reply...!!!

I definitely agree with you that we can keep this inconsistency as it is, but client also has valid concern as they want to rule out any future migration inconsistency because of this issue.

To your suggestion, if We post to the alternate recon account I believe it wont reflect in the primary recon account.

If yes, then the issue will remain there with the primary G/L account.

Kindly let em know if there is some disconnect in my understanding to the solution purposed by you.

Regards,

Amit

[Gustavo_Vazquez · Accepted solution]

Hi Amit,

I might have misunderstand your scenario. Is this correct ?

Invoice:

40 Gl account - NNNNNN 1.000

31 Vendor 1 - 12345678 1.000 -

Payment:

25 Vendor 1 - 33333333 1.000

39 Vendor 1 SpGl - 87654321 1.000 -

Kind Regards