The type field is used to select the data that is displayed in the Open-to-Buy view.
Each type represents a property that can be used in the Open-to-Buy calculation.
The following types are included:
Empty - empty line, can be used as a delimeter or for formulas.
Sales Budget Amount - displays the amount values from the selected sales budget.
Sales Budget Amount (Cost) - displays the cost amount from the selected sales budget.
Closing Stock Value - this field is calculated based on the following formula:
Opening Stock Value
- Sales Budget Amount (Cost)
- Discount Amount (Planned)
- Negative Adjustment (Planned)
+ Purchases (Committed)
+ Purchases
-------------------------------------------------
= Closing Stock Value
This field is not the actual closing stock value but should be used during the planning phase to calculate
the replenishment need during the planning period.
Closing Stock Value (Planned) - displays the closing stock value from the selected sales budget.
Sales Amount - displays the sales amount (actual) for sales entries from the value entry table based
on the filters set in the selected sales budget.
Sales Amount (Cost) - displays the cost amount (actual) for sales entries from the value entry table
based on the filters set in the selected sales budget.
Discounts - displays the discount amount for sales entries from the value entry table based on the
fitlers set in the selected sales budget.
Discounts (Planned) - displays the discount amount from the selected sales budget.
Purchases - displays the cost amount for purchase entries from the value entry table based on the filters
set in the selected sales budget.
Purchases (Planned) - displays the amount from the selected purchase plan.
Negative Adjustments - displays the cost amount for negative adjustment entries from the value entry
table on the filters set in the selected sales budget.
Negative Adjustment (Planned) - displays the negative adjustment amount from the selected sales budget.
Opening Stock Value - not supported in this version, will always be set to zero.
Opening Stock Value (Planned) - displays the opening stock value from the selected sales budget for
the first budget period only. Subsequent periods are based on the closing stock value for the previous
period.
Open To Buy - this is the default Open-to-Buy value displayed by the system. It is based on the following formula:
Sales Budget Amount (Cost)
+ Discounts (Planned)
+ Closing Stock Value (Planned)
+ Negative Adjustment (Planned)
- Purchases - Purchases (Committed)
- Opening Stock Value
---------------------------------------------
= Open-to-Buy
Purchases (Committed) - displays the cost amount for purchase orders that have been released but not
posted in the system based on the filters set in the selected sales budget.