Create a formula field

K inventory is a simple, fast solution that enables companies of all sizes to transform their inventories into a true value-creation tool.

The Create Formula field feature in the K inventory management application lets you add a customized field to obtain calculated data specific to your needs.

 

 

This feature is only available on the Web version.

 

1. In the menu on the left of the screen, click on Toothed wheel Settings then on Custom fields.

 

2. Go to Custom fields managementclick on the Create field.

 

3. In Field typeselect the required type, here Formulathen enter the Name of the field.

 

 

 

4. Select a formula template.

 

 

The customized formula is automatically created.

You can modify the chosen formula template to suit your needs.

 

5. Click on to customize the frequency and times at which your formula is calculated (updated).

 

6. Choose the time at which your formula will be applied.

 

7. Choose an update frequency from the list Repeat frequency.

 

 

8. Save your changes with the Save.

 

4. Choose a variable from the drop-down list Available variables.

 

 

5. The variable has been added to the formula.

 

6. Add a mathematical symbol corresponding to the desired operation

  • *
  • +
  • /
  • ( )
  • ^

 

7. Select another variable from the list available variables.

 

The variable has been added to your formula.

Repeat if necessary to obtain the desired formula.

 

8. Select the desired result type from the list Result type.

 

 

9. Click on to customize the frequency and times at which your formula is calculated (updated).

 

10. Choose the time at which your formula will be applied.

 

 

11. Choose an update frequency from the list Repeat frequency.

 

 

12. Save your changes with the Save.

Predefined templates

 

4. Select a formula template.

 

 

The customized formula is automatically created.

You can modify the chosen formula template to suit your needs.

 

5. Click on to customize the frequency and times at which your formula is calculated (updated).

 

6. Choose the time at which your formula will be applied.

 

7. Choose an update frequency from the list Repeat frequency.

 

 

8. Save your changes with the Save.

Customized formulas

 

4. Choose a variable from the drop-down list Available variables.

 

 

5. The variable has been added to the formula.

 

6. Add a mathematical symbol corresponding to the desired operation

  • *
  • +
  • /
  • ( )
  • ^

 

7. Select another variable from the list available variables.

 

The variable has been added to your formula.

Repeat if necessary to obtain the desired formula.

 

8. Select the desired result type from the list Result type.

 

 

9. Click on to customize the frequency and times at which your formula is calculated (updated).

 

10. Choose the time at which your formula will be applied.

 

 

11. Choose an update frequency from the list Repeat frequency.

 

 

12. Save your changes with the Save.

To continue browsing, here are a few articles related to this page: