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

anhnd
anhnd Member Posts: 11
edited 2012-06-26 in NAV/Navision Classic Client
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!

Comments

  • vijay_g
    vijay_g Member Posts: 884
    This is not the right way to modify ledger entry manually you should reverse the transaction and post a new transaction.
  • anhnd
    anhnd Member Posts: 11
    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
    udayrmer Member Posts: 171
    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.
    Uday Mer | MS Dynamics NAV Techno-Functional Consultant
  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    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.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • dans
    dans Member Posts: 148
    Reverse the transactions, and post the correct journal. Don't take shortcuts.
    Microsoft Certified IT Professional for Microsoft Dynamics NAV

    Just a happy frood who knows where his towel is
  • Chinmoy
    Chinmoy Member Posts: 359
    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
    anhnd Member Posts: 11
    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
    udayrmer Member Posts: 171
    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.
    Uday Mer | MS Dynamics NAV Techno-Functional Consultant
  • anhnd
    anhnd Member Posts: 11
    Thanks udayrmer !

Categories