Editing ASPs without Changing Resulting Values

Overview

Occasionally, you may wish to amend forecast ASPs for a range of products without changing the resulting sales value, i.e. you want IFP to recalculate units required to maintain original values, but using the new set of ASPs.

There is no current direct way to achieve this in IFP.  However, there is a simple workaround shown below.

Workaround

Copy Current Values at Current ASPs

1. Use Standard Actual/Forecast Editor.
2. Select target file with Data to Amend = Units, Data to Enter = Value.
3. Select required items with no sub-totals at item code level of detail (select Item Code + Grand Total levels).
4. Copy values from grid for all items (and keep these values in the clipboard).
5. Close, but do not save.

Enter New ASPs

1. Select target file with Data to Amend = ASP, Data to Enter = ASP.
2. Select required items with no sub-totals at item code level of detail.
3. Enter amended ASPs.
4. Save amended values.

Recover Original Values

1. Use Standard Actual/Forecast Editor.
2. Select target file with Data to Amend = Units, Data to Enter = Value.
3. Select required items with no sub-totals at item code level of detail.....
4. Paste the original values from clipboard into grid for all items.
5. IFP will automatically recalculate units to retain original values, subject to rounding.
6. Save amended values.