Importing in Sage Accpac 5.4 Accounts Payable

[versair]

I am new to Sage Accpac and just moving from the good old Accpac for DOS. I need to import from a non off the shelf application which can output to a csv file.

Where do I start in Sage? I use to create one csv file from my application to inport into accpac for DOS. But I am not sure what to do because when I try to export a batch in sage to examine the format, multiple files are created (2 or 3).Would I need to create multiple csv files from my application to import into Sage Accounts Payable?

Help! Anyone?

 

[ettienne]

Select "Single CSV" when you export, this will give you a single file.
The basics of importing is to first export a batch to get the file layout, and then create your import files in the same layout.

 

[versair]

Thanks for your prompt reply. When I am at the Export dialog, I selected "Single CSV File" and setup the file path. Below that however I see three boxex with a plus sign to the left to expand. The boxes are:

Invoices
Invoice_Details
Invoice_Payment_Schedules

How do I use these? Do I need to select from all 3?

Basically I want to import from my external program, Vendor Number, Document Number, Document Date, Description , Gl-Breakdown, Amount Total for each invoice.

How would I go about creating this file?

Thanks for your help.

 

[ettienne]

Invoices relates to the header fields, Invoice_Details relates to the detail fields.
Yes, you need to select at least some fields from all 3.