BBritain
VIP Member
I have an invoice issue.
I have totals in the bottom right
Subtotal xxxx.xx <?Total_S_line_Extended_Price_v_ID266?>
Misc xxxx.xx <?Total_N_Line_Extended_Price_v_ID264?>
Freight xxxx.xx <?Total_F_Line_Extended_Price_v_ID268?>
Tax-HST xxxx.xx <?HST_Tax_gv_ID19?>
Tax-PST xxxx.xx <?PST_Tax_gv_ID17?>
Tax-GST xxxx.xx <?GST_Tax_Total_gv_ID273?>
Total yyyy.yy <?Total_Order_ID25?>
Unfortunately, the Total_Order_ID25 is not correct for this particular layout and the total needs to be calculated. I want to add the first six lines amount fields for the Total field. I created the Advanced line:
<?Total_S_line_Extended_Price_v_ID266 + Total_N_Line_Extended_Price_v_ID264 + Total_F_Line_Extended_Price_v_ID268 + HST_Tax_gv_ID19 + PST_Tax_gv_ID17 + GST_Tax_Total_gv_ID273?>
When I run a preview the field is blank.
The second through sixth lines are conditional so any of the rows are zero - it is not printed. When I add only the fields that are in the sample XML:
<?Total_S_line_Extended_Price_v_ID266 + PST_Tax_gv_ID17 + GST_Tax_Total_gv_ID273?>
I successfully get a Total. As soon as I add a field that is not in the sample XML (I have never seen Misc, Freight, or HST), the Total field is blank. Any suggestions?
Regards,
Ben
I have totals in the bottom right
Subtotal xxxx.xx <?Total_S_line_Extended_Price_v_ID266?>
Misc xxxx.xx <?Total_N_Line_Extended_Price_v_ID264?>
Freight xxxx.xx <?Total_F_Line_Extended_Price_v_ID268?>
Tax-HST xxxx.xx <?HST_Tax_gv_ID19?>
Tax-PST xxxx.xx <?PST_Tax_gv_ID17?>
Tax-GST xxxx.xx <?GST_Tax_Total_gv_ID273?>
Total yyyy.yy <?Total_Order_ID25?>
Unfortunately, the Total_Order_ID25 is not correct for this particular layout and the total needs to be calculated. I want to add the first six lines amount fields for the Total field. I created the Advanced line:
<?Total_S_line_Extended_Price_v_ID266 + Total_N_Line_Extended_Price_v_ID264 + Total_F_Line_Extended_Price_v_ID268 + HST_Tax_gv_ID19 + PST_Tax_gv_ID17 + GST_Tax_Total_gv_ID273?>
When I run a preview the field is blank.
The second through sixth lines are conditional so any of the rows are zero - it is not printed. When I add only the fields that are in the sample XML:
<?Total_S_line_Extended_Price_v_ID266 + PST_Tax_gv_ID17 + GST_Tax_Total_gv_ID273?>
I successfully get a Total. As soon as I add a field that is not in the sample XML (I have never seen Misc, Freight, or HST), the Total field is blank. Any suggestions?
Regards,
Ben