[ic] log_transaction question
DB
DB at M-and-D.com
Wed Sep 29 18:54:31 UTC 2010
> DB wrote:
>> I wish to set the value of the "payment_due" field of my transactions
>> table to "1" whenever an order is placed as a purchase order.
>>
>> I see this section in my log_transaction file
>>
>> [if value mv_payment_mode eq purchase_order]
>> set credit_limit: [seti credit_limit][data
>> table=userdb
>> col=credit_limit
>> key="[data session username]"
>> value="-[scratch total_cost]"
>> increment=1
>> ][/seti]
>> [/if]
>>
>>
>> Can I add something like an [import]....[/import] statement to this
>> section to accomplish my goal
>
> Hi DB,
>
> If "payment_due" is a column in the "transactions" table you will need
> to add the field between the import tags which log values to this table.
> Look for an import tag similar to the one below in etc/log_transaction
>
> [import table=transactions type=LINE continue=NOTES]
> ...
> [/import]
>
> Hope this helps,
> Chris
Hi - am I able to stuff an "if" condition within the [import] tag such as:
[import table=transactions type=LINE continue=NOTES]
...
[if value mv_payment_mode eq purchase_order]
paid: 1
[/if]
[/import]
More information about the interchange-users
mailing list