Warehouse Bin Query

This program lets you browse warehouses and view the bins (and their contents) within those warehouses.

Exploring

Things you can do in this program include:

  • View bins contained within a warehouse

  • View the contents of a bin within a selected warehouse

  • Create bin and warehouse transfers

    The bins within the warehouse can be selected from a tree structure. The bin content is displayed in a listview where you can select the ellipses at the Action column to create bin and warehouse transfers. From there the Inventory Movements program is displayed where all relevant fields are pre-populated for ease of use. If the Enable for put-aways setup option is enabled, you can also create bin or warehouse put-aways.

This program is accessed from the Program List of the SYSPRO menu:

  • Program List > Inventory > Warehouse Management

Within SYSPRO, a warehouse represents an actual warehouse containing your inventory items (i.e. a physical warehouse) or a grouping of your inventory according to specific characteristics of the item (i.e. a logical warehouse).

For example:

You may want to split your inventory raw materials and finished goods into different logical warehouses even though they are located in the same physical warehouse.

You maintain warehouses using the Warehouse Maintenance program.

This is typically a container or shelf in a warehouse that lets you keep track of stored inventory items.

Each bin is assigned a type to indicate its basic flow of activities. This helps define the way in which it is used and to prevent incorrect use (e.g. dispatching inventory from a WIP bin, or consuming products that have not yet been receipted).

A putaway refers to the process of moving inventory between bins and warehouses. The initial putaway would be from the receiving zone to the storage location in a warehouse. Subsequent Putaway transactions include bin and goods in transit warehouse transfers.

Topics

Kanban Automated Replenishment

Setup programs

Warehouse Maintenance

Processing programs

Inventory Movements

Starting

  • You can only access this program if the Fixed bins setup option is enabled (Setup Options > Configuration > Distribution > Inventory).

The following configuration options in SYSPRO may affect processing within this program or feature, including whether certain fields and options are accessible.

The Setup Options program lets you configure how SYSPRO behaves across all modules. These settings can affect processing within this program.

Setup Options > Configuration > Distribution > Inventory

  • Fixed bins
  • Enable for put-aways
  • Show Warehouses (hyperlink)
    • Automated kanban replenishment
    • Use kanban receiving bin
    • Kanban receiving bin
    • Use kanban dispatch bin
    • Kanban dispatch bin
    • Warehouses to replenish from
  • Full goods in transit transfers facility

Solving

The Create putaway bin transfer and Create putaway warehouse transfer options are only available if the Enable for put-aways setup option is enabled (Setup Options > Configuration > Distribution > Inventory).

Using

  • Columns in a listview are sometimes hidden by default. You can reinstate them using the Field Chooser option from the context-sensitive menu (displayed by right-clicking a header column header in the listview). Select and drag the required column to a position in the listview header.

  • Fields on a pane are sometimes removed by default. You can reinstate them using the Field Selector option from the context-sensitive menu (displayed by right-clicking any field in the pane). Select and drag the required fields onto the pane.

    The captions for fields are also sometimes hidden. You can select the Show Captions option from the context-sensitive menu to see a list of them. Click on the relevant caption to reinstate it to the form.

    If the Show Captions option is grayed out, it means no captions are hidden for that form.

  • Press Ctrl+F1 within a listview or form to view a complete list of functions available.

The following table lists the transaction codes and types that occur in the Inventory Control module.

These transaction types are stored in the InvMovements table and are printed on the following reports:

  • Inventory Journal Report
  • Inventory Distribution Report
  • Optimized Kardex
Code Description

ABC

X - ABC journal record

ABC

x - ABC variance journal

ADJ

A - Adjustment

BACK

Backflushing

BFL

B - Backflushing variance

BIN

b - Bin transfer for multiple bins (journal and movement only)

CHG

C - Cost change

DSP

D - Dispatch note reversal

DSP

d - Dispatch note issue

EXP

E - Expense Issues

GTR

z - GIT cost multiplier

GTR

z - GIT cost multiplier non-merchandise variance

INS

W - WIP inspection

ISS

I - Issue

MOD

M - Cost modification

PHY

P - Physical count

REC

c - GRN cost multiplier entry

REC

G - GRN (Goods Received Note)

REC

g - Cost multiplier non-merchandise variance

REC

R - Receipt

REW

O - WIP inspection rework

SCR

S - WIP inspection scrap

TIMM

Immediate transfer

TIN

Transfers IN

TNOD

Transfers - No destination

TOUT

Transfer OUT

TOT

t - TOTAL variance entry

TRF

T - Transfer

VAR

a - Variance caused by average cost calculation

VAR

f - FIFO rounding

VAR

s - Variance caused by standard cost transfer

VAR

v - Variance caused by standard cost transfer

VAR

w - WIP automatic write-off variance

Referencing

This refreshes the List of Bins tree view and the Details for bin listview, after you select a warehouse.

Field Description

Warehouses

Indicate either a single or list of warehouses for which you want to view bins and their contents.

Bins

Indicate either a single or list of bins for which you want to view the bin contents.

The selected bins are then displayed in the List of Bins tree view, after you select the Refresh Bins function.

Options

 

Include zero quantities on hand

This lets you include bins and stock codes with a zero quantity in the Details for Bin listview.

This tree view lists the bins contained within the selected warehouse.

Bins displayed in red are on hold.

This listview includes details regarding the bin contents, some of which include:

Column Description

Bin

This indicates the bin that selected at the List of Bins tree view.

Stock code

This indicates the stock code in the selected bin.

Quantity on hand

This indicates the current quantity of the selected stock code in the bin.

Action

The ellipses in this column let you create the following inventory movement transactions:

  • Create a bin transfer

  • Create a warehouse transfer

  • Create a putaway bin transfer

  • Create a putaway warehouse transfer

Selecting one of these actions opens the Inventory Movements program with all the relevant fields pre-populated.

You can only create putaway transfers if the Enable for put-aways setup option is enabled.

Query

The View hyperlink in this column lets you view movements for the selected stock code using the Inventory Browse on Combined Movements program.

This listview includes all the Kanban Automated Replenishment details per bin and stock code.

Column Description

Bin

This indicates the selected bin within the warehouse.

Stock code

This indicates the stock code linked to the selected bin.

Kanban active

A Yes indicates that the Kanban Automated Replenishment functionality was enabled against the stock code.

Kanban pull quantity

This indicates the replenishment quantity that will be requested once the Kanban pull level or balance is reached.

Kanban pull balance

This indicates the current stock on hand plus the quantity contained in replenishment movements destined for the bin that have already been generated (but not completed).
Full containers This functionality is not yet available, but will be included in one of the following phases.

Change

Select the ellipses to launch to Bin Stock Maintenance program where you can link a stock code to a bin within the warehouse and change the Kanban pull quantity and balance.

You can only maintain bins within a warehouse for which the Automated kanban replenishment setup option is enabled (Program List > Inventory > Setup).