---
title: "EPC Apply - Stock Update Parameters"
canonical: "https://kb.myframeworks.com.au/space/FRAM/28402894/EPC%20Apply%20-%20Stock%20Update%20Parameters"
format: markdown
---
# Overview
The **EPC Apply** screen allows you to apply a suppliers imported EPC file into Frameworks.
# Accessing the EPC Apply View Screen
1. Click **Frameworks **then navigate to **Inventory** > **Electronic Price Catalogue** > **EPC Dashboard** from the navigation tree.
2. Click **Find **to return a list of all supplier EPCs or refine your search with the available fields.
> ✅ Refer to [EPC Dashboard ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28409332)for more information.
3. Click the hyperlink of desired EPC import or click **New **to [Create a New Supplier EPC Import](https://sterlandsupport.atlassian.net/wiki/spaces/fwksproau/pages/30509660).
4. Click **Actions **and select **Apply** from the action's menu.
# Navigating the EPC Apply View Screen
The **EPC Apply View **screen has 3 main sections:
1. **EPC Stock Update**
2. **EPC Stock Load Parameters**
3. **Update Product Details**
## 1. EPC Stock Update
Located on the left side of the **EPC Apply View **screen are the **EPC Stock Update **options. These options determine what products are updated and what should occur in certain circumstances, for example, a duplicate product.
To learn more about the EPC Stock Update parameters, click here.
**Supplier**
Displays the **Supplied Code** for the supplier that the EPC file is being applied to.
> ℹ️ The **Supplier **field is set when first importing or creating the EPC and is greyed out and cannot be changed.
---
**Branch**
Displays the selected branch. If not defined, **All Branches** will be displayed.
---
**Supplier Effective Date**
Displays the date when the supplier's information or agreement becomes valid or active.
---
**Save choices to default**
Enable to save the parameter choices from this EPC Apply, for this supplier, for future EPC imports.
---
**Mass Load to Stock **
Enable to mass load the products, within the ranges defined in the EPC Stock Update section, to the stock record from the EPC. Disabled to update existing product information, if the product already exist in the Stock record.
During the mass loading of a range of products to stock from the EPC, a series of checks are performed within Frameworks to detect whether the products already exist. Even if you enable **Generate Product Codes** to allocate the Product Codes, the load checks for duplicate EPC product codes, bar codes and catalogue numbers.
> ⚠️ Warning messages are not given, however, an exception report is produced if some products are not added to the stock records.
> ℹ️ When enabled you will NOT have the option run a **Comparison Report Only. **
---
**Move to Original Supplier **
Enable to move the products to the original supplier as part of the stock update.
- The EPC file will be imported for the supplier mapped as 'Supplier' in the import format.
- The products will be moved to the supplier mapped as 'Original Supplier' in the import format.
- If the product does not have an 'Original Supplier' mapped it will retain the EPC supplier.
> ⚠️ Only available when **Mass Load to Stock **is enabled.
---
**Create Supplier**
Enable to create this supplier as an alternate supplier if product already exists in the stock records.
---
**Preferred Supplier**
Enable if you want to set the supplier as the preferred supplier. If a product already exists with a preferred supplier, this existing preferred supplier will become an alternate supplier for the product.
---
**Comparison Report Only**
Enable to run a report of potential changes only, without loading the EPC to stock.
> ℹ️ If **Mass Load to Stock** is enabled this option is NOT available.
> ✅ Refer to the **Comparison Report Only** parameter below for more information.
---
**Detail Report**
Enable to run a detailed report of the potential changes, without loading EPC to stock.
> ⚠️ Only available when **Comparison Report Only **is enabled.
---
**From **and** To Supplier Product **range
Enter a range of supplier product numbers, from the EPC File, to update the stock record from. Leave blank to use the full range.
> ℹ️ **Match Search by **and the **Use Hierarchy **EPC Stock Load Parameters will still effect which products are loaded.
---
**Supplier Product Group **
Enter the supplier product group of the products you want to load into stock. The Supplier Product Group is displayed, when editing the EPC files product line as the **Product Group **field.
> ℹ️ This is the **Product Group **field in the EPC file import.
---
**Fine Line Class **
Enter supplier Fine Line Class (Sub Group 1 in the EPC file import) to load, if applicable.
---
**Set Product Group to **
This value determines the Frameworks product group value that will be used as an over-ride value when performing a mass stock load, i.e. all products loaded will have this product group coding and not the Supplier Product Group from the EPC Import.
> ⚠️ Not applicable if **Mass Load to Stock** is disabled and products are being updated.
---
**Select Product Group to Update**
Enable the checkbox to enable the option to select product groups to include in the update.
---
**Product Groups**
Enter the product group, within Frameworks, you are requiring to update. Use the **Search icon** to open the **Product Group Finder **window.
> ℹ️ Only available when **Select Product Group to Update** is enabled.
> ℹ️ This is the Frameworks product group that the matched products will be applied to.
---
**Generate Product Codes **
Enable to automatically generate Frameworks product codes when adding new products to your stock record and NOT using the product codes withing the EPC file.
---
**Stock Source **
Enable to filter products to be added by their **Stock Source**. This is where the supplier is sourcing the product from.
You can enter one of the following:
- **Leave BLANK**:
- **W:** If the stock source is defined as Warehouse.
- **D:** If the stock source is defined as Direct.
- **N:** If the stock source is defined as NDC (National Distribution Centre).
> ℹ️ **Warehouse** and** Direct **are typically used when your business is part of a Buying Group.
> ✅ Refer to the **Product Suppliers Details tab **in [Product Maintenance ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28378114) for more information.
---
**Original Supplier**
Enabled to filter products to be added by their original supplier.
---
**Include Special**
Include any special products in the EPC update. *If the epc record matches a special product in the product filed, these products will only be updated if this is enabled. *
---
## 2. EPC Stock Load Parameters
Located in the middle of the **EPC Apply View **screen are the **EPC Stock Load Parameters **options. These parameters determine when to update, where to update the data and how the data will be matched.
To learn more about the EPC Stock Load Parameters, click here.
**Effective Date **
Enter the date or used the date chooser to set the effective date for future pricing. Setting this future date will apply cost and sell changes to the **Master** (Standard) and **Branch** pricing. A date other than today will require you to Apply Future Pricing before the new prices will take effect.
> ℹ️ The **Effective Date** only applies when you are NOT performing a **Mass Load to Stock **(checkbox is disabled).
> ❌ **Warning:** Only Cost & Price Updates apply to Future. All other updates will be immediate.
All other selected updates will apply immediately regardless of date chosen. Keying a future date will allow you to print labels from Future Pricing but this must be done BEFORE you apply this future pricing.
> ✅ Refer to [Apply Product Future Pricing ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28402874)for more informaion.
---
**Branch to Update**
Select a Branch from the drop-down you want to apply the EPC Stock Updates to. Leave blank to update all branches.
---
**Add Branch Recs**
Enable to create Branch Stock records for the product for the selected **Branch to Update **option.
- If **Mass Load to Stock **is enabled then branch stock records for products being added will be created.
- If **Mass Load to Stock **is disabled and a branch stock record does not exist (that is, the product was not previously stocked in the selected branch), the Frameworks will create a branch stock record before applying changes.
---
**Match Search by**
Match products in the search by one of the following options; **Product, Barcode, Supplier Barcode, Supplier SKU, Product/Barcode **or **GTIN.**
---
**Use Hierarchy**
If enabled, where no immediate match is found using the standard match search by criteria, it will continue to search the product data for other data matches.
The Match Hierarchy is as followings:
1. Product Code
2. Product Barcode
3. Supplier Barcode
4. Supplier SKU
5. GTIN.
6. Catalog number and Alternate codes.
---
## Comparison Report Only Parameter
> ⚠️ If you choose to run a comparison report only of the potential changes to the Product file, simply enable the **Comparison Report Only** parameter. When enabled, you will be presented with a new set of parameters and the parameters on the far right will disappear.
To learn more about the new parameters, click here.
**Report No EPC for Stocked Products**
Enable to include stocked products not on the EPC on the report.
---
**Use EPC Sell**
Enable to display EPC product sell prices.
---
**EPC Sell GST Inc**
Enable to include items' sell price, GST included.
---
**GST Inc on Report**
Enable to display GST Inclusive pricing on the report.
---
**Preferred Only**
Enable to include only preferred items.
---
**Email To**
Enter an email address if you wish to email the report to a user.
---
## 3. Update Product Details
Located on the right side of the **EPC Apply View **screen are the **Update Product Details **options. These parameters determine what product information, from the EPC file (as defined withing the **EPC Maintenance Details - Edit **window), to update in Frameworks. Depending on the type of information, various product data can be updated with in the [Product Maintenance ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28378114) screen. These area's are:
- **Master:** When enabled data is typically updated under the **Key Details** and **General Information **sections.
- **Branch:** When enabled data is typically updated under the **Product Branch Stock **and **Pricing **sections.
- **Area:** When enabled data is typically updated under the **Product Suppliers, Prices tab** the branches defined** Area.**
- **Supplier:** When enabled data is typically updated under the **Product Suppliers **and **Supplier GTINs **sections.
To learn more about the Update Product Details criteria, click here.
**Update Costs **
Enable to update product unit costs.
> ℹ️ If more than one checkbox is enabled the hierarchy in which the pricing is updated is the same as the order below.
- **Master: **Enable to update the **Standard Cost** and **Landed Cost**, with the EPC cost. If the **GP Retain** checkboxes on a product are disabled, this will update the **GP **otherwise the **Standard (Unit) Sell** will be updated. The **UOM conversion factor**, **Previous Cost** and **Tax** values are also updated.
- **Branch: **Enable to updated the **Product Branch Pricing **of **Unit Cost**, with the EPC cost, for the selected **Branch to Update. **
- **Area: ** Enable to updated the **Supplier Area/s Gross Cost**, under the Product Suppliers Prices, with the EPC cost, based on the which area the selected branch is linked to.
- **Supplier: **Enable to update the **Supplier Gross Cost, **under the Product Suppliers Standard Prices, with the EPC cost.
- If the **Reset Standard Cost** is enabled, this cost will flow through to products standard costs.
- If the **Reset Branch Cost** is enabled, this cost will flow through to branch costs.
---
**Cost - Tax Inclusive**
Enable if the cost on the EPC file is Tax Inclusive.
- **Master: **Enable to update the** Standard Cost**, in the key details section. If the EPC import included a Tax rate, Frameworks validates this tax rate or the one that already exists on the product record with those defined in the Percentages Table and reduce the cost accordingly.
---
**Update Sell Price**
Enable to update the sell price.
- **Master: **Enable to update the **Standard (Unit) Sell** price directly from the EPC file either by way of the EPC GP% and by the EPC unit sell price.
> ℹ️ Updating the sell directly will update the GP%. Please note that when the sell prices are changed via the EPC, this price change will not take effect if the appropriate **Retain GP** checkbox is enabled.
- **Branch: **Enable to update the **Product Branch Pricing **of **Unit Sell**, with the EPC Unit Sell price, for the selected **Branch to Update. **
- **Area: **Enable to updated the **Supplier Area/s Gross Cost**, under the Product Suppliers Prices, with the EPC Unit Sell price, based on the which area the selected branch is linked to.
---
**Sell - Tax Inclusive**
Enable if the recommended sell price in the EPC file is Tax Inclusive.
- **Master: **Enable to update the** Unit Sell** and **Unit Sell GST Inc**, in the key details section. Frameworks will validate the tax rate with those defined in the Percentages Table and reduce the sell accordingly.
---
**Only if Preferred **
Enable to update **Standard Cost** and **Unit Sell** ONLY if a Preferred Supplier.
- **Master:** If the Supplier being updated is the preferred supplier for the product, the **Standard Cost** and **Unit Sell **prices will be updated.
> ℹ️ - If this Supplier is the Alternate Supplier, the standard cost will not be affected.
> ℹ️ - If disabled, the nominated costs and sells are updated even if this supplier is the alternate supplier of a product.
---
**Apply Markup % to RRP**
Enter a markup % on the supplier's suggested sell price to apply, if applicable.
- **Master: **Enter a percentage markup amount to be applied to the Standard (Unit) Sell price. The **Update Sell Price - Master** checkbox must be enabled.
- **Branch:** Enter a percentage markup amount to be applied to the Branch Unit Sell price. The **Update Sell Price - Branch **checkbox must be enabled.
> ℹ️ **Update Sell Price Area** MUST be unticked.
---
**Update Prod/Bar Code**
Enable to update product and barcode numbering.
- **Master: ** Enable to update product **Bar Code** value. Any existing values will be stored as an alternate code.
- **Supplier:** Enable to update the supplier **Bar Code** and **Catalogue Number** values.
---
**Update GTIN Codes**
Enable to update Supplier Global Trade numbering.
- **Supplier: **Enable to updated the selected **Product Suppliers GTINs.**
---
**Update Description**
Enable to update the product description.
- **Master: **Enable to up the **Product Description **under the key details section.
---
**Update Discounts**
Enable to update Supplier Discount, Supplier Volume Discounts, and Rebate values.
- **Master: **Not currently in use within Frameworks.
- **Supplier:** Updates the **Details**, **Prices** and **Volume Discounts** tabs in **Product Maintenance** > **Product Supplier**.
- **Details **Tab: Updates the **Discount % 1, Discount % 2, Discount % 3,** **Freight** and **Freight %** values.
- Freight is specified using either a cost value or a percentage.
- **Prices **Tab: If the above details are applied, the **Nett Cost** values is adjusted and displayed.
- **Volume Discounts** Tab: Updates the** Order Type**, **Quantity Break, Discount %, Discount $, **and** Unit Cost** values before calculating a new **Supplier Nett Cost**.
- Once the EPC is applied, it updates the supplier volume discounts with the latest information, replacing outdated discounts and removing any that are no longer in the EPC Dashboard from the master.
> ⚠️ The** Order Type **is hidden when the **FWPurchaseType** flag is disabled.
---
**Update Product Groups**
Enable to update the product group information.
- **Master: **Enable to update the **Product Group **and **Sub Group** classifications for the product. The values used will be translated using the [EPC Import Translator Maintenance ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28409542)tables if the EPC values are not valid.
> ⚠️ Option unavailable if **Mass Load to Stock **is enabled.
---
**Update Hazard Codings**
Enable to update the product hazardous goods codes.
- **Master:** Enable to update the product Hazchem and poison codes on the **Hazardous Goods **tab under the **Product Information **section on the** **[Product Dashboard ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28379182).
> ⚠️ Option unavailable if **Mass Load to Stock **is enabled.
---
**Update Source Codes**
Enable to update product sourcing information.
- **Branch: **Enable to update the **Product Branch Stock **fields of **Branch Supplier **and** Stock Source.** These values are essentially used for Buying Group operations, such as a large retailer.
- **Supplier: **Enable to update the **Product Supplier Details **fields of **Stock Source, Creditor **and **Original Supplier**
- If the Source field for a product is '**W**' (Warehouse), the **Original Supplier** field will be updated with the original supplier.
- If the Source is '**D**' (Direct), the **Original Supplier** becomes the Supplier and the EPC Supplier becomes the **Creditor** for the product.
> ⚠️ Option unavailable if **Mass Load to Stock **is enabled.
---
**Update Descriptive Data**
Enable to update the Product descriptive information.
- **Master: **Enable to choose to updated the following descriptive data for the product record.
- **Australia Made: **Enables the **Australia Made** checkbox under the **General Information** section.
- **Core Product:** Enables the **Core Product** checkbox under the **General Information** section.
- **Product Depth, Length **and **Width: **Updates the **Width, Depth** and **Length **fields under the **Timber/Sheet information **section.
- **Product Size: **Updated the product size.
- **Profile: **Updates the **Timber Profile** field under the **Timber / Sheet Information** section.
- **Timber Species: **Updates the **Timber Species** field under the **Timber / Sheet Information** section.
- **Stocking, Purchase** and** Reporting UOM: **Updates the details related to the **Stocking, Purchase** and** Reporting UOM **field under the **Units of Measure** section.
- **Branch: **Enable to update the following fields
- Label quantity
- Min and Max Reorder quantities (**Minimum** and **Maximum Stock**)
- Maximum stock hold value (**Threshold Days**)
- **Supplier: **The Pack Quantity fields** **will be updated for the supplier.
- Pack Size **(Inner Pack Qty**)
- Min order for the supplier (**Minimum Order**)
- Break Packs (**Can Break Pack**)
---
# Additional Information
> ✅ Refer to the [Applying an Imported EPC File](https://sterlandsupport.atlassian.net/wiki/spaces/fwksproau/pages/30530220) Operator Guide for more information
> ✅
> ✅ Refer to the [EPC Dashboard ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28409332)and [EPC Maintenance ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28402906)User Manual for more information about other EPC processes.