Adding fields to Receipt

Sep 28, 2009 3 Replies

Hey guys. My country now requires all receipts to include a sequence number. For such, I added a field to the Transaction table where I hold the number. I added a after_insert trigger on the Transaction table, and I update the newly created row by the POS program, setting the field to the next sequence number. Then, I go to the receipt xml and add a "Sequence Number:" Transaction.Field. However it says Compiler Error: Token 'Field' was not found. It does not show in the Journal either..



How can I achieve this? Thanks in advance.


Isn't the transaction number the sequence number?

Hey Rick. Thanks for the reply. This is another sequence number, different from the Transaction Number.

Roberto

"Rick Brown" wrote:

Hi Jeff,

Thanks for the reply. I suspected it used memory data and did not save-and-then-read from the database.

What unused memory variable can I use and how can I fill it up with data, provided its value *must* come from a SQL query that needs to be ran?

Roberto

"Jeff @ Check Po> Roberto,

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required