About

Setting product expected costs is useful for tracking supplier cost changes.  Expected costs also speed up data entry for supplier invoices as the line cost will default to the expected cost when a product is entered in Reorder Stock and Receive Stock.  When items are invoiced in Stock, the cost of the item is checked against the expected cost for variance and reported on the Stock Received report.

 

Setting Product Expected Costs - Inventory Item

  1. From the Sysnet Toolbar click on the Stock icon
  2. By default the Inventory LIST screen will be displayed
  3. Search for or select an item from the LIST view and press the <DETAIL> tab to review the item details
  4. By default the <DETAILS> tab will be selected in the Inventory Detail screen  
  5. Enter the DEFAULT EXPECTED COST in either the outer or inner column as required
  6. Tick to save the changes

 

Setting Produce Expected Costs - Supplier Inventory Code

 

To override the default expected cost on a per-supplier basis:

  1. Select the <SUPPLIER INVCODES> tab from the Inventory DETAIL Screen  
  2. Click on the (+) button from the mini toolbar to add a new supplier product code
  3. Select the SUPPLIER NAME from the dropdown list
  4. Enter the product code into the SUPPLIER INVCODE field   
  5. Optionally, enter a DESCRIPTION for the product to match the supplier's description
  6. If the code is the default code for the product for the supplier, enable the DEFAULT CODE checkbox
  7. Enter the EXPECTED COST of the item
  8. Optionally, select the FACTOR for the item code
  9. Optionally, set the MIN ORDER QTY and ORDER MULTIPLE to indicate the minimum number allowed in a purchase order and the multiple quantity in an order respectively
  10. Tick to save the changes

 

Setting Expected Cost Trigger Percentage

Users can set a trigger percentage against stock groups to allow an acceptable variance in actual cost versus expected cost before the system will provide a warning.  When entering invoices if the line total entered differs from the expected by more than the accepted percentage, a warning prompt will appear to alert the user.

  1. From the Stock application click on the MAINTENANCE dropdown menu
  2. Select GROUPS then STOCK GROUPS
  3. Highlight the desired Stock Group and scroll across to find the invoicing section  
  4. Enter the desired percentage into the "Expected Cost Trigger %" column
  5. Tick to save when all percentages are entered