Importing invoice batches into A/R

[marflo500]

Hello all,

If I am using an external program to import batchs into AR what tables should I populate in the database? So far my program makes entries in the ARIBC, ARIBH, ARIBD, and ARIBS tables. The new A/R batches are created based on the next available batch number contained in the ARR02 table so that there is no conflict with ACCPAC in terms of batch numbers. My problem is that the newly imported batches show up empty (even if the corresponding header and detail information for the entries are contained in the database). Can anyone tell me what I may be missing out? I need to see the entries in the newly imported batches in ACCPAC.

Thanks
Liam

 

[ettienne]

You should never populate any tables in Accpac, you are going to mess up the data and create a headache for yourself.

What you should be doing is one of 2 things:
1. Create import files (Excel, CSV, Access, or others) in the Accpac import file layout and then import these in AR.
2. Use the Accpac COMAPI and write the data to AR using the Accpac views.

These are 2 of the acceptable methods of getting data into Accpac, writing directly to the database tables is not acceptable, it is discouraged and it is frowned upon.

 

[marflo500]

Thanks for your response. How would I go about using the ACCPAC COMAPI and the Views to load the data into ACCPAC?

Liam

 

[ettienne]

Start by recording a macro in Accpac while you enter an AR invoice. That gives you all the views to open and the compositions, how to create a batch and how to create header and detail records and how to insert them.
Everything is there, you just need to filter out the crap.