Inventory > Serial Tracking System > Serial Tracking Report

Serial Tracking Report

You use this program to generate a report listing details of serialized items held on file.

You can use this report to track the transactions in which specific serial numbers were used.

Report Options

Field Description
Report title Indicate the title you want to print on the report. This defaults to Serial Tracking Report but can be changed.
Report type  
Detail

Select this to print a detailed report of all transactions processed against each serialized item selected for printing.

When you select this option, only those serials that have transactions processed against them (such as receipts) are printed.

1 line summary

Select this to print a single line of details for each serialized item selected for printing.

If you select this option, then all serials are listed irrespective of whether transactions exist against them.

You typically select this option to easily determine which serials are both available and on hand, as it is possible to create serials without physically having these serials in stock.

2 line summary

Select this to print a two line summary for each serialized item selected for printing.

If you select this option, then all serials are listed irrespective of whether transactions exist against them.

Report sequences  
Primary Indicate how you want information to be printed on the report.

For example: If your Primary sequence is Stock code, then all the information on your report is grouped per stock code.

Secondary Your selection here determines what information is listed below each primary sequence on the report.

For example: If your Primary sequence is Stock code and your Secondary sequence is Serial number, then all the information on your report is grouped per serial number under each stock code.

Selection criteria

Field Description
Stock code selection

Indicate the stock code(s) for which you want to include details of serialized items on the report.

  • Rev/Rel.

    You use this field to indicate the specific revision and release of the single stock item or which you want to include details of serialized items on the report.

    This option is only enabled if the item is ECC controlled.

Serial number selection Indicate the serial number(s) for which you want to print details.
Customer selection Indicate the customer(s) for which you want to select serialized items for inclusion on the report.
Warehouse selection Indicate the warehouse(s) for which you want to select serialized items for inclusion on the report.

Additional Options

The options on this tab page enable you to indicate selectively which serialized items you want to print on the report based on various print options and a range of locations, expiry dates and scrap dates.

Field Description
Print options  
Subtotals for each stock code Select this if you want to print separate subtotals for each stock code.
New page for each stock code Select this to print details for each stock code on a new page.
Include w/h values of stock on hand Select this to include the warehouse values of the on hand stock on your report.
Include serials with zero on hand Select this to include serial numbers that have zero stock on hand.
Print batch serials for selected customers

Select this if you want to print batch serials for selected customers.

[Note]

You cannot access this field if you selected to print All customers at the Customer selection field.

Selection criteria

Field Description
Location selection Indicate the location(s) according to which you want to select serialized items for inclusion on the report.
Expiry date selection Indicate the expiry date(s) according to which you want to select serialized items for inclusion on the report.
Scrap date selection Indicate the scrap date(s) according to which you want to select serialized items for inclusion on the report.

Service Options

The options on this tab page enable you to indicate selectively which serialized items you want to print on the report based on a range of due dates for items that are in service, on loan or at a service depot.

Field Description
Report only options  
Items in service Select this include only those serialized items that are in for a service for the range of due dates specified.
Items on loan Select this include only those serialized items that are on loan for the range of due dates specified.
Items at service depot Select this include only those serialized items that are at the service depot for the range of due dates specified.

Selection criteria

Field Description
Due date selection Indicate the due date(s) according to which you want to select serials that are in service, on loan or at a service depot for inclusion on the report.

Transaction Options

The options on this tab page enable you to indicate selectively which serialized items you want to print on the report, based on the transaction type and a range of transaction dates. You can also specify whether you want to print transaction values and totals on the report.

[Note]

The options and selections on this tab page apply if you selected Report type -Detaill on the Report Options tab page.

Field Description
Show transaction values Select this if you want to print transaction values on the report.
Show transaction totals Select this if you want to print transaction totals on the report.
Transaction type Indicate the transaction type(s) you want to include on the report.
Show
Field Description
All Select this to include serials for all transaction types.
Single Select this to include serials for a single transaction type.
Type You use this field to indicate the specific transaction type you want to use to select serialized items for printing on the report.
FieldDescription
StandardSelect this to include standard transaction types.
MiscellaneousSelect this to include miscellaneous transaction types.
Std Type You use this option to indicate the specific transaction type from the available list of standard transactions catered for within SYSPRO.

One of the following standard transaction types can be selected:

  • Sales - Sales
  • Maint - Maintenance
  • Srvin - Customer unit in for service
  • Srvet - Unit returned to customer
  • Loan - Unit loaned to a customer
  • Return - Unit returned by customer
  • Tra - Transfer between warehouses
  • Rec - Receive goods in
  • Note - Additional notes
  • Warr - Warranty details
  • Move - Change location within warehouse
  • Depot - Unit sent to service depot
  • Depret - Received back from depot
  • Iss - Issue to work in progress
  • Phy - Adjust quantity on hand
Misc type You use this option to indicate the specific miscellaneous transaction type.

You can configure your own transaction types using the Transaction Posting program.

Include all subsequent transactions

Select this if you want to print all transactions posted against the selected serial numbers with the transaction type specified.

[Note]

You can only select this option if you specify a single transaction type according to which serialized items must be printed.

Selection criteria

Field Description
Transaction date selection Indicate the transaction due dates according to which you want to select serialized items for inclusion on the report.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).