--- title: "Future Price Review - Field Definitions" canonical: "https://kb.myframeworks.com.au/space/FRAM/28391602/Future%20Price%20Review%20-%20Field%20Definitions" format: markdown --- The **Future Price Review** screen allows users to review and amend future prices for products before the future prices are applied within the system. From the **Future Price Review** screen, users can update new costs, sell prices, GP percentages and effective dates for future dated products. Future pricing is applied to products either via [importing an EPC supplier file](https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/30510902) with future pricing included, or by manually entering future pricing in the [Product Maintenance](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28378114) screen. ## Screen Access From the **Frameworks Menu**, navigate to **Inventory** > **Maintenance** > **Future Price Review**. ## Screen Structure ![image-20260305-053528.png](media://d92c9124-0ec6-472d-b149-e59131dfebc3) The **Future Price Review** screen is organised into four main sections: 1. [Search Options and Effective Dates](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28391602/Future+Price+Review+-+Field+Definitions#Search-Options-and-Effective-Dates) - Filter by date and stocked status, and select an effective date to review. 2. [Future Price Grid](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28391602/Future+Price+Review+-+Field+Definitions#Future-Price-Grid) - View and edit future pricing for all products within the selected effective date. 3. [Actions Menu](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28391602/Future+Price+Review+-+Field+Definitions#Actions-Menu) - Additional options for managing future pricing. 4. [Command Buttons](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28391602/Future+Price+Review+-+Field+Definitions#Command-Buttons) - Save, cancel or close. --- ## Search Options and Effective Dates ![image-20260305-053555.png](media://449d9654-a3ed-4198-bd0e-8e21ff2879ab) The **Search Options and Effective Dates** section allows users to define the date range for future pricing review and displays a list of effective dates with pending future price changes. Selecting an effective date loads the associated products into the **Future Price Grid**. ### Date To The **Date To** field defines the upper date limit for the future pricing search. All effective dates up to and including the **Date To** value are displayed in the effective dates list. Adjust the date to extend or narrow the range of future pricing periods shown. **Action:** Click the **Calendar** icon to select a date. **Format:** Date (DD/MM/YYYY) | **Required:** Yes | **Editable:** Yes ### Stocked Only The **Stocked Only** checkbox filters the results to display only products that are flagged as stocked for the current branch. When disabled, all products with future pricing are displayed regardless of stocked status. **Format:** Checkbox | **Default:** Disabled | **Editable:** Yes ### Find The **Find** button executes the search based on the **Date To** and **Stocked Only** values and updates the effective dates list. **Action:** Click **Find** to refresh the effective dates list. ### Effective Date (Column) The **Effective Date** column displays the date on which the future pricing changes are scheduled to take effect. Click the **Effective Date** hyperlink to load the products for the selected date into the **Future Price Grid**. **Action:** Click the **Effective Date** hyperlink to display the associated products in the **Future Price Grid**. **Format:** Date (DD/MM/YYYY, hyperlink) | **Editable:** No (display only) ### Type (Column) The **Type** column displays whether the future pricing entry is at the **Master** (product) level or the **Branch** level. **Format:** Text | **Editable:** No (display only) --- ## Future Price Grid ![image-20260305-053914.png](media://243a34da-0ca5-473d-b471-06982482fbcf) The **Future Price Grid** displays all products with future pricing for the selected effective date. Editable fields are highlighted in grey and can be updated directly in the grid. The grid uses the same calculation logic as the **Future Standard Pricing** section in **Product Maintenance**: updating any pricing field automatically recalculates related values based on the relationships between cost, sell price and gross profit percentage. The grid columns can be customised by right-clicking the column header to show or hide columns. The columns marked with a tick in the column chooser are visible by default. ### Product The **Product** column displays the product code. **Format:** Text | **Editable:** No (display only) | **Visible by default:** Yes ### Description The **Description** column displays the product description. **Format:** Text | **Editable:** No (display only) | **Visible by default:** Yes ### Pref. Supp The **Pref. Supp** column displays the preferred supplier code for the product. **Format:** Text | **Editable:** No (display only) | **Visible by default:** No ### Prod Grp The **Prod Grp** column displays the product group code. **Format:** Text | **Editable:** No (display only) | **Visible by default:** Yes ### Prod Sub1 The **Prod Sub1** column displays the product subgroup 1 code. **Format:** Text | **Editable:** No (display only) | **Visible by default:** Yes ### Prod Sub2 The **Prod Sub2** column displays the product subgroup 2 code. **Format:** Text | **Editable:** No (display only) | **Visible by default:** Yes ### Prod Sub3 The **Prod Sub3** column displays the product subgroup 3 code. **Format:** Text | **Editable:** No (display only) | **Visible by default:** Yes ### Old Base Cost The **Old Base Cost** column displays the current base cost of the product before components of cost are added. The base cost is the product cost derived from the assigned costing method. **Format:** Currency (four decimal places) | **Editable:** No (display only) | **Visible by default:** No ### Old Cost Component The **Old Cost Component** column displays the current total components of cost value applied to the product. **Format:** Currency (four decimal places) | **Editable:** No (display only) | **Visible by default:** No ### Old Cost The **Old Cost** column displays the current landed cost of the product (base cost plus components of cost). **Format:** Currency (four decimal places) | **Editable:** No (display only) | **Visible by default:** Yes ### Loading % or $ The **Loading % or $** column displays whether the cost loading is calculated as a percentage or a dollar value. **Format:** Text (% or $) | **Editable:** No (display only) | **Visible by default:** No ### Old Cost Loading The **Old Cost Loading** column displays the current cost loading amount applied to the product. **Format:** Currency (four decimal places) | **Editable:** No (display only) | **Visible by default:** No ### Old Resultant Cost The **Old Resultant Cost** column displays the current resultant cost after cost loading is applied. **Format:** Currency (four decimal places) | **Editable:** No (display only) | **Visible by default:** No ### Old Sell The **Old Sell** column displays the current sell price of the product excluding GST. **Format:** Currency (four decimal places) | **Editable:** No (display only) | **Visible by default:** Yes ### Old Sell Gst Inc The **Old Sell Gst Inc** column displays the current sell price of the product including GST. **Format:** Currency (four decimal places) | **Editable:** No (display only) | **Visible by default:** Yes ### Old GP% The **Old GP%** column displays the current gross profit percentage for the product. **Format:** Numeric (four decimal places) | **Editable:** No (display only) | **Visible by default:** Yes ### New Base Cost The **New Base Cost** column displays the new base cost that will be applied when the future pricing takes effect. The new base cost is derived from the new cost minus the new cost component total. **Format:** Currency (four decimal places) | **Editable:** No (display only) | **Visible by default:** Yes ### New Cost The **New Cost** column displays the new landed cost to be applied from the effective date. Updating the **New Cost** value automatically recalculates the **New Sell**, **New Sell Gst Inc**, **New GP%** and difference columns. **Format:** Currency (four decimal places) | **Editable:** Yes | **Visible by default:** Yes ### Wastage % The **Wastage %** column displays the wastage percentage applied to the product. This field is only visible when the **InvCstWst** system flag is enabled. **Format:** Numeric (two decimal places) | **Editable:** No (display only) | **Visible by default:** No ### New Cost Loading The **New Cost Loading** column displays the new cost loading amount that will be applied. **Format:** Currency (four decimal places) | **Editable:** No (display only) | **Visible by default:** No ### New Sell The **New Sell** column displays the new sell price excluding GST to be applied from the effective date. Updating the **New Sell** value automatically recalculates the **New Sell Gst Inc**, **New GP%** and difference columns. **Format:** Currency (four decimal places) | **Editable:** Yes | **Visible by default:** Yes ### New Sell Gst Inc The **New Sell Gst Inc** column displays the new sell price including GST to be applied from the effective date. Updating the **New Sell Gst Inc** value automatically recalculates the **New Sell**, **New GP%** and difference columns. **Format:** Currency (four decimal places) | **Editable:** Yes | **Visible by default:** Yes ### New Resultant Base Cost The **New Resultant Base Cost** column displays the calculated resultant base cost after future pricing changes are applied. **Format:** Currency (four decimal places) | **Editable:** No (display only) | **Visible by default:** No ### New Cost Component The **New Cost Component** column displays the new total components of cost value that will apply to the product after the future pricing takes effect. **Format:** Currency (four decimal places) | **Editable:** No (display only) | **Visible by default:** No ### Nett Cost The **Nett Cost** column displays the nett cost of the product after rebates are applied. **Format:** Currency (four decimal places) | **Editable:** No (display only) | **Visible by default:** Yes ### New Resultant Sell The **New Resultant Sell** column displays the calculated resultant sell price excluding GST after future pricing changes are applied. The **New Resultant Sell** value takes into account the new cost, cost loading and GP% to show the final sell price that will be in effect. **Format:** Currency (four decimal places) | **Editable:** No (calculated) | **Visible by default:** No ### New Resultant Sell Gst Inc The **New Resultant Sell Gst Inc** column displays the calculated resultant sell price including GST after future pricing changes are applied. **Format:** Currency (four decimal places) | **Editable:** No (calculated) | **Visible by default:** No ### New GP% The **New GP%** column displays the new gross profit percentage that will result from the future pricing changes. Updating the **New GP%** value automatically recalculates the **New Sell**, **New Sell Gst Inc** and difference columns. **Format:** Numeric (four decimal places) | **Editable:** Yes | **Visible by default:** Yes ### Cost Diff% The **Cost Diff%** column displays the percentage difference between the old cost and the new cost. **Format:** Numeric (three decimal places) | **Editable:** No (calculated) | **Visible by default:** Yes ### Sell Gst Inc Diff% The **Sell Gst Inc Diff%** column displays the percentage difference between the old sell price (GST inclusive) and the new sell price (GST inclusive). **Format:** Numeric (four decimal places) | **Editable:** No (calculated) | **Visible by default:** Yes ### GP Diff% The **GP Diff%** column displays the difference between the old GP% and the new GP%. **Format:** Numeric (three decimal places) | **Editable:** No (calculated) | **Visible by default:** Yes ### Effective Date Text The **Effective Date Text** column displays the effective date as text for the future pricing entry. **Format:** Date (DD/MM/YY) | **Editable:** No (display only) | **Visible by default:** Yes ### Delete Icon The delete icon at the end of each product row removes the future pricing entry for the product. Clicking the delete icon removes the product from the future pricing review for the selected effective date. **Action:** Click the delete icon to remove the product's future pricing entry. --- ## Actions Menu The **Actions** menu provides additional options for managing future pricing. ### Generate Labels The **Generate Labels** option creates a batch of shelf labels for the products in the selected effective date. The generated label batch can then be printed from the **Label Batches** screen. **Action:** Click **Actions** and select **Generate Labels** to create a label batch for the selected effective date. > ✅ Refer to [Printing Future Price Labels](https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/30524350) for more information. --- ## Command Buttons ### Save The **Save** button commits all changes made to the future pricing values in the **Future Price Grid**. **Action:** Click **Save** to save changes. ### Cancel The **Cancel** button discards any unsaved changes to the future pricing values and reverts the grid to the last saved state. **Action:** Click **Cancel** to discard unsaved changes. ### Close The **Close** button closes the **Future Price Review** screen. **Action:** Click **Close** to close the screen. --- > ✅ ## Related Information > ✅ > ✅ - [Review Future Prices](https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/30524140) > ✅ - [Future Pricing - Setup and Configuration](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28409480) > ✅ - [Apply Product Future Pricing](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28402874) > ✅ - [Product Maintenance](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28378114) (Future Standard Pricing and Future Branch Pricing sections)