Filling in plans is quite the same for all types of plans. Let's have a look at how to fill in plans using Sales plan as an example.
Depending on the detail option selected in the plan profile, you can record the planned sales volume for a specific department (a warehouse, a partner, an agreement), for several warehouses (partners, agreements), or for an enterprise as a whole without details. The following methodology is applied:
- If detail check boxes are not selected in the plan profile, then a plan is made for the enterprise as a whole.
- If details by department are selected in the plan profile, then a separate plan is made for each enterprise department.
- If details by a warehouse (a partner, an agreement) are selected in the plan profile, then a separate plan is made for each combination "warehouse — partner — agreement".
- If the plan profile shows that making a joint plan for a warehouse (a partner, an agreement) is possible, then a joint plan is made for several warehouses (partners, agreements). In this case, specify information on the warehouse (partner, agreement) in the document tabular section.
The diagram shows various planning options depending on a plan profile (with details/without details).
The plans are recorded for a specific period with the specified frequency. Specify the period for which the plan is being generated in the document and the plan frequency in the planning scenario.
You can create joint plans with data details for each period. For example, you can create a monthly plan and define indicators for each week of a month. In this case, specify a month (several weeks) in the Period field and the Week frequency in the planning scenario. If you use this period display option, a number of columns equal to the number of weeks appears in the document tabular section.
You can enter a planned quantity in each column. All the columns will be summed up automatically, and the amount will be displayed in the Quantity column.
You can fill in the plan either manually or automatically. There are the following options for autofilling depending on the filling order selected in the plan profile: a simple option (using formula) or an advanced option (by sources). You can also fill in the document using external data calculated in Microsoft Excel spreadsheets.
When posting plans, completely empty lines are controlled. To delete empty lines, click More actions — Delete empty lines.
During planning you can also take advantage of the following:
- Register the difference between the estimated quantity of a product item (using formula) and the one edited manually (the Variance from formula field. The difference is calculated automatically).
- If there is no need to plan product items, then you can cancel values in lines of the tabular section of the plan (select Canceled in the tabular section of the panning document). You can also cancel the selected document lines by clicking Cancel plan lines/Clear marks. The number of canceled product items is highlighted with a transparent color.
- Add a comment to each line of the product item (the Comment field). For example, specify a reason why the product item was canceled or changed. You can enter a free-format comment.
For better visualization of several periods, you can select how they will be displayed in the plan tabular section. For plans, there are two options for displaying a period (click More actions — Periods):
- Periods in columns. If the Periods in columns display mode is selected, then specify a planned quantity and a planned amount in the columns with specification of a period for each product item (product category).
- Periods in lines. If the Periods in lines mode is selected, then duplicate product items (product categories) in the tabular section and specify planned quantity and a planned amount as of the date of the beginning of period in each line.
In the Periods in lines mode, you can also set a shipment date (the Shipment date column) for each plan line within the specified period (for example, if a period in the plan is set for a month, you can specify a custom date within this period for each line).
Simple option for filling in a plan (using formula)
With a simple option (using formula), you can take the following independent steps to make a plan:
- Fill in product items.
- Calculate and fill in the quantity of product items using a formula.
There are various methods for filling in products (select a method in the Fill in plan form available in the plan form). Let's have a look at filling in products using sales planning as an example.
You can fill in products in Sales plan using the following:
- List of goods purchased by all customers during the infobase maintenance (Goods purchased by all customers).
- List of products by the assortment allowed for sales (Assortment).
- List of goods by arbitrary filters set in the document (Filter).
- List of goods to be received from operands (sources) specified in the formula (Formula).
You can fill in a quantity of product items manually or using the formula set in the Fill in plan form (Fill in quantity using the formula).
To fill in the product quantity, create a new formula, and edit it, you can also click:
- Set formula on the Goods tab (Formula at the bottom of the plan form). The hyperlink appears in the plan form when selecting a column with the quantity.
- Hyperlink to the previously entered formula on the Goods tab (Formula at the bottom of the plan form).
To calculate a quantity of product items, use the following options (in the Edit formula form):
- Use a set of operands (can be expanded during implementation) in the formula — the Operands section.
- Create arbitrary formulas using the tools available in the Operators and functions equation builder.
- Embedded language support in calculation formulas.
You can specify a formula for each plan line.
In case of the "using formula" filling option, any product item available in data of each operand of the formula used to calculate the quantity will be added to the goods list. For example, if you specify the Available stock * 15 % formula, all products in stock will be added to the plan list and the quantity will be calculated using the specified formula.
To recalculate the goods quantity within the plan, you can use the following functions (click Operators and functions — Functions):
- Column value (<Column sequence number>)
- Current column number
Using these functions allows creating a new formula: [ColumnValue(CurrentColumnNumber() - 1)] — this function will return the previous column value. It is recommended that you use this function for rolling planning as it allows you to recalculate values of cells (periods) horizontally.
A new Sales plan has been generated within the substitute plan profile for 3 months (February, March, April). In the document, February and March are filled in with values of the previous plan of the relevant period, and the planned new month (April) is filled in with the March values by calculating the goods quantity using the ColumnValue(CurrentColumnNumber() - 1) formula.
Latest entered formulas are stored in the application, and you can use them to fill in other plans (the Operators and functions — Latest used formulas section in the Edit formula form).
To calculate the quantity of products, actual infobase data is used according to the set period Use accumulated data from the base for (for example, previous period, similar period of the previous year, period moved for...).
If amount indicator specification is available in the planning scenario, fill in a price type according to which amount indicators will be populated in the plan in case of simple filling option. To set a price type according to which goods prices will be filled in, click Change prices.
When the prices are filled in, you can edit data in the plan. For example, you can set an arbitrary formula for calculating the selected items, change the quantity by percent, and round it off. To access these features, click Change quantity in the plan form:
- Specify arbitrary formula allows you to specify a formula using operators and functions.
- Round off quantity allows you to round off the planned product quantity. To round planning data up to an integer, select rounding precision "1". You can select any rounding precision.
- Change by percentage allows you to change the planned product quantity. Whenever you click the link, a form appears prompting you to set a percent the product quantity should be changed by.
In case of advanced filling option, you can take advantage of even more flexible plan filling rules: use several planning data sources, group data, etc.
Advanced option (by sources) allows you to:
- Fill in product items.
- Fill in quantity of planned product items.
A list of fields selected by different planning data sources should match the fields imported to the plan tabular section.
A list of fields that you can import to the plan tabular section:
- Period — if the field is available in source data selection, then its value should be within the planning interval. If the field is not selected in the source, then the quantity will be evenly distributed among planning periods for a period in the columns.
- Products — the field must always be present in planning data source selection.
- Characteristic — used if the respective functional option is enabled.
- Warehouse — used if the Joint plan by warehouses details are selected in the plan profile.
- Customer — used if the Joint plan by customers details are selected in the plan profile.
- Agreement — used if the Joint plan by agreements details are selected in the plan profile.
- Quantity — the field must always be present in planning data source selection.
- Price — used if the Sales planning by quantity and amount setting is set in the planning scenario.
- Amount — used if the Sales planning by quantity and amount setting is set in the planning scenario.
To configure the rule according to which the plan will be filled in, use the Fill in plan form by clicking Fill in goods — Configure rule and fill in... in the plan form.
Various rule configuration modes are available:
- Use simplified features. In this mode, you can do the following:
- Add one quantity filling source according to which the plan will be updated or supplemented (the Quantity filling source field).
- Filter data by the specified source.
- Use full functionality. In this mode, you can do the following:
- Add or specify several quantity filling sources according to which the plan will be updated or supplemented (click Add a new source).
- Group the specified quantity filling sources and set shared use rules for them (click Group sources).
- Set resulting filters once all the changes in quantity filling sources are made (the Filters section). According to the filters, data will be selected for plans that will be made in accordance with the scenario and the profile of each specific plan.
To group sources (in the Fill in plan form):
- In the source list, select the sources you need to group.
- Click Group sources.
A new group is created. The Addition rule is determined for the group by default. You can set a different source interaction order: Maximum, Average, or Minimum. For example, select the maximum sales volume per month during the first quarter (January, February, March) when preparing a sales plan. In this case, three identical data sources are added to the source list — monthly sales volume (Sales). Specify a different data filter period for each source. These sources are grouped, and the Maximum rule is applied to them.
When defining shared use rules, you can create any number of source groups and then define a shared use rule for each group. For example, you can define a maximum sales volume per month during the quarter and an average number of goods ordered during the quarter, and select a maximum value out of these two indicators.
You can increase or decrease the planning indicators from the calculation by a certain percent. To do this, use the tool in the Quantity calculation rule section in the Fill in plan form:
- If you need to increase planning indicators, specify a positive indicator value in the Change result to (%) field.
- If you need to decrease planning indicators, specify a negative indicator value in the Change result to (%) field.
To round planning data up to an integer, set "1" in the round for period to field. You can select any rounding precision.
To refine data on planning sources, use various filters.
In the diagram, you can see filters by planning data sources.
Let's have a look at an example. You need to forecast sales from the Selling area warehouse for the February 2017 period based on sales orders with the goods quantity > 100 (part of which can be fulfilled with goods in stock) and plan difference between the balance and orders.
Fill in the sales plan according to the diagram shown below.
Filters in planning data sources
To create a sales plan, use the following planning data sources: Sales orders and Available stock.
As you need to plan sales for a specific warehouse, filter data by sales orders and available stock in the Selling area warehouse. To specify data by planning sources directly, set filters on the Filter tab in the Settings of planning data source form. You can open the form by clicking Edit.
Filters in a filling rule by planning data sources
You can specify the following quantity filling sources in the sales plan filling rule: Sales orders and Available stock. Filter by a warehouse was earlier set for the specified sources.
As you can see in the example, you need to filter data by sales orders with quantity (for shipment) more than 100 units. Part of them can be supplied with available stock in the quantity of 410 units.
In the filling rule, specify data on the selected planning sources (the Fill in plan form, the Filling rule section). The filters set directly in the planning data source are also saved.
In the filling rule for the Sales orders source, set a filter by the Quantity (for shipment) field in the value more than 100 with increasing data on sales orders by 10% (the Change result to (%) field).
For the Available stock source, set a filter by the Quantity (available stock) field in the value of 410.
Group the selected quantity filling sources and set the Addition shared use rule for them. Specify "-" for sales orders and "+" for available stock. This means that the data on the sales orders will be removed from the available stock when preparing a plan.
Resulting filters in filling rule by planning data sources
For grouped planning sources, you can also set resulting filters (the Fill in plan form, the Filters section). For example, you can filter data by sales orders and available stock by specific products Air conditioner FIRMSTAR 12M (the Fill in plan form, the Filters section, the Products field).
According to the customized rule and the set filters, Sales plan will be filled in with products Air conditioner FIRMSTAR 12M in the quantity equal to 289 units of goods.
Filling in data based on external sources
In the planning subsystem, you can use additional features of automatic filling of a plan tabular section regardless of a plan filling option:
- Using data import from an external file of arbitrary format by clicking Import from external file. Using data import from an external file allows you to add products, characteristic, packaging and shipment date from an external file (Microsoft Excel, Microsoft Word) to a data processor.
- By clicking Excel — Import from Excel. By clicking this button, you can:
- Export a pre-filled plan.
- Import it with product recognition.
First, you need to attach a file of any format (generated in another infobase) to the document and import data from spreadsheet files (*.xls, *.mxl, etc). .mxl is a format for storing files in 1C:Enterprise spreadsheet documents. If new product rows are added to a Microsoft Excel spreadsheet document, they will be identified automatically. For unmapped values, specify the matching items manually. The respective data is registered in master data.
Importing from an external source allows you to fill in a goods list and other attributes from any spreadsheet document by pasting data from clipboard. You can export the generated pre-filled plan to a Microsoft Excel spreadsheet document via an attached file (click Export to Excel) if you need to change data and import it to the plan tabular section.
You can use any external data processor to fill in plans.
Using external data processors ensures the following:
- Arbitrary algorithm of filling in and calculating quantity of product items.
- Custom forms for entering external data.
1C:Subsystems Library determines the rules for creating additional external data processors and adding them to the application.
Planning payment steps by sales and purchase plans
When planning purchases and sales, you can fill in information on planned payment schedule steps.
To specify a scheduled payment plan in the sales and purchase plans, use the following settings:
- Sales/purchase planning by quantity and amount is enabled in the planning scenario:
- Sales planning: By quantity and amount
- Purchase planning: By quantity and amount
- The With payment plan specification details are selected in the plan profile.
As a result, the Payment tab appears in sales and purchase plans. You need to fill in information on the payment schedule and planned payment steps on this tab. The payment plan contains dates (the Payment date field) and amounts (the Payment amount field) of planned payments by the sales plan.
If a payment schedule (the Payment schedule field) is specified, then the payment plan is filled in according to the rules specified in this schedule.
The following options for filling in the payment schedule are available:
- If a sales (purchase) plan is made for a specific customer (supplier) with agreement specification, then information on the payment schedule is filled in automatically from the agreement with the customer (supplier) (the Payment schedule field). To fill in the document tabular section in accordance with the payment schedule, click Fill in payment schedule steps. As a result, information on payment amounts and dates is filled in for each step.
- If a sales (purchase) plan is made without details by customers/agreements, then specify information on the payment schedule manually. To fill in payment schedule steps, click Fill in payment schedule steps.
If planning is carried out within an agreement and this agreement provides contract-based relations, then you can use debt control in contracts.
After an actual payment has been made by a customer (supplier), you can check how the payment schedule for planned sales (goods deliveries) is being kept to.
To analyze how a sales plan and a purchase plan are being fulfilled in regard to payments, you can use the respective reports (Budgeting and planning — Budgeting and planning reports — Inventory planning):
- Sales plan fulfillment by departments (the Payment and shipment plan fulfillment by customers report option).
- Purchase plan fulfillment by departments (the Payment and shipment plan fulfillment by suppliers report option).
Recording plans in budgeting
Sales & operations planning data can be a data source for generating budgets.
If the Record plans in budgeting check box is selected in the planning scenario, sales & operations planning data can be recorded in budgeting. In the By scenario field, specify a scenario using which the plans will be recorded in budgeting. Planning scenario is a tool separating several options of financial plans in the application.
Sales & operations planning data can generate a budget for certain items. For this purpose, select the respective check boxes in the Record by budgeting items setting group and specify budget items for which this plan profile is recorded (in the plan profile card).
For example, to record sales plan data by budgeting data, use a setting group in the plan profile used for the sales plan:
To make the Record by budgeting items — Payments setting group available, set the With payment plan specification parameter in the plan profile (this parameter is available if planning by quantity and amount is enabled in the scenario).
If payments are recorded by planning data, you can establish a correspondence between all the payments within the common budget item and/or set an individual item for each of the planned payments.
Filling in the Record by budgeting items group in the Plan profile item form will allow you to carry out real-time recording of payment plans based on plans by the budget items specified in the plan profile.
The specified budgeting item is displayed in the plan header (Record by budgeting items on the Main tab).