How to handle PO Importer Validation Errors

The primary items that will create validation errors are Vendor Names, Product IDs and Warehouse values.  When these values are missing in Acctivate, but are in your import file, a validation error will occur.  You will either need to correct the data in your spreadsheet or add the data in Acctivate.

If you are importing from one of our Memorized Reports and you are receiving errors on every line this may be because you exported out of QuickBooks® without blank columns.  Open your spreadsheet and verify that columns A, D, F, H, J, L, N, P, R, T, V and X are all blank (if you used the report with Sites then column Z should also be blank). If these columns are not blank it can be corrected in a couple of different ways. If you have made modifications to your data and don’t want to redo them then you can simply insert blank columns. If you have no modifications, or just a few, then you may want to re-export the data from QuickBooks®. When you re-export make sure to click the Advanced button on the Send Report to Excel screen and make sure the “Space between columns” is checked.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s