Tag: Custom Price List

Sample query to fetch custom price levels in customer record

SELECT netprice, internalid, base_price     FROM (         SELECT             cip.price AS netprice,             cip.item AS internalid,             ip.price AS base_price,             ROW_NUMBER() OVER (PARTITION BY cip.item ORDER BY ip.priceLevel ASC)… Continue reading Sample query to fetch custom price levels in customer record

How to getting an Individual Price List

You can generate a price list for one customer at a time. You can also customize to filter the items list. To generate an individual price list: Go to Transactions > Customers > Individual Price List. Select the customer whose price list you want to generate. If you use the Multiple Currencies feature, select the currency… Continue reading How to getting an Individual Price List