Product Warehouse Product Setup - Costs overview

Product > Setup > Warehouse Product

Use this page to review information that is updated automatically from several different sources as you build historical data from everyday operations.

Note:  Do not manually change this information. You can print all balance changes through product activity reports or the SA Balance Maintenance Report.

These functions update the balances, costs, and YTD fields:

  • KP Work Order Center Entry
  • Product Adjustment Entry
  • Product Unavailable Inventory Entry
  • Purchase Entry Receipt of Inventory
  • Purchase Entry RRAR Merge Process Report
  • Purchase Order Entry
  • Sales Entry Processing Back Order Fill Report
  • Sales Entry Processing Invoice Processing Report
  • Sales Entry Processing Pick Tickets Report
  • Sales Order Entry
  • Sales Shipping Feedback Entry
  • Transfer Entry
  • Transfer Entry Receipt of Inventory
  • Transfer Entry RRAR Merge Process Report
  • Transfer Exception Receipts Entry
  • Transfer Shipping Feedback Entry
  • Vendor Transaction Entry
Note: 

You cannot change the Average, Last, Replacement, or Standard costs if the Allow Changing GL Cost option in SA Operator Setup-Controls is set to No. This also applies to the addon cost if addons are included in the SM/GL cost.

The balance information applies to Product, Sales, Purchase, Transfer, and Kit Production. Options in SA Administration-Administrator Options-Products-Costs determine which costs to use in Sales Manager, General Ledger, Price/Discounting, Sales, and Transfer. Options in SA Administration-Administrator Options-Documents-Purchase Orders-Entry Defaults determine which cost to use in Purchase. The costs can differ between the modules.

All costs are contained on this record. Specify Yes in Allow Users To View Costs in SA Operator Setup-Controls to see the costs. In addition, specify Yes in Allow User To Change Master Balances in SA Operator Setup-Controls to determine if the balance fields are enterable.

Note: 
You can access the costs fields and specify a GL/SM cost when setting up a new product if one of these conditions is met:
  • The product is not a labor product.
  • The product has no quantity.
  • The product has no open transactions.

Storeroom

The Customer Costs and Customer Balances values pertain to customer-owned product in a Storeroom-managed warehouse. The Customer Costs show the Average, Last, and Fixed costs of a product. The Average and Last costs are automatically updated. You can specify a value for the Fixed cost. In Product Warehouse Description Setup, you can specify Average or Fixed in Cost Used for Customer Product when the product is issued in Storeroom.

The Customer Balances section shows these values:
  • On Hand: This reflects the quantity of customer-owned product before it is ordered and reserved. It is updated when the product is received and issued.

  • On Order: This field is updated for Permanent C products only when the Purchase Entry Customer Owned Purchase Report is run and reflects the recommended order quantity calculated by this report.

  • Unavailable: Inventory that is unavailable for sale because it has been received as unavailable with an Inspection reason. When it passes inspection, you release it in Storeroom Inventory Movement > Move to Available. This moves the Unavailable quantity to On Hand.

  • Received: This field is updated during Transfer Entry Receipt of Inventory when customer-owned stock is received. When Sales Entry Processing Back Order Fill Report is run after Transfer Entry Receipt of Inventory, the amount in this field is checked to determine these amounts:

    • What portion of a backorder to fill with net available customer-owned.
    • What portion to fill with net available distributor-owned.

These updates occur during Sales Entry Processing Back Order Fill Report:

  1. If filling a Sales order, and the Inventory Type on the line is customer, the backorder is filled with only available quantities that are customer-owned. If the line type is distributor, the backorder is filled with available distributor-owned quantities.
  2. If filling a Transfer line, and the shipping warehouse is not Storeroom-managed, the backordered stock is filled with available distributor-owned quantities only. If the shipping warehouse is Storeroom-managed, the backorder can be filled with customer-owned and distributor-owned.
  3. If filling a KP Work Order component in a Storeroom-managed warehouse, backordered components are filled using any available customer-owned first. Then backordered components are filled with available distributor-owned stock. If the warehouse is not Storeroom-managed, only distributor-owned stock is used.
  4. If filling a Purchase, Value Add, or Sales component, distributor-owned stock only is used.

The Customer Balances - Received quantity is reduced by the any customer-owned quantities that are used to fill backorders during Sales Entry Processing Back Order Fill Report. Any remaining amounts are not included in the average cost calculation.

Taxing

To enable taxing, you must perform several functions.

This Taxing section is one of those functions. Use this section specify tax information for each of the warehouse products you stock. This function provides additional flexibility, especially when warehouses are located in several tax localities.

Before specifying tax information in Product Warehouse Product Setup, ensure values are specified in these functions:

  • A Non Tax Reason in SA Table Code Value Setup.
  • Taxing in Product Warehouse Description Setup.
  • Tax exempt customers, states, products, or product lines in SA Tax Table Setup.
  • Tax jurisdictions for the appropriate tax group in SA Sales Use Taxes Setup or SA Goods and Services Taxes Setup.

The information displayed in the Taxing section is based on the Country value in SA Company Setup. The information on the Taxing view of Customer Setup or Customer Ship To Setup determines if tax is charged to and collected from a customer.