MODIFY "G/L Account No." Field in G/L Entry

anhnd

Hi all,
I have a wrong entry about G/L Account in "G/L Entry" Table
Ex: "G/L Account No." = 112
I have corrected to "114"
I have checked Balance of Account 112 in "Chart Account" table and not problem.I don't sure is good solution.
someone tell me what I can encounter problems in the future?

Thanks!

vijay_g

This is not the right way to modify ledger entry manually you should reverse the transaction and post a new transaction.

anhnd

Thanks , but I have large number of entries,I do not want to reverse because only "G/L Entry" Table store information G/L Account.
Other tables only related to amount,Entry No.,dimension,

udayrmer

No dear all the Ledger entry have G/L Account no., stating where its G/L effect laid Chart of Account.

e.g. Vendor Ledger Entry, there is G/L Account No., Defined In Vendor Posting Setup, mapping Liability of it to COA.
same is for all, so if you are making any report from ledger, linking it to its G/L entry give you wrong.

Luc_VanDyck

anhnd wrote:

I don't sure is good solution.

It's not. As said by vijay_g, you should reverse the transaction and book again using the correct account numbers.

dans

Reverse the transactions, and post the correct journal. Don't take shortcuts.

Chinmoy

Even if you have modified the G/L Entry table for the time being, in future the postings will again create wrong records. So, best option is to reverse the wrong transactions, set the posting setups right and create new transactions.

anhnd

Thank all,
in case User set up account in General Posting Setup is wrong and they want fix this problem, any entry posted from sales invoice (can not use reverse)

Someone can give a solution for this problem ?

udayrmer

Make Credit-memo with That customer with updated (correct) posting setup, and in line item use the wrongly tagged G/L i.e. G/L account set up in wrong Posting Setup.

anhnd

Thanks udayrmer !