Process All Invoice Records

This page uses a Hashtag List for all Invoice records, an Update Record command in the Row Template calculates and sets new values using math expressions.  
Processed this Hashtag Markup:
<# start list for invoices; #>

<# start row #>
<# update record for "invoices.<# invoices.id #>" reference as "updated";
	set updated.status to "processed";
	set updated.subtotal to <# invoices.qty #> * <# invoices.each #>;
	set updated.tax to <# updated.subtotal #> * .10;
	set updated.total to <# updated.subtotal #> + <# updated.tax #>;
	round updated.total to 2 decimals;
#>
<# end row #>

<# end list #>


The Invoices Mini-App uses the Hashtag Markup Language to demonstrate methods for processing records.

Invoice records are stored in an SQL database.   The Process example uses math expressions for multiplication and rounding to currency standards.