Can the transaction detail for AR, and AP be copied?

[dbant2003]

We are in the process of amalgamating some of our smaller companies into the overall financial structure we are currently using. Transfering the customer/vendor statistics is easily done. We would like to have the transaction details for the companies available with out going into their old company data files. The companies have there own company file and at month end we do a journal entry to enter their monthly account changes into the main company data. Looking for help on either creating a macro or some form of a procedure to transfer the transcation details. I haven't metioned we are using ACCPAC 5.2A Advantage Series.

 

[jayconverse]

It's only possible if there are no duplicate vendor numbers, customer numbers, or AR Invoice numbers across the companies. It's the unique AR invoice number that will be the problem. With some data surgery, you could add a prefix or suffix to them to make them unique.

Jay Converse
IT Director
Systemlink, Inc.

 

[zemp]

You might need a bit more than a macro because of the multiple companies. I am thinking a small VB app (virtually the same COMAPI code as a macro) that fetches data from your small companies, massages the data, as required (as mentioned by Jay) and then exports it into your main company.

zemp

 

[dbant2003]

Customer/vendor/invoice numbers are unique between companies but once they are added to main company any of them that are the same will be changed to only one unique number (exception is invoice number). We have a addon that will change customer, vendor, and item numbers to be the same.

 

[dbant2003]

I am wondering if zemp has a working VB app that would do what he explained. I think that is beyond my capabilities as I am only learning how to do these things. It would be much appreciated if I was given an example to work from in creating the app to do this.

 

[zemp]

Actually I don't. I do however have some apps that collect data from non-ACCPAC programs and databases and import the relavant information. However they are much too large to post and use the xAPI (were written or started before COMAPI was avaiable).

I am willing to post examples of specific import procedures as examples (In fact I believe I already have) for you to work from. Search the forum you can find some code examples that I have posted.



zemp