Commodities

This screen lists all the commodities (ingredients and packaging items) available in the system that go into making a formula.

Important: You can only edit commodities if you have been granted the correct privileges. To edit a commodity click on the ‘EDIT TABLE’ button at the bottom of the screen.

Adds a commodity to the list.

Deletes a commodity from the list.

Exports a CSV file with the table view contents (opens in Excel).  Applies to the formula list (upper) & the formula steps (lower).

Type into the box and the system will search automatically based on the menu selection to the right (click and use the pull down to select which column to search). Delete the text to remove the search.

Code

Code used as an abbreviated commodity identifier for the description. Must be unique. If entering a code which has been entered previously and deleted, the option to restore the deleted commodity will be provided with a pop up.

Description

Description used to identify the commodity.

Type

Ingredient or Packaging. Ingredient (default) is used as an addition to a batch or product. Packaging is used in a Product and typically added consumed at the finished product stage. Select ‘Type’ by clicking in the cell and using the pull down box.

Units

How the product is received. Setup the Stock Units in the ‘Units’ menu. If you intend to weigh the commodities as part of your production process, use either Pounds or Kilos (depending on what your scales are calibrated)

Bulk Units

How the Ingredient or Packaging is received. For example, a 50lb bag would have a bulk unit of Pounds. A 22.5kg bag would have a bulk unit of kilos.

GTIN

Enter in a 13 digit GTIN and the check digit (14th digit) will be automatically calculated. Mainly used for identifying received commodities with a barcode lookup.

Cost Default

Used as a standard cost for a commodity. Cost is calculated per unit. Cost default is only used when lot specific costs are not captured alongside a supplier purchase order.

Record Usage

When checked, the commodity lot number will be captured at each handling point. When unchecked, the commodity lot number will not be prompted or captured at the handling points. For example, a commodity like water which does not have a lot number will not require it’s usage recorded or lot captured.

Expiry Days

The default number of expiry days to apply to a commodity at the receiving stage. This value can be overridden at the receiving stage if the particular expiry date of a supplier lot number is known and different to the default.

Supplier Default

To assist in the speed of data entry at the receiving stage, a Supplier Default can be selected. Suppliers are setup in the Ordering / Suppliers section.

Quantity Default

To assist in the speed of data entry at the receiving stage, a Quantity Default can be selected. Useful is a set quantity of received consistently. For example, a 55,000lb silo of flour is usually filled at the same qty every time, so having a quantity default will assist the receiving process.

Location Default

To assist in the speed of data entry at the receiving stage, a Location Default can be selected. Useful if a commodity is received into the same location each time.

Default Low Tol

To assist in the speed of data entry of formula steps the lower tolerance can default to the value entered here, it can then be amended if required for that particular formula.

Default High Tol

To assist in the speed of data entry of formula steps the lower tolerance can default to the value entered here, it can then be amended if required for that particular formula.

Receipt Container

You can define a specific container (of type ‘container’) into which this commodity is received into.

Batch Container

You can define a specific container (of type ‘container’) into which this commodity is produced into.

Cleardown Threshold

Then the on hand quantity of a lot for this commodity drops below this value then the system will prompt the operator whether they wish to cleardown the lot, i.e. set the on hand value to zero.

Purchasing Notes

This will be the default notes used on a purchase order line containing this commodity. The notes can be changed when entering the purchase order line.

Specific Base Conversion

This column is longer used and can be ignored.

Bulk Platform

This can be used to define a shoot or silo name for dispensing of bulk ingredients, to enable communication between the terminal and the automatic dispenser please speak to the support desk.

Warning Level

Used on the stock reports, when on hand levels drop below this level the on hand value will be highlighted in red.

Image

A picture of the commodity can be stored in this column to be displayed on the terminal when the commodity is about to be used, this can aid the operator in ensuring they are using the correct commodity. Click in this column to open a dialog box from where you can load an image from your computer.

Unit Display Mode

When ordering this commodity on a purchase order this value will either let you order it in different units of measurement (when set to ‘All’) or just the units of measure specified in ‘Units’ above (when set to ‘Specific’).

Datafield1

General text field which can then be printed on labels.

Datafield2

Second general text field, same as above.

Expiry Method

Bespoke expiry calculation, please leave as ‘Standard’ unless SG support representative requests otherwise

Expiry Mask

Same as Expiry Method above.

Containerized

If this option is ticked then when this commodity is received it will be booked into lot containers, each container will have it’s own serial number.

Withdraw Threshold

Bespoke setting to limit the amount of stock that can be withdrawn for this commodity, please do not enter a value in this column unless instructed to do so otherwise by a SG support representative.

Physical Width

Defines the width of the commodity. Used in conjunction with the dimensions of a stock location to stop the stock location from becoming over crowded.

Physical Height

Defines the height of the commodity.

Physical Depth

Defines the depth of the commodity.

Moves cell down.

Moves cell right.

Hold down to select multiple rows.

Cancels transaction.

Edit Cell

Adds a commodity to the list.

Deletes a commodity from the list.

Exports a CSV file with the table view contents (opens in Excel).  Applies to the formula list (upper) & the formula steps (lower).

Type into the box and the system will search automatically based on the menu selection to the right (click and use the pull down to select which column to search). Delete the text to remove the search.

Code

Code used as an abbreviated commodity identifier for the description. Must be unique. If entering a code which has been entered previously and deleted, the option to restore the deleted commodity will be provided with a pop up.

Description

Description used to identify the commodity.

Type

Ingredient or Packaging. Ingredient (default) is used as an addition to a batch or product. Packaging is used in a Product and typically added consumed at the finished product stage. Select ‘Type’ by clicking in the cell and using the pull down box.

Units

How the product is received. Setup the Stock Units in the ‘Units’ menu. If you intend to weigh the commodities as part of your production process, use either Pounds or Kilos (depending on what your scales are calibrated)

Bulk Units

How the Ingredient or Packaging is received. For example, a 50lb bag would have a bulk unit of Pounds. A 22.5kg bag would have a bulk unit of kilos.

GTIN

Enter in a 13 digit GTIN and the check digit (14th digit) will be automatically calculated. Mainly used for identifying received commodities with a barcode lookup.

Cost Default

Used as a standard cost for a commodity. Cost is calculated per unit. Cost default is only used when lot specific costs are not captured alongside a supplier purchase order.

Record Usage

When checked, the commodity lot number will be captured at each handling point. When unchecked, the commodity lot number will not be prompted or captured at the handling points. For example, a commodity like water which does not have a lot number will not require it’s usage recorded or lot captured.

Expiry Days

The default number of expiry days to apply to a commodity at the receiving stage. This value can be overridden at the receiving stage if the particular expiry date of a supplier lot number is known and different to the default.

Supplier Default

To assist in the speed of data entry at the receiving stage, a Supplier Default can be selected. Suppliers are setup in the Ordering / Suppliers section.

Quantity Default

To assist in the speed of data entry at the receiving stage, a Quantity Default can be selected. Useful is a set quantity of received consistently. For example, a 55,000lb silo of flour is usually filled at the same qty every time, so having a quantity default will assist the receiving process.

Location Default

To assist in the speed of data entry at the receiving stage, a Location Default can be selected. Useful is a commodity is received into the same location each time.

Moves cell down.

Moves cell right.

Hold down to select multiple rows.

Cancels transaction.

Edit Cell