1. Identify Total Units RECEIVED for a Production Lot (Batch No)
2. Identify Total Units SHIPPED for a Production Lot (Batch No)
3. Identify Total Units ON HAND (INVENTORY) for a Production Lot (Batch No)

In order to gather the total number of units received into InfoPlus for a specific Production Lot (Batch No), we will start on the Item Receipt table in InfoPlus

InfoPlus Login Page

Item Receipt Table

• The Item Receipt Table will show the individual receipts of items as they were received into our warehouses through an inbound ASN

You will need to filter the Item Receipt table in order to acquire the specific information that you are looking for.

Filter the Item Receipt table by:

1. 'Type' = Normal
2. 'Prod Lot' - Contains - "The production Lot you are looking for"

After filtering the Item Receipt Table, the results can be exported and the quantities summed to confirm the total QTY received. Use the Actions dropdown menu to Export the results to an Excel spreadsheet.


If there are multiple lines on the export, you will need to SUM the column 'Received Quantity' to get the total quantity of units received.

In order to gather the total number of units shipped out of ShipCalm from InfoPlus for a specific Production Lot (Batch No), we will start on the Order Line table in InfoPlus

InfoPlus Login Page

Order Line Table

• The Order Line Table will show the individual order lines for every order in our system.
• A single order can have multiple order lines associated with the same order number

You will need to filter the Order Line table in order to acquire the specific lines of shipped orders.

Filter the Order Linetable by:

1. 'Status' = Shipped
2. 'Prod Lot' - Contains - "The production Lot you are looking for"

After filtering the Order Line Table, the results can be exported and the quantities summed to confirm the total QTY Shipped. If there are multiple lines on the export, you will need to SUM the column 'Shipped Quantity' to get the total quantity of units received.

Use the Actions dropdown menu to Export the results to an Excel spreadsheet.

In order to gather the total number of units On Hand at ShipCalm in InfoPlus for a specific Production Lot (Batch No), we will start on the Inventory Detail table in InfoPlus.

InfoPlus Login Page

Inventory Detail Table

• The Item Receipt Table will show the individual receipts of items as they were received into our warehouses through an inbound ASN

You will filter the Inventory Detail table to acquire the specific lines of On Hand Inventory for the Production Lot (Batch No).

Filter the Inventory Detail table by:

1. 'Prod Lot' - Contains - "The production Lot you are looking for"

After filtering the Inventory Detail Table, the results can be exported and the quantities added to confirm the total Quantity.

If there are multiple lines on the export, you will need to SUM the column 'Quantity' to get the total quantity of units On Hand.


Use the Actions dropdown menu to Export the results to an Excel spreadsheet.

NOTE: Open (Started/In Progress) Assembly Jobs DO NOT show On Hand Inventory

Suppose there are OPEN Assembly Jobs, either in a Started or In Progress status that uses the SKU of the Production Lot (Batch No) you are looking for. In that case, the number of units being used to complete that Assembly Job will not be accounted for in inventory until the Output SKU of the Assembly Job is received back into inventory after the job is Completed.

To check this:
Navigate to the Job Table and filter by Status of Started or In Progress