Import P/O Invoice Entry

[BillyLei]

Does anyone have experiences or know if it is possible to import/insert a P/O invoice entry programmatically. I am using Accpac Advantage 5.2 but Import isn't an option in my P/O Invoice Entry.

I need some helps badly, very appreciate.

 

[zemp]

Yes it can be done successfully. You will need to use the ACCPAC xAPI or the COMAPI (COMAPI is preferrable)objects. You can create a macro or do it externally in VB (for example).

Basically you need to create an ACCPAC session and then open the views that you need and insert the data into the views and update ACCPAC. There is obviously more involved than that. I suggest that you look into programming with the ACCPAC objects. Search this forum for xAPI and COMAPI for examples and issues that you may come accross. If you have access to the ACCPAC site then downloading the SDK would be helpful. The SDK has many examples. Also download the Application object model for your version of ACCPAC.

Otherwise when youo have specific questions about the objects and how to program with them you can post another question.

Goos Luck!



zemp

 

[BillyLei]

Thanks Zemp,

As you said, I've done all required steps up to the point that actually inserting the record. I have no idea which fields are required and editable, so I tried a few fields and keep getting an error saying "Invoice line must be apply to a receipt line". Any light on this?

 

[jayconverse]

Billy -

Step #1 is to record a macro in Accpac that adds an invoice. That will show you the view compositions, and tell you which fields are required.

Jay Converse
IT Director
Systemlink, Inc.