Need a DDE Solution

[gervic]

Hello.

I have been using PCA 2002 for 2 weeks now as a front end to my dbase files.

I use PCA primarily for its sales invoicing task. This means I regularly (twice a week) import my dbase inventory items to update the price levels of my PCA inventory items. I do this by first deleting lineitem.dat in my PCA company folder before doing the import task. This will import my whole dbase inventory file. However, I found out this procedure will cause problems with the quantity on hand (which cannot be imported) and incorrect postings of items bought by my customers.

I would like to contract an Access 2000 solution (DDE perhaps), given an Access table with the necessary fields (Item ID, last unit cost, and five price levels) which will replace using the same Item ID the corresponding data fields in PCA. The Access table may contain only items whose prices has changed.

Is this possible? How much?

Thanks.

Joseph

[Robert Walraven]

You can do that with PawCom. There is an update flag in the PawCom Line Item Header table that you can set for the records you want to update. The function mwUpdateFlagged_LineItem will then update all the flagged records in the Peachtree LineItem file.

Bob Walraven
Architect of PawCom

[gervic]

Originally posted by Robert Walraven
You can do that with PawCom. There is an update flag in the PawCom Line Item Header table that you can set for the records you want to update. The function mwUpdateFlagged_LineItem will then update all the flagged records in the Peachtree LineItem file.

Bob Walraven
Architect of PawCom

Yes, I know. I tried the sample program with Bettweller Garden Supply.

What I just need is a single Access routine not the whole PawCom.

Joseph

[Robert Walraven]

PawCom is not an Access application even though it comes with an extensive Access front end. It is a COM object library. That means it is pre-built and contains all the functionality whether you need it or not. It isn't really practical or economical to build special limited-functionality versions of PawCom for one-up applications.

Hope this clarifies.

Bob
Architect of PawCom

[riscniaga]

if you are only concerned with price changes you can use either of the following:

1. peachtree price changer which is available from www.peachtreeusers.com
2. export/import of inventory item list to make the price changes.

if you also need to track the quantity and cost as well, then you will need to import the inventory adjustment journal.

the easiest is to use excel to link to your dbase file and to create a macro to produce your .csv files.

deleting the lineitem.dat may not be a good idea.

depending on how many items you have, the import process should take about 1 or 2 minutes.

hope that helps.