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
Number of Distributions
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,001-MZ02,Mega Company-NORTHPORT,11,-1896.00,3/27/19,40002,0,001-MZ03,Mega Company-MOBILE,11,-1416.00,3/27/19,40002,0,001-MZ04,Mega Company-FLORENCE,11,-2520.00,3/27/19,40002,0,001-MZ05,Mega Company-DECATUR,11,-792.00,3/27/19,40002,0,001-MZ06,Mega Company-MONTGOMERY,11,-1920.00,3/27/19,40002,0,001-MZ07,Mega Company-HUNTSVILLE,11,-768.00,3/27/19,40002,0,001-MZ08,Mega Company-GADSDEN,11,-2616.00,3/27/19,40002,0,001-MZ09,Mega Company-SELMA,11,-1848.00,3/27/19,40002,0,001-MZ10,Mega Company-HOOVER,11,-1680.00,3/27/19,40002,0,001-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)
Everything looks right. Why can't we see the imported data?
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