Search HansaManuals.com HansaManuals Home >> Standard ERP >> Items and Pricing >> The Pricing Module Previous Next Entire Chapter in Printable Form Search This text refers to program version 8.3 Item Formulae This page describes using Items with calculated prices in sales transactions.--- When entering Quotations, Orders or Invoices, you can use Items whose prices are calculated from the value of the other Items sold. Examples might be freight or freight insurance. Use the Item Formula register in the Pricing module to define the formulae used in these calculations. To use this feature, follow these steps:
To work with Item Formulae, change to the Pricing module using the [Switch Module] button in the Navigation Centre. Then, if you are using Windows or macOS , click the [Registers] button, also in the Navigation Centre and then double-click 'Item Formulae' in the resulting list. If you are using iOS or Android, tap the [Registers] button in the Navigation Centre and then tap 'Item Formulae' in the 'Registers' list . The 'Item Formulae: Browse' window is displayed, showing the Item Formulae that you have previously entered. To enter a new Item Formula, select 'New' from the Create menu (Windows/macOS) or the + menu (iOS/Android). You can also use the Ctrl-N (Windows) or ⌘-N (macOS) keyboard shortcut. Alternatively, highlight or open an Item Formula similar to the one you want to enter, and select 'Duplicate' from the same menu. If you don't want to open the 'Item Formulae: Browse' window before creating a new record, you can also use the + menu in the Navigation Centre (all platforms). When you have finished working with the Item Formula, save it by clicking the [Save] button in the Button Bar (Windows/macOS) or by tapping √ (iOS/Android). You can then close it using the close box (Windows/macOS) or by tapping < (iOS/Android). To close the record without saving changes, click the close box. For each record, enter a unique Code and a name and then use the grid to define the Item Formula. This is perhaps best explained by a series of examples. Once you have entered your Item Formulae, you can assign them to your Item records. The Item shown below is Freight Insurance: we have left the Base Price empty and entered the "FI" Item Formula in the Item Formula field (if you enter both a Base Price and an Item Formula, the Base Price will be ignored): In the next example, Freight Insurance will be calculated at different rates depending on the Items in the sale. The price of the Freight Insurance will be 10% of the total value of any Group 1 Items, plus 12% of the value of any Group 2 Items. Items belonging to any other Item Group will not affect the price of the Freight Insurance. In the third example illustrated below, the price of the Freight Insurance will depend on the total value of the Group 1 Items that you sell. If this value is less than 50.00, Freight Insurance will be charged as in the previous example. If it is greater than 50.00, it will be charged at 15% of the value of the Group 1 Items. In both cases, 12% of the value of the Group 2 Items will be added, while Items belonging to any other Item Group will not affect the price of the Freight Insurance. This final example is similar to the previous one, except that when Items that do not belong to Item Groups 1 or 2 are sold, 11% of their value will be added to the price of the Freight Insurance. The examples so far have used an Item Formula to add a charge to an Invoice. You can also use Item Formulae to add a discount to an Invoice, by entering a negative figure in the % column. Please refer here for details about using Item Formulae when sales prices include VAT. --- The Pricing module in Standard ERP:
|