Inventory Log

This screen helps you quickly assess the current situation of stock within the system.

The top left hand panel displays a list of all the current commodities available, selecting a commodity will populate the top right hand panel. The top right hand panel list all the lots of the selected commodity, please note a single lot might be split into 2 or more stock locations so a lot number may be repeated several times for each location. Selecting a lot number will populate the lower panel, this list all the events that have taken place for this particular lot including quantities received, consumption, related questions and answers, movements, adjustments, etc. etc.

Please note this is a read only screen and is provided as a quick reference.

Exports a CSV file with the table view contents (opens in Excel).  Applies to all Inventory tables.

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.

Commodity Code

This displays the Commodity Code, you cannot edit this field because it is looked up from the Commodities table.

Description

This displays the Commodity Description, this is pulled in by the Commodity Code and cannot be edited.

Type

This displays the Commodity Type (Formula, Ingredient etc). This field cannot be edited as it is defined in the Commodities table.

Unit

This displays what Unit the Commodity is received. This field cannot be edited as it is pulled in from the Commodities table.

Lot

This is the lot number for the selected stock item, this number is assigned upon receiving the item.

Supplier Lot No

This displays the Supplier Lot number  if the selected item has been assigned one.

LPN

License Plate Number. Used to uniquely identify a pallet, this number is usually printed out as a barcode on a pallet label to help identify it and it’s contents quickly.

Supplier

This displays the Supplier Code of the Commodity if there has been one selected upon receipt.

Supplier Name

This displays the suppliers name.

Received

This displays the date and time in which the item was received.

Expiration

This display the date and time in which the item will expire.

Location

This displays the location of where the item currently resides (Warehouse, Freezer, and Stock Room etc).

Location Code

This displays the location code.

On Hand

This displays the current quantity of the selected item left in stock.

Location

This displays the Production Location Name of the Terminal that performed the transaction.

Description

This displays what transaction was performed using the selected Lot (Stock In, Adjustment, Consumed etc).

Batch/Order

This displays the Batch Number of the item if it was produced at a Terminal. It will also display the Sales Order Number if the item has been shipped to a customer.

Value

This displays either the quantity tied to the transaction (e.g 5.0 Shipped) or displays the answer to the question within the question field.

User

This displays what user was logged into the system at the time of the transaction.

Timestamp

This displays the date and time of when the transaction took place.

Reason

This displays the reason of the transaction, for example, if an item was withdrawn from inventory, the operator could enter a reason why.

Question

This displays any questions that were asked upon receiving the item.

Formula Code

This displays the Formula Code that was produced against the Lot Number, or the Formula Code in which the selected item was consumed.

Formula Desc

This displays the Formula Name that was produced against the Lot Number, or the Formula Name in which the selected item was consumed.

Formula Type

This displays what type of Formula was produced against the Lot Number, or the Formula type in which the selected item was consumed.

Formula UOM

This displays the above Formula’s Unit of Measure.

Customer

If the selected item has been shipped to a customer, this cell displays the Customer Code.

Stock Location

For stock related transactions this will display the stock location involved.

Lot Container

The specific lot container name the commodity is stored in (where applicable)

Moves cell down.

Moves cell right.

Hold down to select multiple rows.

Cancels transaction.

Edit Cell