Use planning scenarios to define planning frequency and store planning settings.
Scenarios differ in the level of detail. You can use one scenario to make rough-cut plans and another one to make clarified plans.
In addition, scenarios serve as links between budgets and plans of sales, production, and purchases.
You can use the same scenario to create different plans: sales plans by products, sales plans by categories, production plans, purchase plans, assembly/disassembly plans.
To register a list of planning scenarios, go to Budgeting and planning – Settings and catalogs – Inventory planning – Planning scenarios.
The Planning scenarios list is a compulsory analytical section when generating and analyzing fulfillment of all plan types.
Define panning frequency and period display mode (a date range or a period number within a year) on the Main tab. Here you can also choose how to enter purchase/sales plans: with prices and amounts, or only quantitative ones.
A scenario by which plans will be recorded in budgeting is specified.
Planning frequency defines in which intervals plan data will be entered, plan orders will be created, and plan-fact will be analyzed. For example, the Month frequency means that planning purposes do not depend on the day of the month specified in the fact (in plan fulfillment), 1st or 31st.
Planning frequency defined by a scenario:
- Ten-day period
With the Only by quantity purchase and sales planning, you can enter only quantitative purchase/sales plans.
With the Only by quantity and amount purchase and sales planning, you can enter purchase/sales plans with prices and amounts.
If a scenario currency differs from the management currency, actual data in plan fulfillment reports will be converted to the currency specified in the scenario.
When generating new plans, you can use data from other plans in any statuses. For this purpose, there is the Receive data from other plans in status field in the sales & operations planning scenario. In this field, you can set the Confirmed status or specify a list of statuses in hierarchical order (for instance, Canceled – Under development – On confirmation – Confirmed). During planning, you will receive data of other plans in statuses set by the scenario within which planning is carried out.
To use data of generated plans in budgeting, the Record plans in budgeting parameter is available. When recording plans in budgeting, specify a value of the By scenario field in the profile of the sales & operations planning scenario. In this field, specify a scenario serving as an additional data separator which helps to store several versions of enterprise financial state plan drawn up for one time interval.
If you need planning by pegged demand sources, select the Planning by assignments check box in the scenario profile to itemize plans by assignments.
On the Creation settings tab, you can see what plans (for example, a sales plan, etc.) and plan fulfillment orders (for example, purchase orders, etc.) should be generated by this scenario. For example, if purchase plans are created within the scenario, you can set up a plan profile for purchase planning with the Create by scenario – Purchase plans check box selected. Within a scenario, you can edit plan profiles created earlier, view all plan profiles specified for using a certain plan (click Plan profiles), and view all plan profiles within a certain scenario (click All plan profiles).
Within the planning scenario, transition from "Plan" to "Order" is defined. With the Sales & operations planning scenario item, you can create a scenario by which planning will be carried out and the plans will be fulfilled by generating certain orders.
Sales & operations planning scenarios (Create by scenario):
- Planning of enterprise demand for goods for the planning period (select the Purchase plans check box):
- Actual demand fulfillment by purchase plans is provided by generating purchase orders – the Purchase orders check box.
- Sales forecasting by product categories "By volume" (select the Sales plans by categories check box):
- If you need to forecast sales by product categories "By sales speed", select the Sales rate calculation check box. In the latter case, you cannot allocate a product category plan to products considering a product sales rank and speed.
- Sales forecasting in a fixed period (select the Sales plan by products check box to generate sales plans by products).
- Planning of product item quantity for assembly/disassembly (the Assembly (disassembly) plans check box):
- Actual demand fulfillment by assembly (disassembly) plans is provided by generating assembly/disassembly orders – the Assembly (disassembly) orders check box.
- Registration of forecasted indicators by product (semi-finished product) manufacturing in a fixed period (the Production plans check box):
- Actual demand fulfillment by production plans is provided by generating production plans – the Production plans check box. Parameters of the Configure material transfer in department products are considered.
- When planning manufactured products, you can plan semi-finished products and automatically calculate demand for materials, work center kinds, and human resources (by departments). For this purpose, select the Calculation of demand for materials, work center kinds, and human resources check box. Dates of demand for manufactured products and semi-finished products and dates of demand for materials, work center kinds, and human resources are calculated according to the enterprise work schedule. You can specify an individual enterprise calendar according to which calculations will be carried out in the Calendar field. If a calendar is not specified in the planning scenario, the main enterprise calendar will be used to calculate demand dates.
- If you need to order materials to fulfill demand for production according to the plan, select the Orders for materials check box. If the Production order check box is cleared and the Orders for materials check box is selected, all materials will be displayed in the Generation of orders for transfer to production wizard disregarding settings of material transfer to production. It will help to fulfill demand for internal enterprise needs.
To save settings according to which plans are filled in, use plan profiles. To register plan profiles, go to Budgeting and planning – Settings and catalogs – Inventory planning – Plan profiles.
With plan profiles, you can:
- Specify a plan filling option (by sources or using formula).
- Specify a planning method.
- Specify data details in plans (detail/do not detail a plan).
- Set up plan filling rules (a quantity filling source, a quantity calculation rule, etc).
- Disable editing plan filling rules.
Plan profiles are used when generating the following documents (the Use for field):
- Sales plan
- Sales plan by categories
- Production plan
- Assembly/disassembly plan
- Balance plans
- Purchase plan
This field defines what plan (of sales, purchases, assembly, production, or balance) can be created using this setting.
You can create various plan profiles with different control sections by one planning scenario. For example, you can create generalized plans by planned sales volume for the whole enterprise, or plans with sales volume details by each department or with sales volume details by an agreement with a customer. It will help to plan Retail sales by stores, Wholesale by departments and responsible employees, and Wholesale by key customers for the enterprise as a whole. In its turn, using plan profiles with various control sections can lead to issues when analyzing such diverse data. It is recommended that you create plan profiles with similar control sections.
You can create plan profiles from the plan profile list or by clicking respective links in the planning scenario profile.
Defining a plan filling option
Simple filling option (using formula) – provided to fill in content and quantity of product items in plans from all operands (sources) specified in a formula. You can set arbitrary filters in an additional form.
There are the following benefits of the simple filling option (using formula):
- Creating arbitrary formulas using various default operands (Available stock, Sales plan, Purchase fact, etc.), operators, and functions. A set of operands can be expanded during implementation. 1C:Enterprise language is supported in calculation formulas.
- Automated tool ensuring precise and correct filling of plan data.
- Certain formula can be set up for each product item line.
- Using data accumulated for the previous period, the similar period of the last year, or the period moved for...
With this filling option, you can specify simple data details for a plan. Options of the Detail plan by plan details are defined by a plan type.
Details by the following parameters are available for plans:
- Purchase plan:
- With payment plan specification
- Sales plan:
- Responsible employee
- Store format
- With payment plan specification
- Balance plan:
- Assembly (disassembly) plan:
- Production plan:
- Dispatcher department.
- Sales plan by categories:
- Store format
Advanced filling option (by sources) – to fill in plans (both content and quantity of product items), you can use any data from the infobase (data sources), including your own data sources. It allows you to set up filters and receive data with various details. You can use several sources together according to a certain rule. You can disable changing a rule specified in a plan profile. For example, a department manager develops plan filling rules, and other employees fill in the plan in accordance with these rules.
There are the following benefits of the advanced filling option (by sources):
- Wide range of ready-to-use templates (data composition schemas).
- Any arbitrary query in the infobase (as long as plans understand this query result).
- Using any infobase data (Sales, Available stock, Purchase orders, Sales orders, etc).
- Simultaneous use of several data sources (composition schemas).
- Grouping different data sources (for example, Orders for internal consumption, Available stock, Purchases, etc).
- Various filters to specify data by planning sources.
With this filling option, you can specify both simple data details similar to simple filling option (using formula) and advanced data details (for example, a joint plan by customers/suppliers, warehouses, etc.) for a plan. With advanced filling option, you can set the Detail plan by detail options with subsequent generation of joint plans for purchase plans, sales plans, and assembly (disassembly) plans.
With a joint plan by each detail, you can specify a lot of different values in one document. For instance, you can create one plan specifying all or several warehouses. In this case, a plan with a certain warehouse for a product item in each line will be generated.
You can generate joint sales plans by customers (select By customer – Joint plan by customers) and by agreements with customers (select Agreement – Joint plan by agreements).
If you need to generate a joint purchase plan by suppliers, select Customer – Joint plan by customers; by agreements with suppliers – select Agreement – Joint plan by agreements; by warehouses – select Warehouse – Joint plan by warehouses.
To plan product item assembly (disassembly) by several warehouses, select Warehouse – Joint plan by warehouses.
You can generate a single plan (of sales, purchases, assembly (disassembly), or production) by several pegged demand sources by selecting the Joint plan by assignments check box. With such details, you can specify an assignment in each plan line. Preliminarily, details by an assignment are determined in the planning scenario.
If you need to enter planned inpayments or cash debiting by sales plans and purchase plans, select the With payment plan specification check box. It allows you to specify payment schedule steps in sales plans and purchase plans. This parameter is available in the plan profile if the By quantity and amount sales/purchase planning is enabled in the scenario within which the plan is generated. You can draw up a payment plan only if a plan is drawn up without details by partners or by each partner separately.
Defining a planning method
A planning method depends on the following parameters:
- Substitute – can be used for rolling planning when new plans substitute for the previous ones.
- Cumulative – can be used for cumulative planning when new plans are summed up with all previous plans.
For more information about planning methods, see chapter "Planning methods".
Number of planning periods
You can specify a number of periods in advance in the Number of default periods field in a plan profile within which planning will be carried out. A plan will be created for the number of periods specified in the plan profile. You can change periods in the plan.
Setting up plan filling rules
You can set up a data filling rule within a certain plan profile by clicking Default filling rule. The Fill in plan form appears. Here you can define and select a planning data source (the Quantity filling source field). A filling rule defined for a plan profile will be used by default when generating plans which are registered within this plan profile.
You can set up a filling rule if the Advanced filling option (by sources) filling option is selected in the plan profile.
To disable editing filling rules (data sources for filling and settings), select the Disable editing the rule check box. In this case, you cannot set up filling rules when generating a plan within this plan profile.
Planning data sources
To fill in plans, planning data sources are available.
You can fill in products and their quantity based on planning data sources only if planning is carried out within a plan profile with the advanced filling option (by sources) set.
Options of planning data sources are described in Budgeting and planning – Settings and catalogs – Inventory planning – Planning data sources.
With planning data sources, you can have the following opportunities:
- Wide range of ready-to-use templates.
- Arbitrary query in the infobase.
You can use any data stored in the infobase (sales and purchases of goods for the previous periods, data on the current sales orders, expected goods supply, available stock, etc.) as sources.
You can also use previous plan data and information on minimum and maximum balance as a data source. To fill in plan amount indicators, you can use data on selling prices and supplier prices.
Planning data sources are generated according to the data composition schema (the Data composition schema field in the Planning data source form). Several ready-to-use templates of the data composition schema are available in the application. With these templates, you can easily create new planning data sources.
To set up rules of source data generation, click Edit in the Planning data source form. The Settings of planning data source form appears.
The following options are available when setting up rules of data source generation:
- Selecting one of the predefined templates (the Data composition schema field) which will be a planning data source (for example, Sales orders, Available stock, etc).
- Creating a new template allows you to create your own planning data sources.
You can select the following predefined templates of data composition schema:
- Sales – selects records of sales documents by the "Revenue and sales cost" accumulation register by goods sold from a warehouse.
- Purchases – selects sales document by the "Purchases" accumulation register.
- Assembly (disassembly) – selects records of the Assembly (disassembly) documents by the "Company batches" accumulation register by goods delivered to a warehouse.
- Available stock – selects available stock by the "Available stock" accumulation register considering reserved goods.
- Sales orders – selects goods planned for shipment from a warehouse from the Sales order documents. For example, you can consider all planned goods shipments to customers next month when creating a plan.
- Purchase orders – selects goods planned for receipt to a warehouse from the Purchase order documents.
- Orders for internal consumption – selects goods planned for shipment from a warehouse from the Order for internal consumption documents.
- Transfer orders (shipment) – selects goods planned for shipment from a warehouse from the Transfer order documents.
- Transfer orders (goods receipt) – selects goods planned for receipt to a warehouse from the Transfer order documents.
- Assembly orders (shipment) – selects goods planned for shipment from a warehouse from the Assembly order documents.
- Assembly orders (receipt) – selects goods planned for receipt to a warehouse from the Assembly order documents.
- Sales plans – selects records of Sales plans by the "Sales plans" accumulation register.
- Sales plans by categories – selects records of Sales plan by categories by the "Sales plans by categories" accumulation register.
- Sales plans (components) – selects records of Sales plans by the "Sales plans" accumulation register.
- Assembly plans (components) – selects records of Assembly (disassembly) plans by the "Components consumption plans" accumulation register.
- Assembly and disassembly plans (kits) – selects records of Sales plans by the "Sales plans" accumulation register.
- Purchase plans – selects records of Purchase plans by the "Purchase plans" accumulation register.
- Production order fulfillment (materials to be ordered) – selects records of Production orders by the "Order fulfillment" accumulation register.
- Production plans (materials) – selects records of Production plans by the "Material consumption plans" accumulation register.
- Production plans (products) – selects records of Production plans by the "Production plans" accumulation register.
- Production (products) – selects records of the Product release and work performance documents by the "Product release reference" and "Standard write-off reference" accumulation registers.
- Budget turnovers – selects records of Budget entry documents by the "Budget turnovers" accumulation register.
- Goods limitations – selects specified goods limitation values by the "Goods limitations" information register. Specify a stock type in parameters: Safety stock, Minimum stock, Maximum stock, or Average daily consumption.
To fill in prices in sales and purchase plans, use relevant ready-to-use templates (the Data composition schema field):
- Min supplier price – selects a minimum price value for products on the date from the Supplier product prices information register.
- Supplier product prices – selects prices on the date from the Supplier product prices information register.
- Product prices – selects prices on the date from the Product prices information register.
When generating plans of sales and purchases by prices, you can select a planning data source which will allow you to fill in all plan fields.
You can create your own planning data source (a new data composition schema) in the following ways:
- Based on an arbitrary template of the data composition schema. In this case, set the Arbitrary value in the Data composition schema field and configure the schema by clicking Edit – Edit composition schema (create a new query text). This schema will be named Arbitrary (the name can be changed if necessary).
- Based on any predefined template of the data composition schema (Sales, Available stock, etc). In this case, select any predefined template (the Data composition schema field) which has similar settings and specify rules of generating source data by clicking Edit –Edit composition schema. When editing the data composition schema, make the necessary changes in the query text or in other settings. This schema will be named Arbitrary (the name can be changed if necessary).
With an arbitrary data composition schema, you can receive any data from the infobase.
You can edit the data composition schema only in the thick client mode.
You can also fill in plans based on planning sources by which data is selected by relevant statuses of plans created earlier. To do this, specify a certain plan status (for example, Confirmed) or a list of statuses to select (for example, Confirmed, On confirmation, or Canceled) (the Status field) in planning data sources.
This option is relevant for such data sources as Purchase plan, Sales plan (components), Sales plan by categories, Sales plan, Assembly plan, and Production plans.
The following parameters correspond to predefined templates of the data composition schema (on the Parameters tab in the Settings of the planning data source form):
- Change to the seasonal index – allows you to change the selected data to the seasonal index. An index by which the source result is multiplied is calculated as the ratio of the seasonal index for the planning period (the plan period) to the seasonal index for the period of source data selection.
- Fulfillment parameters – allows you to filter the source selection result by fulfillment parameters or by the main demand fulfillment method.
- Assortment – allows you to filter the result of source data selection by assortment settings: goods allowed for purchase or sale, an assortment role, a store format, etc. In the document filling rule in the source settings, specify a date on which assortment settings and settings of store formats for warehouses are defined in the Assortment for date parameter.
- Selection with period offset – allows you to specify a number of offset periods against the document planning period.
- ABCXYZ filter – allows you to filter goods by ABC or XYZ classification.
You can import a data composition schema from an external file by clicking Import schema from file.
According to a source type, you need to define how data will be selected by this source (data selection mode) in the Planning data source form:
- over period – when filling in a plan, specify a period for which source data will be selected for the source. For example, goods sales volume for the previous month or quantity of goods planned for receipt over the next month.
- as of – when filling in a plan, specify a date on which source data is generated for the source. For example, stock balance as of the beginning of the planning month.
- without restrictions – when filling in a plan, a source is not limited by dates, and all data stored in the infobase will be filled in. Use this option for data sources which do not have frequency (for example, information on minimum stock balance).
- with period offset – when filling in a plan, data will be specified according to the set value of period offset against the current period specified in plans. For example, a sales plan for the next month (against the current one) is created based on maximum sales volume for previous three months. In this case, select an option with period offset and specify an offset value for each source: "-1", "-2", and "-3". Data of the current month, the previous month, and the month before last will be selected.
After you enter main planning data sources, register plan filling rules based on the sources.
These rules can be specified in a plan or specified in a plan profile in advance as a default filling rule.
To refine data by planning sources, you can use various filters. For more information, see chapter "Advanced filling option (by sources)".