Purchase Plans

Overview and Settings

To plan purchases, use Purchase plans.
To enable purchase plans, go to Master data and settingsBudgeting and planning and select the Purchase plans checkbox.
Purchase plans checkbox.png
With purchase plans, you can do the following:
  • Plan purchases broken down by warehouse, business unit, vendor, and terms of purchase
  • Store parameters for automatic generation and filling of purchase plans
  • Automatically fill plans by formulas, by sources (system data) or by importing from spreadsheet files
  • Compare purchase plans with other demand and supply plans
  • Control purchase plan execution and payments to vendors

Registering Purchase Plans

To create a purchase plan:
  1. Go to Planning > Purchase plans.
  2. Click Create.
  3. On the Main tab, specify the Scenario and Plan profile. For details, see Planning Master Data.
  4. Specify the planning Period.
  5. If applicable, specify the Warehouse, Business unit, Vendor, Terms of purchase, and Assignment (depends on the plan profile settings).
Purchase plan 1.png
6. On the Goods tab, specify a list of items to purchase and their quantity. You can fill in the document automatically using the following commands:
If Fill in by sources population option is selected in the plan profile:
  • Click Fill goods > By filter... to fill items using goods selection tool by any parameters (item, warehouse, price, retail format, and so on). OR
  • Click Fill goods > By custom rule. It will open the Fill in plan form where you can set the data source to fill in the quantity. The sources for filling in the quantity are planning data sources.
By sources.png
If Fill in using formula population option is selected in the plan profile, click Fill in goods. It will open the Fill in plan form where you can:

1) Fill in items:
  • By all vendors' part numbers. Allows you to fill in items by part numbers of all vendors.
  • By goods purchased from all vendors. Adds all items purchased from all vendors.
  • From formula. Items will be received from the operands specified in the formula.
  • By filter. Allows you to fill in items by the arbitrary filter set in the document.
From formula.png
2) Fill in quantity using the formula.

To import lines from the spreadsheet:
  • Click the Import from external file icon.
  • In the import from external file form, paste data copied from the spreadsheet.
  • Click Next. The system will automatically parse all the data pasted and fill in the form with the system master data.
  • Review and amend the information and click Move and close. The system will automatically fill in the form.
7. If sales prices are applied in the plan profile, specify the Vendor price type and Price for each line.
Goods tab.png
8. On the Payment tab (available if sales prices are applied in the plan profile), enter the payment schedule. The total amount of planned payments must match the total amount of goods on the Goods tab.
Payment.png
9. Set the document status to Confirmed.
10. Click Post and close.

Analyzing Purchase Plan Data

You can plan actual execution of purchase plans and payments by business units using the Purchase plan fulfillment by business units report in PlanningBudgeting and planning reports.
The following report options are provided:
  • Purchase plan fulfillment by vendors
  • Purchase plan fulfillment by warehouses
  • Payment and shipment plan fulfillment by vendors
Purchase plan fulfillment reports are intended for variance analysis of items by vendors, business units, and warehouses.
The Payment and shipment plan fulfillment by vendors report allows you to estimate the planned and actual payment to vendors for the period.
To check if purchase plans can fulfill other demand plans, use the Plan balance for the period report.
Reports.png