[meang]

I’ve done the &xml=t trick on sales orders & invoices and found a variable called rateschedule on each line item.

The XML looks like this

43.47826087

0

45.217391304347824

39

44.347826086956527

79

43.478260869565229

The above XML essentially describes my pricing structure for that line item where the rate is what the customer was charged and the other values describe pricing for quantity of 0, 39 & 79 respective.

What I’m looking to achieve is to get the value 45.217391304347824 so I can compare to the rate of 43.47826087 and calculate any “discount” to show on my invoices/sales orders.

I’ve tried accessing it as ${item.rateschedule} which throws an error. I’ve also tried traversing rateshedule as a list and it’s throwing another error.

Would appreciate any tips on accessing this data
This is a cached copy. Click here to see the original post.

[Author]

Posts