How to: Create a Purchase Budget from Purchase Data

In this article

To create a Purchase Budget from historical Purchase Data

Retail Purchase Budgets let you reuse historical purchase data when a new budget is created. This is usually done when a Purchase Budget should incorporate an overall growth in purchase in the next planning period.

Example: A company has purchased items worth 50 million in the current year and plans to increase purchase by 10% in the next year. The future budget should be based on the historical purchase data and apply the expected increase.

To create a Purchase Budget from historical Purchase Data

  1. Click the icon, enter Retail Purchase Budget List, and select the relevant link.
  2. In the Retail Purchase Budget List, select the budget you want to plan. Click the Purchase Budget action.
  3. Click Create - Create Budget from Purchases.
  4. In the Options window, select a Budget. This is defaulted to the current budget. If you wish to select a different budget it must be one to which you have edit permission, if the Edit Budget permission is not set to Anyone in the Replen. Setup. For more details see Budget Permissions.
  5. The Purchase Start Date, No. of Periods, Period Length, Date Change Formula, and Multiplication Factor fields will be populated from the selected Budget.
  6. If the selected budget is a Hierarchy Node budget, change the Source Hierarchy Code, if needed. The Source Hierarchy Code is defaulted to the Item Hierarchy currently assigned to the budget. The purchase history of the items belonging to the source Item Hierarchy will be considered for budget entries creation. For example, when creating the budget entries for the Hierarchy Node CLOTHING, the purchase history from the items assigned to the CLOTHING node in the source Item Hierarchy is used to create the budget entries.

    Note: The selected source Item Hierarchy should have the same Hierarchy Nodes structure as the Item Hierarchy assigned to the budget.
  7. Click OK.

Note: The Create Budget from Purchase functionality lets you get the estimated value from historical data and then the new purchase budget is constructed by multiplying the estimated historical data with the Multiplication Factor.