[ic] quickbooks_trans item-data

Schuyler Langdon interchange-users@icdevgroup.org
Sat Oct 26 12:43:00 2002


Quoting myself:

> I'm using quickbooks_trans to write qb import files. However, the
[item-data
> inventory account] tag is not evaluating. All my item-codes correspond to
> the "code" field in the options table eg "shirt001-L-Green". Using the
> item-data tag to access the account fields from the inventory table, I
> assumed that the item-code relates directly to "sku", the primary key in
the
> inventory table. Since it's not returning anything -- I'm thinking maybe
> it's keying the inventory table on the product sku and not the item-code.
Is
> this the case?
>
Regardless of what the deal is with the item-data tag, it looks like for a
catalog with matrix options, a data tag would have to be used instead. eg:
$Tag->set("ACCT",$Tag->data("inventory", "account", "[item-code]"));

Another item of note as far as quickbooks is concerned, my version QB2001
chokes on the carriage returns that are added at the end of a transaction:
$Scratch->{qb_trans} =~ s/\s*$/\r\n/;#had to remove the \r\n from this
statement
However, I did change the report from an INVOICE to a CASH SALE since the
client deals with retail goods -- not sure if that would have anything to do
with how QB handles it.

--
Schuyler Langdon
GatorDev