I’m trying to easily compare the retail price vs the reseller pricing so the reseller can see what is his marging on the quote or sales order.
The way I did that is I display in the item column, the price list rate, discount on price list (the reseller marging which is not the same on all the products) and the real item price (retail is 200, discount is 10, itemp price is 180.
The total now display the total of the item price but I would like to also display the price list total.
Is it possible. I didnt find any fields in the custom print format builder.
Net Weight is added as a Custom Field in the Sales Order Item table. As per your requirement, you should write a custom script around Price List Rate field. Hope other technical expert can assist you better on this.