Bin and SKU level Inventory Snapshot - WMS

Navigate To

Description

Total Inventory at Bin and SKU level with Bin status and QC status.

Fields

Fields

Description

This column can be null

Sample Data

Fields

Description

This column can be null

Sample Data

1

 Zone

 

 

abc123

2

Client Name

Name of the Client

NA

Increff

3

Fulfilment Location Name

Name of the Fulfilment Location / warehouse

NA

wms_hsr

4

Bin ID

 Bin id

NA

 12345667

5

Global Sku ID

Global SKU ID

NA

123456789

6

Client Sku ID

Client SKU ID

NA

123456678

7

Category

Category of SKU

NA

abc123

8

Bin Location ID

Bin location id

NA

123456789

9

Bin Status

Status of bin

NA

OFFLINE / PUTAWAY

10

Last Bin Location

Last bin location if the bin is offline

If bin status is not offline

123445

11

Bin QC Status

QC status of bin

NA

PASS / FAIL

12

Bin Created At

Bin created time

NA

01-07-2020 12:49

13

Bin Updated At

Bin updated time

NA

01-07-2020 12:49

14

Quantity

Total quantity of the particular SKU in the Bin

NA

123

15

Available Quantity

Available quantity for sale

NA

123

16

Bin Audited At

Audit time of bin

NA

01-07-2020 12:49

17

Length

Length of SKU

 

123.22

18

Breadth

Breadth of SKU

 

123.22

19

Height

Height of SKU

 

123.22

20

Weight

Weight of SKU

 

123.22

Filters

Filters

Description

Limitation

Filters

Description

Limitation

1

Client

Name of the client

Mandatory

2

Time Zone

To show data in the specified time zone

Mandatory

3

Fulfilment Location Name

Name of the Fulfilment Location

Mandatory

4

Bin Status

Bin Status

Multi Select

5

EAN

Client SKU ID

Multi text

6

Location

Bin Location

Text

7

Audited From - Audited To

To filter the report based on Return Audit Time

Maximum (31 days)

8

Zone

 

Multi Select

FAQs

Â