Please… I have studied the IIF code generated and once again in 2.0 the Inventory Item Cost column is outputted and is default ZERO.
Observe:
!INVITEM NAME INVITEMTYPE DESC PURCHASEDESC ACCNT ASSETACCNT COGSACCNT PRICE [B][COLOR="Red"]COST[/COLOR][/B] TAXABLE
INVITEM B00024848Y INVENTORY adidas Camp Tee; Product options: Clothing Size: Large; adidas Camp Tee; Product options: Clothing Size: Large; Sales:Product Inventory Asset Cost of Goods Sold 9.99 [B][SIZE="3"][COLOR="Red"]0[/COLOR][/SIZE][/B] N
INVITEM B0009ALVNQ INVENTORY adidas Men's Avantis Jersey; Product options: Clothing Size: X-Large;Color: Silver/Black/Black; adidas Men's Avantis Jersey; Product options: Clothing Size: X-Large;Color: Silver/Black/Black; Sales:Product Inventory Asset Cost of Goods Sold 22.99 [B][SIZE="3"][COLOR="Red"]0[/COLOR][/SIZE][/B] N
INVITEM B0007OAYIW INVENTORY Adidas Mens ClimaCool Jacquard Argyle Polo; Product options: Clothing Size: Medium;Color: Tango; Adidas Mens ClimaCool Jacquard Argyle Polo; Product options: Clothing Size: Medium;Color: Tango; Sales:Product Inventory Asset Cost of Goods Sold 54.95 [B][SIZE="3"][COLOR="Red"]0[/COLOR][/SIZE][/B] N
This will cause the import of orders to overwrite the cost value for inventory items in Quickbooks every time orders containing those items are imported.
The first thing I plan on doing when 2.0 is ready is:
- Add a cost field to the product table/variants tables right next to the price fields - why this isn’t already there I cannot understand - this is a no-brainer to add. This is especially the case if the Quickbook configuration page specifically asks you where you want COGS to be tracked! Otherwise defining that destination in the Chart of Accounts is completely meaningless.
- Track the product cost to the Quickbooks !INV rows and default the value to a NULL instead of zero - this column value is not even strictly required for successful import of an order. If there is no value, the column should appear but the value in the row is blank.
Observe, from the IIF sample spec for PO importing via IIF per Intuit’s website:
[QUOTE]An IIF file has a header line that explains to QuickBooks what information it is going to
be seeing next. All header lines begin with an exclamation point. This file contains the
header lines needed to import to the chart of accounts, item list, class list, customer list,
vendor list, and a P.O. transaction. Some columns may not have anything in them and that is
fine, however, the headers and columns need to be there for QuickBooks to be able to import
it correctly. Just leave them blank if you do not have anything that goes in that field.[/QUOTE]
Is there a rationale behind why this fix has not been implemented officially?