Product Warehouse Product Setup - New field descriptions

Fields are presented in alphabetical order.

Required

Product

The product can be numeric or alphabetic. An alphabetic product, or a combination, is generally more descriptive and more recognizable on reports and inquiries. If you are creating a new product, the new product cannot be a product previously set up as an Interchange type in Product Extended Product Cross Reference Setup. If that product is previously setup, then a message is displayed: Remove the Product Interchange (ICSEC) Before Adding the Product (ICSP) (6394)

When you set up a product, you can use these special characters in the name: !, ^, &, *, (, ), +, ", " ", and , (comma).

Note:  Some limitations exist when using quotation marks (") in a product name. You cannot create a product name that ends in a quotation mark; some text must follow. The quotation mark must not be preceded by an equal sign (=), nor immediately followed by a comma (,).

When a product is added or maintained, the product name remains in this field to show which product was last updated. It becomes the new global product. The global product is the last product that was updated or inquired anywhere within the system. After the product is entered, the lookup name defaults, based on the Lookup Name From option in SA Administration-Administrator Options-Products-Defaults .

Note:  If notes exist for this product, read the product notes before continuing.

If you maintain a product, or add a product to another warehouse, use the lookup for the Product field to search for existing product records.

Product Line

Specify the product line to tie this product to. Specify the product line in which the vendor places this product. The product line is used to group similar products together and is based on targets. For example, all types of electrical wire may be placed in one product line. The vendor might give discounts that are based on the product or the products line. Greater discounts are usually available if several products, in any combination, are ordered from a product line instead of ordering them individually.

Set up a default method in Product Line Setup-Order. When you specify the vendor and product line for a new warehouse product, the data on the Product Line Setup record that matches the vendor and product line updates the corresponding fields on the new record. This ensures that the initial data for any new warehouse product record that is associated with that product line is created with the same default data. This speeds up the creation of the record because you have less data to specify on a new record.

Vendor #

If a vendor authorized replenishment path is specified for this product, specify the vendor number. This should be the number of the vendor resupplying this product to your warehouse. The vendor number must exist in Vendor Setup. If the vendor is inactive, a warning message appears, but you are allowed to proceed. Update the status on the vendor record in that situation.

Warehouse

Specify the warehouse to assign this product to. The warehouse must be set up in Product Warehouse Description Setup.

Additional

Optionally, you can specify one or more of these costs. Whether you specify them when creating a new record may depend on related settings, such as in SA Administration-Administrator Options.

Average Cost

Specify a cost. Typically, specify this cost if you intend to use the average cost for General Ledger. The average cost is an on-going, perpetual weighted average cost for this product. This cost is recalculated every time the on hand quantity changes.

Last Cost

Specify a cost. This cost indicates the cost that this product was last purchased or received. This cost is updated in conjunction with the Authorized Replenishment Path (ARP), and by these functions: Product Unavailable Inventory Entry, Purchase Entry Receipt of Inventory, Vendor Invoice Center Entry-PO Costing, and Transfer Entry Receipt of Inventory.

Replacement Cost

Specify a cost. This cost is the amount your vendor would require to replace the product today. This cost is manually updated in this record or through these functions: PD Maintenance Entry, PD Administrator Price/Costs Update, and PD Administrator Future Price/Costs. It can also be updated automatically if you use Product Import.

Replacement Cost Date

Select a date. You might specify a date serve as the baseline date for this cost. This date is typically the date the Replacement Cost field was last changed.

Standard Cost

Specify a cost. This cost is user-defined. The standard cost could become the same as the replacement cost or not used at all. Each time the standard cost is changed, the date it was changed should be recorded as well. Changes to the standard cost can be made either directly or updated by PI Entry Update Products Report, PD Maintenance Entry, PD Administrator Price Costs Update, or PD Administrator Future Price/Costs.

Standard Cost Date

Select a date. You might specify a date serve as the baseline date for this cost. This date is typically the date the Standard Cost field was last changed.