Delete Data from G/L Account

abinashphuel
abinashphuel Member Posts: 18
edited 2018-06-27 in NAV Three Tier
I am using RapidStart Package to import data to G/L Account, before importing data I want to delete all data from the table.
But because there are already data linked with G/L Account I am not able to delete data from G/L Account.


What is the best way to delete the data from G/L Account ?

Best Answer

  • abinashphuel
    abinashphuel Member Posts: 18
    edited 2018-10-05 Answer ✓
    In general ledger setup uncheck "check G/L Account Usage"
    Then delete data from G/L Account Table
    Then again in general ledger setup check "check G/L Account Usage"


    PS. I am migrating g\l account data from live to test company.

Answers

  • lubost
    lubost Member Posts: 633
    There is no fully legal way. If you implementing NAV, you can close period in old system with "old" accounts and create new period in new system with "new" accounts.
  • abinashphuel
    abinashphuel Member Posts: 18
    edited 2018-10-05 Answer ✓
    In general ledger setup uncheck "check G/L Account Usage"
    Then delete data from G/L Account Table
    Then again in general ledger setup check "check G/L Account Usage"


    PS. I am migrating g\l account data from live to test company.
  • kriki
    kriki Member, Moderator Posts: 9,132
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!