Stock Setup

Module Overview:

There are several areas of setup to consider when implementing the Stock module. See the exact steps for the initialisation of the Stock Items and their Cost rates and quantities on the Stock Module here

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

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 Recommended: 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

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

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:

Related Modules:

Purchasing

Import and initialise Stock Items

Migration of one Costing Method to Another

FAQs: