How To: Create a Net price list from a Gross price list

This page may prove useful to B2C companies, where the System Values "Sell prices are net" checkbox is not ticked
(i.e. the system has been set to use gross sell prices).

To create a net price list from a gross price list, where the amount column contains gross sell prices,^[1] the following should work, but please try it out first on your KHAOS_TESTING system:

1. Confirm that the 'Amount' column on your gross price list contains the gross price.
2. Create the new net price list (e.g. Trade) from the System Data screen (see How To: Setup a Price List).
3. Open a Promotion screen (show me how) and select the new price list.
4. Ensure the new price list's 'Price List is Net' checkbox is NOT ticked.
5. Select the old gross price list you wish to copy from.
6. Press the  to see the Target Price List dialog:
   
   
   
   
7. Select the destination price list (e.g. Trade) and click "OK".
8. In the Confirm popup click "Yes".
9. In the Information popup click on "OK".
10. Load the new price list and check it has the items copied from the old price list.
11. Press Alt+E or click  to enter edit mode.
12. Tick the 'Allow editing list prices' checkbox.
13. Tick the 'Price List is Net' checkbox.
14. Green select all the standard VAT rated items you want to change the prices of.
15. Select 'Update Prices / Discounts' from the grid's right-click context menu to display the Stock Price Update dialog:
    
    
    
    
16. Press the 'Update Amount' radio button, tick the 'Percentage (not Amount)' checkbox and enter the percentage value you have calculated that will reduce the gross price to a net price.
17. Save the pricelist.
18. Confirm the prices have updated as expected.

Notes

See Also

• Promotions Overview