Purchase Order IIF Importing

If you have errors like:

Hardware:Drawer Slides:Blum:Drwr Slide Blm Tem 563.457 (18) The Item does not exist in Quickbooks 
This means we need to add the item category Hardware:Drawer Slides:Blum to the item list

[ERROR] [Sheet Goods:Plywood] The Item's Parent does not exist in Quickbooks [10415] 

 

1. Need to add Inventory:Edgebanding account
2. Sierra Forest Products exists as a Customer and not a Vendor. Importing complains that it already exists. This needs to be fixed, I was able to fix it by renaming the Customer slightly.
3.  Need to add Buyout:Doors, Buyout:Glass items

 

Things to be aware of: 

1. Material names cannot be longer than 31 characters. IIF generator will automatically attempt to shorten the name to 31 chars or less but in some cases the name will be so long that shortening it will result in most of the name being cut off.
2. Brad A used a copy of the QuickBooks data from February to tweak the import, there may be some things in the current data that need to be added.