Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

A manual price list is similar to a table in Excel where you maintain your product prices manually. In addition, you can add a calculation logic to it, which will help you to calculate the values of certain columns according to the required business rules. You can also keep there any supporting columns you wish (e.g. Product Category, Classification, Profit, Revenue, etc.).

...

The following actions are available:

  • Add a new manual price list Image Removedlist 
    • Enter a 'Name', 'Valid After' date and 'Status'. When the status is "Simulation Only", Simulation Set can be specified. By setting a value in the 'User Group (Edit)' and 'User Group (View Details)' columns, the access to the manual price lists can be restricted to certain user groups. Optionally you can link the manual price lists with a Calculated Field Set and automatically calculate fields in the manual price list.
  • Anchor
    EditManualPL
    EditManualPL
    Edit a manual price list Image Removed
    • If it is a new price list, you will need to add products first. Click the 'Add' Image Removed icon and select the list of products from the product master. You can use the simple or advanced filter.
    • By right-clicking the header area of the list (any column), select 'Columns' and add an attribute column to the view. Any column can be renamed and used to display the price.
    • The price can be set manually. Multiple columns can be used to indicate multiple prices or other attributes.
    • To edit all products in a (filtered) view, click the 'Mass Edit' Image Removed icon (for details see Mass Edit).
Note

Note:

  • The Last Updated By and Created By columns in the grid show the name of the user who last updated / created the Price List. However, if the user name changes, the existing records will still show the old user name.
  • Changing individual line items in the Price List will not update the Last Updated By column value in the Manual Price Lists (header) table.

...

  • Calculate all currently valid manual price lists:

    Paste code macrocode
    languagegroovy
    actionBuilder
    	.addManualPricelistAction(pricelist.uniqueName)
    		.setCalculate(true)


  • Calculate manual price lists valid in the future:

    Paste code macrocode
    languagegroovy
    actionBuilder
    	.addManualPricelistAction(pricelist.uniqueName)
    		.setValidFrom(new Date()+ 30 /*days */)
    			.setCalculate(true)