Options

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

anhndanhnd Member Posts: 11
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

  • Options
    vijay_gvijay_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.
  • Options
    anhndanhnd 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,
  • Options
    udayrmerudayrmer 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
  • Options
    Luc_VanDyckLuc_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)
  • Options
    dansdans 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
  • Options
    ChinmoyChinmoy 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.
  • Options
    anhndanhnd 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 ?
  • Options
    udayrmerudayrmer 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
  • Options
    anhndanhnd Member Posts: 11
    Thanks udayrmer !
Sign In or Register to comment.