Batch AR Invoice Import Automation

[Mab-a]

I am currently able to import into sage 300 using AccpacImportExport in vb.net
Is it possible to read from the excel template generate in sage 300 directly, and possibly
import from multiple excel files in a location.
Any pointers would be much appreciated.

 

[ettienne]

Yes and yes. Don't use the accpac import engine, use the views instead.

Sage 300 Certified Consultant

 

[DjangMan]

Record a macro of the fields that you're importing. Convert that to .Net, add your code to signon to Sage and then you're good.

 

[Mab-a]

Sure, Thank guys for your response.
Much appreciated