Creating budget items
To create a budget item:
- Go to Company.
- Under Project management, click Budget items.
- In the displayed window, in the Budget type field, select a budget type to add a budget item to.
The budget type list is based on the Budget types catalog. - Click Add.
- In the displayed window, fill in the following fields:
- If Type is set to Formula, specify a formula. To do this, click Edit. Then, in the Formula editor, double-click budget items that you want to include in the formula and logical or arithmetic operators for them. To check if the formula is correct, click Check formula. If the formula is correct, click OK.
To display a percent sign (%) next to the formula calculation result, select the Percent checkbox. For example, this is a good option if the formula calculates gross margin percentage. In reports on budget items, % will be displayed next to the gross margin value.
Note. Selecting the Percent checkbox does not mean that percentage is calculated. To calculate it, you need to specify the corresponding formula. - If Type is set to Add or Subtract, on the Data tab, fill in the following fields:
- If Type is set to Add or Subtract, when required, on the Filters tab, specify filters applied to the selected data source. Each filter is an additional rule for collecting actual data for a budget item.
To specify the rules, fill in the following fields:Field Description Parameter A filter parameter. By this parameter, 1C:Drive will search for the actual data in the selected data source.
To select a filter parameter:- Click . 1C:Drive shows a list of data fields that you can apply as filter parameters. Available data fields vary depending on the selected data source.
- Select a data field and click Select.
Condition A condition applied to the selected filter parameter. A list of conditions is predefined and depends on the filter parameter type. Value The filter parameter value associated with the selected condition.
The list of values depends on the specified filter parameter and condition.For example, for budget item "Other expenses", a rule requires to collect only amounts of expenses other than cost of goods sold (COGS). Then, Parameter is Income and expense item, Condition is Not equal, and Value is COGS.
- Optional: In the Description field, specify additional details about a budget item.
- Click Save and close.