Thanks for your assistence,

Marcel. 

As outlined in the AyaNova v3 Manual on the ImportPartsCSV utility that we provide, only new part records are imported. Existing parts are not imported, and existing parts are not edited in any way. Existing part prices used in workorders are not affected as existing part prices are not changed when using the ImportPartCSV utility.

If using the optional add-on QBI (QuickBooks interface) or optional add-on PTI (PeachTree interface), once parts have been imported, if part pricing has been changed, QBI (or PTI) will let you know at the time of invoicing that there is a price discrepancy so that you can either update the accounting program or update AyaNova with the correct price.

If you have developed your own utility to import parts, it would depend on what tables you are updating yourself.

Also, if you have created your own utility to import parts and update existing part prices, I invite you to post information about it in the forum section http://forum.ayanova.com/Forum31-1.aspx where you can sell your own third party AyaNova related products and services.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Thanks for clearing it up. This means that if I need to update prices I would need to build an external application to handle the database. I would need your help to identify how this needs to be done.

Thanks for your kind assistance.

Marcel.

We provide the AyaNova API documentation at http://forum.ayanova.net/Forum101-1.aspx to refer to if you are interested in creating your own custom utility to import/export or perform other database access

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com