Overview

The Warehouse Withdrawal reports provide inventory, transaction history, and customer-level summary information for merchandise that has been entered into warehouse inventory and later withdrawn through the Warehouse Withdrawal workflow.

These reports are used to review what inventory remains on hand, research the complete activity history for a warehouse file, and summarize warehouse and withdrawal activity by customer. Each report may be printed as a standard report or generated as a spreadsheet for review, reconciliation, or customer communication.

Warehouse Withdrawal context: Warehouse inventory is created from the original Customs Warehouse Entry. Withdrawals reduce that inventory and are tracked back to the original file, entry, customer, warehouse location, item, and line detail.

Choosing the Right Report

Report	Use This Report To	Typical Output
Items On Hand	Review warehouse inventory that still has a remaining balance on hand.	File, entry, customer, location, warehouse date, warehouse quantity, withdrawn quantity, and balance.
File History	Research the complete detail for a warehouse file, including the original entry header, original line detail, and each withdrawal posted against the file.	Detailed file history with header data, line item detail, withdrawal number, withdrawal date, quantities, balances, duty, value, fees, and MID information.
Customer Statistics	Summarize warehouse activity by customer for a selected date range.	Customer totals for quantity warehoused, quantity withdrawn, value withdrawn, duty paid, other fees, and record count.

Items On Hand Report

The Items On Hand Report lists warehouse inventory items that still have a remaining balance available for withdrawal. It is used to review open inventory by file number, entry number, customer, warehouse location, warehouse date, item quantity, withdrawn quantity, and remaining balance.

Prompt	Description
Department No. or (A)ll	Enter a department number to limit the report to one department, or enter A to include all departments.
Select Date Range	Enter Date Range Code to auto calculate dates. Enter / to view the list of available codes..
Starting Date	Starting date range limits which warehouse records are included.
Ending Date	Ending date range limits which warehouse records are included.
Sort Criteria	Selects how the report will be organized. Available sort options are File Number, Entry Number, Customer, Warehouse Date, Customer/Part Number, or Warehouse Location.
Customer No. or (A)ll	Enter a specific customer number or enter A to include all customers.
Whse Loc. or (A)ll	Enter a warehouse location to limit the report to one location, or enter A to include all warehouse locations.
(R)eport or (S)preadsheet	Choose whether to generate the report in standard report format or as a spreadsheet.

Sort Options

A. By File No. — Groups and orders the report by the warehouse file number.
B. By Entry No. — Orders the report by Customs entry number.
C. By Customer — Groups records by customer.
D. By Whse Date — Orders records by warehouse date.
E. By Customer/Part# — Useful when reviewing inventory by customer part number.
F. Whse Location — Groups inventory by warehouse location.

File History Report

The File History Report provides a complete detailed history for warehouse shipments. It includes the original Warehouse Entry header information, the original line item detail, and each withdrawal posted against the shipment. This report is useful when researching how an original warehouse entry was reduced over time and which withdrawal files were created against it.

Report Prompts

Prompt	Description
Search Option	Choose whether to search by date range or by a specific file.
Department or (A)ll	Enter a department number to limit the report, or enter A to include all departments.
Select Date Range	Used when the report is being run for a date range.
Starting Date	Starting date range limits which warehouse records are included.
Ending Date	Ending date range limits which warehouse records are included.
Customer or (A)ll	Enter a customer number to limit the report to one customer, or enter A for all customers.
File Number	Used when the specific file search option is selected. Enter the warehouse file number to review its complete history.
(R)eport, (S)preadsheet	Choose the standard report format or spreadsheet output.

What the Report Shows

The spreadsheet sample shows the original warehouse entry header at the top, including importer, consignee, entry number, entry date, arrival date, entry type, entry port, warehouse location, warehouse date, and related shipment fields. Beneath the header, the original entry line detail is listed with item number, classification detail, descriptions, quantities, units, duty rates, item values, duty amounts, fees, weights, and MID numbers.

Withdrawal activity is shown under the warehouse file detail. Each withdrawal section identifies the withdrawal number, withdrawal date, withdrawn quantity, remaining balance, user, and date posted, followed by the line item detail for that withdrawal.

Customer Statistics

The Customer Statistics report provides a customer-level summary of warehouse and withdrawal activity. It summarizes total quantity warehoused, total quantity withdrawn, value withdrawn, duty paid, other fees paid, and record count for the selected department, date range, and customer selection.

Report Prompts

Prompt	Description
Enter Department or (A)ll	Enter a department number to limit the statistics, or enter A to include all departments.
Select Date Range	Enter Date Range Code to auto calculate dates. Enter / to view the list of available codes.
Starting Date	Starting date range limits which warehouse records are included.
Ending Date	Ending date range limits which warehouse records are included.
(S)pecific Customers, (A)ll	Choose whether to include all customers or limit the report to selected customers.
Specific Customers Name	Used when specific customers are selected. Enter the customer name or customer selection criteria requested by the system.
(R)eport or (S)preadSheet	Choose standard report output or spreadsheet output.

Spreadsheet Columns

Acct No. — Customer account number.
Importer Name — Customer or importer name associated with the warehouse activity.
Qty Whsed — Total quantity placed into warehouse inventory.
Qty Wthdn — Total quantity withdrawn from warehouse inventory.

Value Whsed — Total value associated with the warehoused activity shown in the report.
Duty Paid — Total duty amount paid through withdrawals.
Other Fees — Additional fees paid, such as applicable Customs fees shown in the withdrawal activity.
Rcnt — Record count included in the customer summary.

Tips & Best Practices

Use Items On Hand for open inventory

Run this report when the question is what remains available to withdraw. Sort by file, customer, warehouse date, or location depending on the reconciliation task.

Use File History for research

Run this report when a user needs to trace the full life of a warehouse file from the original warehouse entry through each withdrawal.

Use Customer Statistics for summaries

Run this report when management or a customer needs a summarized view of warehouse and withdrawal activity by account.

Use spreadsheet output for reconciliation

Spreadsheet output is useful when totals need to be filtered, sorted, compared, or sent to a customer for review.

Frequently Asked Questions

Which report should I use to see what inventory is still available?

Use the Items On Hand Report. It is designed to show warehouse inventory with remaining balances.

Which report shows the complete history of a warehouse shipment?

Use the File History Report. It shows the original warehouse entry header, original line item detail, and each withdrawal posted against the file.

Which report summarizes activity by customer?

Use the Customer Statistics report. It summarizes quantities, values, duty paid, fees paid, and record counts by customer.

Should I choose report or spreadsheet output?

Choose report output for standard printed review. Choose spreadsheet output when the results need to be filtered, sorted, reconciled, or sent to another party.