WL Inventory Balance Report ranges and options

Ranges

See Reports - Ranges overview.

Options

WL Location

The name of the interface from Product Warehouse Description Setup.

View A)ll or O)ut of Balance Results

Specify (A)ll to view all results.

Specify (O)ut to view only out of balance results.

Buckets: A, B, C, D, E, F, G…K or X for all

The type of balancing detail, which corresponds with the legend, that is included on the report. Use this option when you set the previous option to (A)ll, otherwise your report may be confusing.

A: Warehouse transfers shipped from TWL that are in error status in WL Transaction Inquiry. Change the status to active and re-run the WL Entry Batch Shipping Report.

B: Warehouse transfers shipped from a TWL warehouse that need to be processed in the WL Entry Batch Shipping Report.

C: Shipped orders, including SO and CS orders that have not been invoiced. Excludes CR orders.

D: Orders shipped in TWL that are in error status in WL Transaction Inquiry. Change the status to active and re-run the WL Entry Batch Shipping Report.

E: Orders, including loaded orders, that are shipped in TWL and have an active status in WL Transaction Inquiry and are waiting for the WL Entry Batch Shipping Report to process them.

F: Purchase orders that were partially or completely received in TWL with an open receipt transaction (RT). Could also contain customer returns that have not been processed by the WL Entry Batch Shipping Report.

G: Purchase orders that were received in TWL that are in error status in WL Transaction Inquiry. Change the status to active and re-run the WL Entry Batch Receiving Report.

H: Return Merchandise (RM) purchase orders that are in WL Transaction Inquiry with a hold status and are waiting to be released to the WL Entry Batch Receiving Report.

I: Purchase orders received in TWL that have an active status in WL Transaction Inquiry and are waiting to be released to the WL Entry Batch Receiving Report.

J: Stock adjustments created in TWL that are in error status in WL Transaction Inquiry. Change the status to active and re-run the WL Entry Batch Adjust Inventory Report.

K: Stock adjustments created in TWL with an active status in WL Transaction Inquiry and waiting to be released to the WL Entry Batch Adjust Inventory Report.

Legend: Each P)age or E)nd of Report

The legend explains the contents of each bucket.

Specify (P)age to print the legend on each page.

Specify (E)nd to print the legend at the end of the report.

L)ive WL Whse, N)ot Live, or B)oth

Specify (L)ive, (N)ot Live, or (B)oth to indicate the status of the WL location on the Product Warehouse Description Setup record.

Show Bucket Detail?

Select Yes to include order numbers, receipt transactions, quantities, set number, and pick and pack transactions that were used to calculate the TWL on hand balance. The report does not provide reasons the quantity is out of balance.

Subtract Committed From SX.E Quantity?

Select Yes and the shipped but not invoiced quantity is calculated by adding the on hand, unavailable, and received quantities, then subtracting the committed and TWL in-process balances. The column label on the report is changed from On Hand SX.e Qty to Available SX.e Qty, so you can distinguish the quantity calculation that was used.

Show Inventory/Serial/Lot Detail

Select Yes to see serial/lot detail. If you set the option, View A)ll or O)ut of Balance Results, to (O)ut of Balance and there is a serial or lot discrepancy, the item shows only the serial/lots in question. Select No to not include the serial/lot details.

WL Nonstock Only Inv: Y)es, O)nly or N)o

Select Yes to search TWL nonstock item records to determine if they also exist in the Distribution SX.e system inventory records. Select Only to report the nonstocks only. Select No to exclude the nonstocks.

Note:  This report takes longer to execute when this option is set to Yes.