---
title: "Product Wastage Utility"
canonical: "https://kb.myframeworks.com.au/space/PROSTIXV48DOC/31097567/Product%20Wastage%20Utility"
format: markdown
---
> ℹ️ The** Product Wastage utility** imports product level wastage percentage values. These are used to add a wastage percentage to the product standard cost. The utility is in V:\prodev\fixits\v4\porters\cusu32279.p
> ℹ️ 
> ℹ️ - The Input File must use format: Column A = Product ID, Product B = Wastage %
> ℹ️ 
> ℹ️ Example data below (speech marks not required on product ID):
> ℹ️ 
> ℹ️ ![image](media://90f5e824-3dbf-4ae1-b609-f2a894599487)
> ℹ️ 
> ℹ️ - In the screenshot examples below, once the utility has been ran, the two products below update their Std Cost & G.P%.
> ℹ️ 
> ℹ️  > Macro (inline-media-image)
> ℹ️ 
> ℹ️ > Macro (inline-media-image)
> ℹ️ 
> ℹ️ '
> ℹ️ 
> ℹ️ 
> ℹ️ ## <span style="color: #003366">Importing product level wastage percentage values</span>
> ℹ️ 
> ℹ️ To import product level wastage percentage values. perform the following:
> ℹ️ 
> ℹ️ 1. Turn on system flag **InvCstWst**, otherwise the error message below appears: 
> ℹ️ 
> ℹ️ ![image](media://fac4b5a8-f95a-485a-95f8-78a6c26c1e2d)
> ℹ️ 
> ℹ️ 2. Add the products to the .csv import file that require a wastage percentage added to the product standard cost. Column A = Product ID, Column B = Wastage % required.
> ℹ️ 
> ℹ️ 3. Save the filename.csv into the *prostix/dmp *directory.
> ℹ️ 
> ℹ️ 4. Run the import utility via options A,5,6 in Prostix (cusu32279.p). Refer to [Run a Program](https://sterlandsupport.atlassian.net/wiki/spaces/PROSTIXV48DOC/pages/31097929) for further information.
> ℹ️ 
> ℹ️ ![image](media://afaa3a95-2851-439b-b3a1-d1ec0e57d199)
> ℹ️ 
> ℹ️ 5. Type the appropriate Input file path and name:
> ℹ️ 
> ℹ️ ![image](media://f7be6ba7-bf10-44d9-a9e9-b77f6fa7ca35)
> ℹ️ 
> ℹ️ 6. Review the audit report to confirm the new wastage value % has been added or updated and that there have been no import errors: 
> ℹ️ 
> ℹ️ *Screenshot of a Utility notification indicating some errors:*
> ℹ️ 
> ℹ️ ![image](media://f2119a16-d3f6-4ab1-8615-60d550c2e747)
> ℹ️ 
> ℹ️ *Screenshot of an Audit Log/Error report:*
> ℹ️ 
> ℹ️ ![image](media://85cc47be-8eef-4147-a3b7-0c637913d058)
> ℹ️ 
> ℹ️ 7. Ensure the Sell price does not change, the GP simply recalculates.
> ℹ️ 
> ℹ️ *Screenshot of product “00840545” before Costing Values and after Costing Values:*
> ℹ️ 
> ℹ️ > Macro (inline-media-image)
> ℹ️ 
> ℹ️ > Macro (inline-media-image)
> ℹ️ 
> ℹ️ 
> ℹ️ 
> ℹ️ > Macro (legacy-content)
> ℹ️ 
> ℹ️ *Screenshot of product “29682968” before Costing Values and after Costing Values:*
> ℹ️ 
> ℹ️ > Macro (inline-media-image)
> ℹ️ 
> ℹ️ > Macro (inline-media-image)
> ℹ️ 
> ℹ️ 
> ℹ️ 
> ℹ️ > Macro (legacy-content)