Stock Setup
Module Overview:
There are several areas of setup to consider when implementing the Stock module:
Grid Management:
You will need to ensure that certain fields are available for purchasers to use for ordering stock. Navigate to Grid Management and unhide the Line Code field under Purchase Order Detail, Voucher Detail, and Voucher PO Line List.
Control Parameters:
Stock
ParameterName | Description | ValidValues |
|---|---|---|
Non Stock Job Type | The Job Type Code used to designate Non Stock Jobs (Non Stock Locations). | <JobTypeCode> |
*Stock Cost Method | Determines the Cost method used for stock issues, stock valuations and quoting. | Standard, Average, Last, Period Average |
Stock Job Type | The Job Type Code used to designate Stock jobs. It must be specified if stock is being used. | {Job Type Code} |
Allow Negative Qty Stock | If set to Yes, then will allow quantity for a Stocked stock item to be issued even if the resulting quantity will be negative. |
|
Stock Purchase Clearing Activity | The activity code used for posting to the Stock Purchase Clearing account in the GL. | <ActivityCode> |
Stock Purchase Variance Activity | The activity code used for posting to the Stock Purchase Variance account in the GL. | <ActivityCode> |
Stock Costing Methods:
Average: The Stock Average Cost calculation includes value and quantity of stock issues, returns, inwards goods, adjustments and transfers. Each Cost rate by location is dynamically recalculated as each stock receipt is processed which results in a moving average cost during the period.
Period Average: This method determines the average cost to use for the Item at that Location for the period. The Period Average cost for the item at the location is determined at Stock Close Out, and then the value is applied to subsequent stock transactions in the following period. This is simpler to validate than the 'Average' stock costing and provides a more stable cost that is simpler to reconcile to all transactions within the period. For a new item to a location, the unit cost rate of the initial PO receipt will be used as the period average for that item. Where there is no receipt yet, and negative Stock issues are allowed, the Cost Rate entered on the Location will be used, until there is a PO receipt processed.
Last: This method uses the Cost rate on the last PO receipt for each stock location.
Standard: This method uses the Cost Rate for each location that is manually entered when the Item is created on each Location. The disadvantage of this method is that Cost Rates must be updated manually if costs change.
Purchasing
ParameterName | Description | ValidValues |
|---|---|---|
Auto receipt with APInvoce | if set to Yes, Auto Create Inwards Lines, if No, only Create Inwards Lines if JobCode = StockJobCode. This is only supported with the Legacy Stock option. |
|
Receipt more than To Receipt | if set to Yes, Procurement may accept a Receipt amount larger than what is required to Receipt | Yes, No |
Quoting
ParameterName | Description | ValidValues |
|---|---|---|
Quote Non Stock Cost Method | Determines which unit cost rate is used when quoting non-stock items. | Standard, Last |
The following child pages will need to be set up prior to using the Stock module:
Child Pages: