Customize the Price List to Print the Base Price
This is an alternate Solution for Enhancement 273947 – Customization > Forms > Transaction Forms > Price List > Columns > Please add a standard field for item base price .
Steps to customize the price list to print the base price:
- Create a custom field on the subsidiary record to assign a customercredit limit
- Navigate to Customization > Lists, Records, & Fields > Item Fields > New
- Set the following: • Label: Base Price (custom) • Type: Currency • Store Value: T (This has to be marked since auto-sourced fields cannot be added to the price list form)
- Under Applies To tab, mark the following boxes: • Inventory Item (and/or other item types you sell) • Print on Price List
- Save
- This field can then be added to the PriceList form.
- Copy the actual base price to the custom field. You canmanually enter the base price to the custom item field or do a mass update.Here let’s mass update instead:
- Navigate to Lists > Mass Update > Mass Updates
- Click General Updates
- Click Inventory Items
- Under Mass Update fieldstab, mark the ‘Base Price (custom)’ box (the one created earlier)
- Enter {price}in the Formula column field (This represents the base price)
- Preview (Untickitems you do not need to update)
- Click PerformUpdate
- This should populate the custom item field onall inventory item record with the base price.
- Add the ‘Base Price (custom)’ to your Price List form
- Navigate to Customization > Forms > Transaction Forms
- Edit the Preferred Price List form
- Under the Columns subtab, make sure that the ‘Base Price (custom)’ is checked on the Print/Email column box.
- Print the Price list