Automated Importing of A/R batches.

[VijayABS]

Hi There,
My client requires me to automate the importing of AR invoices through batches from another system to Accpac.

Basically my client should be able to select the file he want to upload, which is in another file format, and the macro should convert it into the required format and upload it to Accpac.


I have created a macro for converting the data format to accpac's format. How would I automate the importing of data from the file to Accpac?

 

[Jay Converse]

Put the same AVB code into a VB executable, and schedule it.

 

[VijayABS]

Thanks Tuba,
I have designed a macro in Accpac that would read data from an excel sheet and inserts the data into Accpac. Now I would want to do the same thing outside of the Accpac environment.
When I write the same macro using VB6, I get the follwoing error,
"Invalid Session"

I figure that It has to be a authentication problem. If so, how would one login into Accpac programmatically and insert data.

 

[Jay Converse]

dim Session As AccpacCOMAPI.AccpacSession
Set Session = AccpacCOMAPI.AccpacSession
Session.Init "", "XZ", "XZ1000", "54A"
Session.Open sAccpacUser, sAccpacPW, sLoginComp, Date, 0, 0

 

[VijayABS]

Thank you very much.