1. Home
  2. Point-Of-Sale Software
  3. Adding fields to Receipt

Adding fields to Receipt

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.

Reply to
Roberto A
Loading thread data ...

Isn't the transaction number the sequence number?

Reply to
Rick Brown

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

Roberto

"Rick Brown" wrote:

Reply to
Roberto A

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,

Reply to
Roberto A

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.