Import data from Sage

hafi · 2000-07-04

Can anyone recommend an efficient way of importing all the ledger details from Sage into Navision. We have tried a dataport direct into the Vendor Ledger Entry table using a .csv file, but was denied access.

Our Solutions centre used a variety of journals. I want to import data as if we had booked in Navision first & hence get a clean audit trail.

Dave_Cox · 2000-07-05

Never Import Directly Into the Ledger Tables

Import Into a Journal then Post the Journal balanced through a Suspense Account.

If you have the Applied Reference in your data, you can apply a payment to an Invoice in the Same Journal which will close on Posting.

IE
Invoice 1234
Payment 5678 Applies to Doc:Invoice Applies to Doc No:1234

If you post a Sales/Purchase Journal Remember to Blank out the GPPG etc:

This will stop the VAT/TAX postings.

If you are bringing on Open Documents and then the Same Documents directly into the Debtors/Creditors G/L Control Accounts.

Temporary set the Debtors/Creditors Control Account to the Suspense, (Vendor Posting Group: "Payables Account") this will create the Customer / Vendor Ledger Entries, and stop the Double Postings by netting the Suspence to 0.00
while not creating the matching record in the Control Account, which will be posted directly through a G/L Journal, once again balanced to a Suspense Account.

MindSource (UK) Limited
Navision Service Partner

david@mindsource.co.uk
info@mindsource.co.uk

[This message has been edited by Dave Cox (edited 05-07-2000).]

Dave_Cox · 2000-07-05

You will need help from your NSC to Create a Dataport.
Fields need to be Validated on AfterImportRecord to make sure that the Information is Correct.

Did you Journal on History or just Opening Balances to the G/L ?

MindSource (UK) Limited
Navision Service Partner

david@mindsource.co.uk
info@mindsource.co.uk

hafi · 2000-07-06

Journal on history, I assume. One method suggested was to use one dataport that would bring in the vendor transactions with the balance to a suspense account, and the second all the G/L transactions and the balance to suspense.

We need to add more detail to our G/L. So we thought we would reclassify to new account codes in Excel (we have added more detail to our chart of accounts), & then dataport in each nominal line and the corresponding vendor entries through a general journal.

Although tedious this should ensure a full audit trail, without recourse to Sage.

Dave_Cox · 2000-07-07

As you post the Vendor Entries the G/L entries are created at the same time, If you apply the Invices to the payments they also will close balanced to suspense.

Have a play with Cronus
Create a Purchase Journal
Create 1 Payment No 1234 £400
Create 4 Invoice Lines of £100
Then apply them in the Journal to Doc Type:Payment Doc No:1234
You will not be able to pick the payment No. by drilldown you will have to type it in!

I would suggest that you talk to your reseller A.S.A.P and ask for thier help & advice!

Blank the Posting Groups to disable VAT entries being Created.

Then go to Registers find the last entry and Navigate.

Howdy, Stranger!

Quick Links

Categories

Import data from Sage

Comments