FormerMember

Import Doesn't Show up in Journal or Ledger

Posted By FormerMember

We want to import a csv file instead o manual entries to save time. I select file "Select Import/Export" select "General Ledger" and then we created a template for our import file. The fields are in this order

Reference

Description

Number of Distributions

Amount

G/L Account

Recur Number

Recur Frequency

and then select the file we will be using.

The data we are trying to import as a test is;

Alaska,Mega Company,11,16776.00,1/31/19,10050,0,0
01-MZ02,Mega Company-NORTHPORT,11,-1896.00,3/27/19,40002,0,0
01-MZ03,Mega Company-MOBILE,11,-1416.00,3/27/19,40002,0,0
01-MZ04,Mega Company-FLORENCE,11,-2520.00,3/27/19,40002,0,0
01-MZ05,Mega Company-DECATUR,11,-792.00,3/27/19,40002,0,0
01-MZ06,Mega Company-MONTGOMERY,11,-1920.00,3/27/19,40002,0,0
01-MZ07,Mega Company-HUNTSVILLE,11,-768.00,3/27/19,40002,0,0
01-MZ08,Mega Company-GADSDEN,11,-2616.00,3/27/19,40002,0,0
01-MZ09,Mega Company-SELMA,11,-1848.00,3/27/19,40002,0,0
01-MZ10,Mega Company-HOOVER,11,-1680.00,3/27/19,40002,0,0
01-MZ11,Mega Company-ATHENS,11,-1320.00,3/27/19,40002,0,0

it give no errors but can't fine the data anywhere in the system. We did an export with the same template and received; (just a few lines)

Deposit,8,14645.60,1/2/19,10050,0,0
Deposit,8,-1890.00,1/2/19,40004,0,0
Deposit,8,-384.00,1/2/19,40003,0,0
Deposit,8,-1416.00,1/2/19,40011,0,0
Deposit,8,-6890.00,1/2/19,40004,0,0
Deposit,8,-4432.00,1/2/19,40002,0,0
Deposit,8,-2010.00,1/2/19,40006,0,0
Deposit,8,2376.40,1/2/19,50250,0,0
Deposit,2,7954.43,1/2/19,10100,0,0
Deposit,2,-7954.43,1/2/19,40050,0,0

Everything looks right. Why can't we see the imported data?

Parents
  • 0

    You may want to compare the sample import files under the following path (which may be different in your environment depending on how it was installed)  C:\Program Files (x86)\Sage Software\Sage MAS 500 Client\GL\Imports.

    Choose a file with a del suffix (delimted) and match up with yours

    -Tony

Reply
  • 0

    You may want to compare the sample import files under the following path (which may be different in your environment depending on how it was installed)  C:\Program Files (x86)\Sage Software\Sage MAS 500 Client\GL\Imports.

    Choose a file with a del suffix (delimted) and match up with yours

    -Tony

Children
No Data