mibuso.com

Hi All,

We are in process of bringing data from NAV 4 to NAV2009. Master data has already been imported.
I like to know what is the best way to get the data for GL,FA etc.
Also for GL entries, say if I want to bring over open entries from 01.01.2012, do I need to bring in all the entries or just open entries on to general journal and then post it.

Thanks in advance.

by gl i am guessing AP and AR. you only bring the open remaining amount. For FA you bring the current value as acquisition cost.
Since you will be bring the GL balances as well for all, you will need to setup the posting so that when sub ledger are posted, that the net result is 0. so debit and credit the same account.

Thanks,

sorry, are you saying the account and bal. account no. should be same for all GL accounts and the amount should be remaining amount from the entries.

Thanks again

which entries are you talking about? AR/AP or GL?
AR/AP, the balancing would would GL account that Vendor/customer hits, and yes the net effect could be zero on gl account but the subledger would have the balancing amount. And yes you would bring the remaining amount.

For example. if you have a vendor invoice for 100.00 and you paid 30.00 . you journal line will look something like this.

type vendor
acc no vendor no.
doc date:= "document date'
Postingdate = golivedate
amount 70
document type invoice
bal.type GL
bal acc no TheGLAcc that vendor hits.

net effect on gl is -70 + 70 = 0
Vendor sub ledger will have a open balance of 70 for the invoice. You will see that when you run aging report.

I am understanding a bit now. I am a novice in this area. I never thought of AP and AR.
What I was thinking that I will loop through all open GL entries and export in CSV file. Then I will import in general journal and post entries. but when you mentioned about AP and AR, It looks I was going very wrong.

Please help me here.

To bring AP and AR entries, I should loop through GL entries (table 17) where document type is invoice or payment and remaining amount is greater than zero and export the line with source type and source no (vendor/customer).
Then create the journal where Account no. = Vendor, Bal. Account no. = account no. in the above gl entry.

I have doubt whether I should loop in table 17 or I should read vendor ledger entry directly and post it through purchase journal.

For GL entries (where document type is blank), I should create journal line with blank bal. account no and post it.

I will appreciate your help here (please ignore my little knowledge on this area)

Thanks a lot.

loop through Cust ledger and vendor ledger and export the data. as two separate files.

Loop through GL accounts table 15 and export the balance.

You will have 3 files and then you can import them all into General journal. The purchase and sales journal are just name of the form/page. They are all Gen. journal line table.

Posting AP and AR will create GL entries for the GL account I will use as Bal. Account No.
While exporting G/Account with balance, shall I omit the GL account used in above step?

Thanks

no.

when Posting AP and AR will create 2 GL entries. it would hit the same account twice and net effect is zero. make sure Bal. Account No is same account as AR/AP account.

Hi,

On the above post you said to loop through customer / vendor ledger entry and create file and use Bal. Account No. as AP/AR account. For payment type entries, shall I use the bank account as bal. account no.

Thanks,

No, the money isn't in the bank, so why hit the bank ledger?