Import old datas into a fresh navision database for dummies?

boby

Hello,
I'm a newbie in Navision and I'm asked to import datas into a new database.
In fact, this datas are old commercial operation (invoices..) needed for statistics. The "G/L entry" table may not be affected, but the Customer ledger entry, detailed customer ledger entry, VAT entry, Item ledger entry and value entry have to be completed.

What should I do? Is it possible?

Thank you for your suggestion

kine

I think it is not quest for dummies... :-) This is mainly work of your NSC to import history into the database... 8)

DenSter

I wouldn't even thinki about importing data directly into the ledger tables. The common practice is to import data into journals and then run the posting routines.

And Kine is right, you should have your solution center do this for you, or at least have them involved as consultants.

kine

Yes, the journal is used to import the data...

You must know, what are you doing, because if you import something wrong, and start productive run on this wrong data, there is no easy step back... and your accounting can be wrong...

boby

Thank you for your answers.
If I use journal to import those datas, won't the G/L entries be affected?
How can I manage this when we'll start a new fiscal year? :-s
I don't want to import everything since 35 years #-o

DenSter

Yes they will affect G/L, of course, how can you do any accounting without affecting G/L? Generally, you would import the beginning balance say 2 years ago, and then all the transactions since that date as general journals. That should tie out your G/L right to the penny. It gets more complicated when you start talking about balancing your AP and AR, but the same principles apply there. You import a balance at some date and historical information over a certain period.

All that aside, this really is not a job for beginners.

boby

Thank you for your advices and tips..

I' m a (almost) a beginner, but if I don't find some kind of solution, my job will be over. You don't know my boss :?

In fact, I don't want to affect accounting, but be able to see stats like for example what this client bought since 5 years...

Savatage

One of the things we did was import all the opening balances & open invoices etc etc etc. as stated above.

We left the old accounting package as is.
If we needed to see history on a customer we would open that package to get the info.
Yes, it was awkward in the beginning switching back and forth.
As we started using Navision the history slowly grew and we began using the old package to get old info less and less.
Now, I can't remember the last time I had to access that data.

plus this way I guess it won't affect your G\L like you were worried about.

ps: Kine & Denster really know what they are talking about so I would take their advice seriously.