Importing Invoices and Gross Wages

[mark_anderson_u]

Hi All,

We develop print management information systems and our software produces customer invoices, credit notes, purchase orders, gross wages and can also book supplier invoices.

We have some prospective customers who have QuickBooks and others looking for new accounts systems. We can export the data how we need to, but my question is can QB import it and keep the invoice numbers, etc.

Can it import customer and supplier records (and update exisitng addresses if they change) and , if supplier invoices are booked in QB, can they be exported for us to read.

Can it accept gross wages (hours worked and hourly rate and calculate net wages from it)

If anyone has details on the import export formats (fields, etc.), I'd be greateful for a copy.

Finally, what version of quickbooks would a printer need for just doing the P&L and payroll (net wages)/

Thanks

Mark

[rusty3200]

You should be using the Intuit (QuickBooks) Software Developer Kit. See www.developer.intuit.com

[mark_anderson_u]

Hi Karl

Unfortunately the SDKis out (and overkill) as our server runs on LINUX. Our customer typically post batches once a month, so we don;t need a tight online connection: just a way to import export

Thanks

Mark

[gibbo]

We have written a utility for a web-based CRM where they collect the information on a web-server as text files. We ftp it down, delete the files and then use the sdk to write the xml for import into QuickBooks. They append if exists, create if doesn't exist.
Writing new Customers is easy, as is transactions. Modifying existing Customers is fun as you need to extract info from QuickBooks which you have to quote back to it in order to make the modifications.
QuickBooks does have a text file format (no longer supported by Intuit, that still works - though not as cleverly as the xml sdk) for manual import.
How will the user get the data from your server?

[rusty3200]

Look in QB Help for IIF.