Reports
COMPONENT BALANCE AUDIT BY LOT
The
Component Balance Audit
by Lot report is used for checking inventory balances for purchased components between the ERP system and ONESOURCE.This screen can be opened by choosing
Component Balance Audit by Lot
either from the EU Customs Regimes Tracking
or Customs Regimes Inventory Reports
menu, depending on how the system was configured during implementation.To generate a report, select either
Show Parts Out of Balance
or Show All Parts
, and then click Generate
.After the report has completed running,
Report Output – Time
will appear in the middle of the screen. Clicking Report Output – Time
will open the Component Balance Audit report in a separate browser tab.A report can be generated as an Adobe PDF (default), Excel spreadsheet, or Word document. These options are available in the
Report Format
drop-down.To view a generated report, click the associated link. Adobe PDF is the default. To view the report, click the associated link.
Checking
Send Report Generation Complete Email
sends an e-mail so other tasks can be performed as the Component Balance Audit Report generates. To proceed without a confirmation e-mail, uncheck the box.
The
IP System Balance
and the IM System Balance
columns show the ONESOURCE and ERP inventory balances respectively. The System Comparison
column shows the variance between the two systems.
ANNUAL RECONCILIATION
The
Annual Reconciliation
screen and report calculate quantities for each purchased component:- Positive Receipts
- Positive Adjustments
- Negative Receipts
- Shipments Into The EU
- Export Shipments
- Negative Adjustments
- Scrap Transactions
- Pending Quantities
- Beginning Balance
- Ending Balance
This screen can be opened by choosing
Annual Reconciliation
from the Reports
menu.A component’s quantities are displayed by status code (Community Goods, Non-Community Goods) and in total for the period. If any parts are out of balance, they will be flagged with an asterisk (*) beside the part number on the report.
While the Annual Reconciliation report is required annually, it is recommended that the report be run monthly to monitor inventory activity throughout the year. Period Balances (Beginning Date and End Date) must be saved in order to run this report.
To create a report, choose a
Begin Date, Ending Date
, and Summary Level
. Next, click Generate
.
A report can be generated as an Adobe PDF (default), Excel spreadsheet, or Word document. These options are available in the
Report Format
drop-down.To view a generated report, click the associated link. Adobe PDF is the default.
Checking
Send Report Generation Complete Email
sends an e-mail so other tasks can be performed as the Component Balance Audit Report generates. To proceed without a confirmation e-mail, uncheck the box.
PRODUCT HISTORY BY LOT
The Product History by Lot Report displays a set of specified transactions for a specific lot number within specific date parameters. This screen can be accessed by choosing
Product History by
Lot from the Reports
menu.To generate a report, choose a field to search from the
Search Field
drop-down. Enter the value to search for in the Search Value
field.Enter the
Beginning Date
and Ending Date
. Check the appropriate boxes in the Transaction Types
section to determine which types to include. Once finished, click Generate. A report can be generated as an Adobe PDF (default), Excel spreadsheet, or Word document. These options are available in the Report Format
drop-down.To view a generated report, click the associated link.
