Grid Fields

Code

The unique code for the Stock Group. This cannot be edited once a Stock Group is created. Stock Group 0000 is the default Group code that is used to analyse products when the Stock Group is unspecified.

Stock Group Name

The name that will appear on reports and lookup controls.

Default UOM Code

(UOM Pending or Active)

The Default UOM Code for products in the Stock Group.

Inactive

You cannot post transactions for products associated with inactive Stock Groups. Check for products associated with the Stock Group and re-assign them before making a Stock Group inactive. To do this, filter on StockGroupCode in IC Product. If there are a number of products associated with the Stock Group, you can use a script to re-assign them. Inactive Stock Groups are shown in grey in the grid.

GL Stock on Hand

The account used for the Balance Sheet side of all IC Diminishing Stock Transaction and Revaluations regardless of Integration Basis.

For Perpetual Basis Integration

GL Cost of Sales

The account number of the Cost of Sales account in the GL, used for Issues (Sales), Credits, Kitset Usages and Job Usages.

GL Purchases

The account number of the Purchases account in the GL, used for Receipts, Transfers (Saturn only), Manufactures and Manufacture Usages, and for AP Shipment Invoice lines relating to diminishing Products.

GL Adjustments

The account number of the Stock Adjustments account in the GL, used for Adjustments due to posted stocktake variances and other adjustment transactions.

GL Write Offs

The account used for Adjustments due to write-offs from IN Credits.

GL Revaluation

The account number of the Stock Revaluation account in the GL, used for Revaluations.

GL Expense Recovery

The account number of the Expense recovery account in the GL, used in place of Stock On Hand account for Non-Diminishing Manufacture Usages, e.g. Labour Cost for a Manufacture, and for Non Diminishing Issues, Credits, Kitset Usages and Job Usages.

For Periodic Basis Integration

GL Closing Stock

The account number of the Closing Stock account in the trading account section of the GL. When you transfer to the GL, increases in the stock value will be credited to this account (a decrease in stock value would result in a debit).

GL Transfer Out

Used to create journal transactions, transferring the cost of products between Branches and Departments. When you transfer IC Transfer transactions to the GL, account for the Branch and Department associated with the location is debited with the value of the stock dispatched. (Accredo Saturn Only)

GL Transfer In

Used to create journal transactions, transferring the cost of products between Branches and Departments. When you transfer IC Transfer transactions to the GL, account for the Branch and Department associated with the location is credited with the value of the stock received. For example, if you purchase items from a central warehouse, then distribute them to a number of retail outlets, you can transfer the cost of the purchases to the retail outlet. Journal transactions are only created where the transfer in and transfer out accounts are specified for the Stock Group. (Accredo Saturn Only)

Grid Fields

Expand Toolbar (Alt+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Zoom

Access grid fields in Form view for each line on the grid. Groups can be entered or edited in the form or on the grid. To view more fields use the scroll buttons or resize the window.

Insert (F4)

Enter additional Stock Group codes and information.

Delete

Delete Stock Group codes and information - only available if there are no Transactions related to the Stock Group.

Print (Ctrl+P)

Print a report of the information in the grid.

Filter / Sort List (Ctrl+F2)

Clear Filter / Sort (Ctrl+F3)

Apply or clear a Filter & Sort. The button changes to indicate if a filter and sort is applied.

Customise (Alt+F5)

Opens Customise Fields, you can customise the fields visible in the grid.

Refresh

Reloads changes other Users may have made.

Default GL Accounts (Ctrl+D)

Sets the GL Accounts for the selected group to the default GL Accounts set in IC Settings - Integration tab.

Note: If the default accounts are blank, existing accounts will not be overwritten.

Apply Default UOM Code (Alt+U)

(UOM Pending or Active)

Opens the IC Apply Default UOM - Stock Group window. Applies the Default UOM for the selected Stock Group to the Base UOM for selected Products in the Stock Group.

Customise Toolbar

Customise Toolbar or right-click in the toolbar below the buttons to access the Customise Toolbar Menu.