Open Forum

Expand all | Collapse all

#Nav 2015 #Implementation Using Rapid Start to import ledger entries and GL entries

  • 1.  #Nav 2015 #Implementation Using Rapid Start to import ledger entries and GL entries

    Posted Feb 03, 2020 03:36 PM
    ​Hello,

    I am new to the community and have a project that requires combining 13 companies into an existing company. We are on NAV 2015 and I have been able to import the COA and GL entries tables into the existing company for a test company (one of the 13) and am able to balance except for 1 - one sided entry which is from the vendor ledger entry table. The error I get when I import to the existing company from the vendor ledger entry is that  I do not have insert permission into the vendor ledger entry table in the existing company.

    My question to the group and I have searched extensively on the web for this is:

    How do I get opening balances as of the crossover date by transaction for the bank account, vendor and customer ledgers? Do I export them and then post them through the general journal and then import the General Ledger entry table after deleting the transactions tied to bank, vendor and customer ledger entries? There are minimal transactions for the 13 companies so we would like to import all transactions for audit purposes.

    Thanks


    ------------------------------
    David Brown
    Bay4 Energy Services, LLC
    Safety Harbor
    ------------------------------


  • 2.  RE: #Nav 2015 #Implementation Using Rapid Start to import ledger entries and GL entries

    TOP CONTRIBUTOR
    Posted Feb 04, 2020 07:52 AM
    Do not import ledger entries. You are bypassing all of the business logic of NAV so you are missing dimensions, dimension sets, subsidiary ledger and much much more.

    Import into journals and post the journals.

    ------------------------------
    Kyle Hardin
    NAV Developer
    ArcherPoint Inc.
    Duluth GA
    ------------------------------



  • 3.  RE: #Nav 2015 #Implementation Using Rapid Start to import ledger entries and GL entries

    Posted Feb 04, 2020 10:01 AM
    Hi David,

    You will create and post general journals, debit the bank, vendor, or customer and offset the GL for the control account.  Each entry will create a 3 sided entry; DR/CR the GL and DR or CR the subledger/ledger entry.

    The general journal looks a little something like this:
    sample gnl jnl

    Result is:
    DR GL 12100 $100.00
    CR GL 12100 $100.00
    DR customer ledger entry $100.00

    And there's the 3-sided entry I was trying to explain.  In my case, GL 12100 is my AR control account.

    ------------------------------
    Jimmy Yu
    Enterprise Architect
    Step Energy Services Inc
    AB
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role