Item Maintenance - Stock tab

Use the Stock tab to:

  • maintain stock detail for business units that stock and sell items
  • receive stock purchased from a supplier or acquired as consignment stock
  • add or delete a stock record at a business unit
  • mark a stock as active or inactive at a business unit
  • manually adjust average costs.


Note: Stock is stored separately for each business unit.

 

 Opening the Stock tab

To open the Stock tab:

  1. Select Module > Sales > Item Maintenance from the main menu.
    The Set Item Search Criteria window is displayed.
    Tip: You can also access the Sales functions by clicking .
  2. Select the item. See Searching for items.
    The Item tab of the Item Maintenance window is displayed.
  3. Click the Stock tab.
    The Stock tab of the Item Maintenance window is displayed.
  4. Select the business unit you are maintaining stock details for.
    Note: You only need to select the business unit if stock is maintained in separate departments and you are authorised to work with multiple business units.


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:

Click 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 . 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 . 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:

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 into a business unit. See Manually receipting stock.

Unprotect the Average Cost field, so that you can type in a new value.
Note: Also see the button, as the buttons toggle depending on whether the field is protected or not.

Protect the Average Cost field after adjusting their values.
Note: Also see the button, as the buttons toggle depending on whether the field is protected or not.

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

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

Launch the Print Labels window to print barcode labels immediately.

Launch the Print Labels window to 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 queued labels by clicking  in the Item Selector window. See Printing queued labels.

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 below.

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.

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

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

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

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.