Previous icon

Next icon

Item Maintenance - Stock tab

Use the Stock tab to:

Stock is stored separately for each business unit.

Opening the Stock tab

Item Maintenance - Stock tab key fields and buttons

Fields

Field

Description

Business Unit

Select the business unit at your organisation, to maintain the stock details for the item for the selected business unit.

If there is no stock record for the selected business unit, the following message is displayed:

No stock at this business unit (cut down)

Click Create stock for this business unit button to create stock for this item at the business unit. See Creating stock items for business units.

Active Stock

Select to indicate that the item is a current stock item.

To clear the field, click Set Inactive button. Inactive items are not displayed on the Stock Item Search window and are no longer available for sale.

Stock On Hand

Quantity of stock on hand at the business unit.

Average Cost (Ex Tax)

Average purchase cost of the item, (excluding tax) used to determine the profit made on each item and create cost of sale journals.

This is calculated by Synergetic using a weighted average cost. Specifically, each time you purchase stock the average cost is adjusted based on the:

  • weighted difference between the average cost of items already in stock
  • unit cost of the items being purchased.

 

Note: You can override the value in this field by clicking Adjust button. This creates an adjustment receipt for zero units to record the change.

Override Sale G/L Code

When a sale is made, by default it is posted to a specified G/L control account. If you want to use a different G/L account for this item, select a different one using this field.

Tax Code

Tax code used for the item, which is used for tax reporting on sales.

Re-Order Quantity

Reference figure used to nominate the amount of stock reordered, when the stock level falls below the Re-Order Stock Level value.

The quantity that you reorder is similar to the economic order quantity, the most economical amount to purchase from the supplier. For example, you may order uniforms in quantities of 100 as the supplier may have a cheaper wholesale unit price, if you have the funds and the storage capacity.

Re-Order Stock Level

Reference figure used to nominate the stock level below which you need to reorder more stock. This is used for re-order reports.

Grid area fields

Field

Description

Price Group

No.

Number for the price group.

 

Desc

Description for the price group.

 

GL

Selected if the price group is for internal general ledger sales only.

 

Tax Code

Tax code for the price group.

 

Method

Pricing or profit method for the price group.

Threshold Min

Unit Price

Minimum unit price for the item. This field is highlighted if the actual unit price is below this amount.

 

Profit

Minimum profit for the item. This field is highlighted if the actual profit is below this amount.

Threshold Max

Unit Price

Maximum unit price for the item. This field is highlighted if the actual unit price is above this amount.

 

Profit

Maximum profit for the item. This field is highlighted if the actual profit is above this amount.

Policy

Description

Whether the discount policy for the price group uses:

  • Default - the default price group pricing
  • Cost - the average cost of the item
  • Manual - a manual price set in Item Maintenance.

See Synergetic Financial Configuration - Business Units - Price Groups sub-tab in the Finance manual.

 

Discount

Discount applied for this price group.

Note: Negative values create a surcharge. For example, -10 applies a 10% surcharge,

Editable

Apply

Select to apply this price group policy for this item.

 

Unit Price

Price to charge the student or debtor for each item sold. This field is editable.

Note: This can be inclusive or exclusive of tax, depending on the finance configuration settings for the price group. See Synergetic Financial Configuration - Business Units tab in the Finance manual.

Actual

Ex Tax

Price excluding tax.

 

Inc Tax

Price including tax.

 

Profit

Actual profit for the item.

Buttons

Button

Description

Receive Stock button

Receive stock into a business unit. See Manually receipting stock.

Adjust button

Unprotect the Average Cost field, so that you can type in a new value.

Note: Also see the Update button button, as the buttons toggle depending on whether the field is protected or not.

Update button

Protect the Average Cost field after adjusting their values.

Note: Also see the Adjust button button, as the buttons toggle depending on whether the field is protected or not.

Launch button

Depending on the location of the button, launch into either:

Place Order... button (Place Order ellipses)

Launch the Stock Summary window to create a purchase order for this item. See Stock Summary - Suppliers for Stock tab.

Print Labels (immediate)... (ellipses) button

Launch the Print Labels window to print barcode labels immediately.

Print Labels window

Print Labels (to queue)... button (Print labels (to queue) ellipses)

Add labels for this item to the label print queue. The number of labels to print defaults to the Stock On Hand.

Note: You can print the label queue in the Page 4 sub-tab of the Sales sub-tab of the Business Units tab of Finance Configuration Maintenance. See Synergetic Financial Configuration - Business Units - Sales sub-tab - Page 4 sub-tab in the Finance manual.

Delete Stock Record button

Delete the stock record for the selected business unit.

Note: A stock record can only be deleted if the item has a zero stock balance.

Alternatively, a stock item can be set to inactive; that is, logically deleted. See Set Inactive button below.

Set Inactive button

Set the stock item to inactive.

Any inactive stock items are excluded from being available on the Sales Entry window. See Selecting stock items for sale. For example, there may have been a change to the uniform and any remaining stock of the old uniform is set to inactive so that it is no longer available for sale.

You can set an item to inactive even if Synergetic is showing that stock on hand is positive.

Item Maintenance - Stock tab (highlighted positive Stock On Hand field)

If this is the case, the following dialog is displayed:

Information - Item set to inactive but still contains stock

Also, any stock items can be searched based on whether they are active or not. See Searching for items.

Set Active button

Set the stock item to active so that it is available for sale.

Create stock for this business unit button

Create stock for this item at the business unit. See Creating stock items for business units.

This button only appears when you select a business unit that has no stock record for this item.

No stock at this business unit (cut down)

Last modified: 9/10/2013 3:18:26 PM

See Also

Maintaining items

Searching for items

Creating new items

Item Maintenance - Item tab

Item Maintenance - Suppliers tab

Item Maintenance - Receipts tab

Item Maintenance - Stock at Business Units tab

Item Maintenance - Payment tab

Item Maintenance - Sales tab

Item Maintenance - Purchase Orders tab

Item Maintenance - User Forms tab

Item Maintenance - DocMan tab

Item Maintenance - Stock Movement tab

© 2013 Synergetic Management Systems. Published 15 October 2013.

Top of page