Calculated fields

Follow
Calculated fields can be found under Tools / Calculated fields A calculated field, unlike manipulated fields, is a field you create and keep in your accounting. It is a field that consists of data from another field you choose or a calculation you define. Note: A calculated field cannot be retrieved in the report generator. In the report generator, create a new calculated field (Calculated field) The field is created on one of the existing tables, such as the inventory table, InvItemClient.

Local menu for Calculated fields

Description of buttons in the Calculated fields pop-up menu
  1. Add field
    • Adds/creates a new calculating field
  2. Edit
    • Editing an already created field
  3. Update
    • Refreshes the page after changing the fields

Example of calculating the average of sales prices

To make a calculation, you must first select a table to make the calculation on. Follow the example below for an overview of the use of calculated fields.
  1. Select Tools / Calculated fields
  2. Select the table to calculate on, in this case Inventory, InvItemClient
  3. Select the InvItemClient table (Items) and click Calculated fields
  4. You will then get an overview of already created fields and the option to add a new field.
  5. Click Add field to create a new custom field
  6. Enter information for your calculated field. Below we name the field cfldGenSales and a prompt Average of sales prices and in the example a type of Double is selected which is comma.
  7. In the Script field, enter the calculation you want to perform. In Add Fields, you can choose which fields you want to calculate on by clicking the dropdown box to the right. See the image below
  8. To calculate the average price of the three sales prices, type/select the following: (rec.SalesPrice1 + rec.SalesPrice2 + rec.SalesPrice3) / 3
  9. Remember to click Save before leaving the calculated fields
  10. A new field has now been added to the item overview. The field is automatically placed on the far right of the overview, but can be dragged in and placed in a more central location.