Import data from Sage

hafi
hafi Member Posts: 8
edited 2000-07-07 in Navision Financials
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.

Comments

  • Dave_Cox
    Dave_Cox Member Posts: 83
    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).]
    MindSource (UK) Limited
    Navision Service Partner

    david@mindsource.co.uk
    info@mindsource.co.uk
  • Dave_Cox
    Dave_Cox Member Posts: 83
    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
    MindSource (UK) Limited
    Navision Service Partner

    david@mindsource.co.uk
    info@mindsource.co.uk
  • hafi
    hafi Member Posts: 8
    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
    Dave_Cox Member Posts: 83
    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.
    MindSource (UK) Limited
    Navision Service Partner

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

Categories