Inventory Location
The Inventory Location file defines inventory items and theirΒ specific attributes for a selected site. Attributes in the Item Location override any settings in the Item Master. An Item Master record must be created before an Item Location Record can be created
Process Steps
- Enter or Edit Inventory Master
- Create Item Sites. Gravity->System Setup->Inventory->Site
- If the "Add New Items to Default Site" is set to yes, new items added will be also added to the default site in the Inventory Location table.
Fields
Item Number
The Item Number is established in the Item Master. Select an Item Number to add or edit
Name
The Item Name is established as part of the Item Master. It is used as a reference for the item.
Site
Select the Site for the item you are editing. An Item Number and Site combination must be unique.
Purchase Description
This is a description to appear on purchasing documents. By default, it is the same as the Item Name.
Unit of Measure
Define a stocking unit of measure.
See UOMο»Ώ
Allow Back Orders
Not used at this time.
Primary Vendor
Not used at this time.
Average Lead Time
Not used at this time.
Reorder Quantity
Not used at this time.
Status
Not used at this time.
List Price
The List Price is defaulted from the Item Master. It can be changed for each site
If no pricing matrix is present, this will be the default price in invoicing.
See Item Pricingο»Ώ
Current Cost
This field is maintained by Gravity. It represents the last purchased price for an item at the selected site.
Weighted Average Cost
This field is maintained by Gravity. It represents the weighted average price for an item at the selected site. The weighted average price will still be maintained even if the costing method is set to another type.
Standard Cost
This field is only applicable to items where the costing method is set to Standard.
The Standard Cost is defaulted from the Item Master. It can be changed for each site.
Once created on a new item it can only be changed by selecting the "Change Standard Cost" from the Action Menu.
Revenue Account
Select the default revenue account for the item.
The List Price is defaulted from the Item Master. It can be changed for each site
The revenue account can be changed on each invoice line item.
Expense Account
Select the default expense account for the item.
The List Price is defaulted from the Item Master. It can be changed for each site
The expense account can be changed on each invoice line item.
Offset Account
Select the default offset account for the item.
The List Price is defaulted from the Item Master. It can be changed for each site
The offset account is used for items with standard costing to charge purchase price variances.
Inventory Account
Selecting an Inventory Account for will override the Account setup in the Entity Configuration.
Last Physical Count Date
Not used at this time
Item Quantities
These fields are maintained by Gravity and represent the summation of respective transactions for the selected item/site.
ο»Ώ