This report provides a physical list of the lines that you have calculated in the Phys. Inventory Journal window. You can use this report during the physical inventory count to mark down actual quantities on hand in the warehouse and compare them to what is recorded in the program.
The report does not automatically show the calculated quantity of the items. You can have the program include the contents of this field in the report by placing a check mark in the Show Qty. (Calculated) check box.
If you choose to show lot and serial numbers in the report with the Show Lot/Serial No. option, the way the report displays the item tracking information depends on the setup of the location and the item:
• If the location does not use bins, the report lists all available lot and serial numbers per item in inventory in the location.
• If the location uses bins and the item tracking code of the item is set up for warehouse-specific tracking, the report lists the lot and serial numbers contained in each bin.
• If the location uses bins and the item tracking code of the item is not set up for warehouse-specific tracking, the report lists only a summary per item of all the lot and serial numbers in inventory in the location.
If you run Calculate Inventory in the Phys. Inventory Journal with the option to show items not on inventory, the program lists in the journal all items, even those that have no quantity in inventory. If you then run this report with the option to show lot and serial numbers, the report lists for these zero-inventory items all lot and serial numbers that have been used in the past, but they are only history and not currently in inventory. For those items that are in inventory, the report lists only the lot and serial numbers that are currently in inventory.
You can define what is included in the report by setting filters. You can set additional fields on the tabs by clicking the Field field, then clicking the AssistButton that appears to the right. You can also determine what is shown in the report by filling in the fields on the Options tab. Fill in the fields as follows:
Journal Template Name: Enter the name of the item journal templates to be included in the report. To see the existing item journal template names, click the Filter field, then click the AssistButton that appears to the right.
Name: Enter the names of the item journals to be included in the report.
Click the up-arrow at the lower left-hand corner of the window to see the result of the filters you have defined for the table.
Global Dimension 1 Code: Here you can choose which dimension values will be included in the report. To see the existing dimension values, click the Filter field, then click the AssistButton that appears to the right.
Global Dimension 2 Code: Here you can choose which dimension values will be included in the report. To see the existing dimension values, click the Filter field, then click the AssistButton that appears to the right.
Location Code: Here you can choose which locations will be included in the report. To see the existing locations, click the Filter field, then click the AssistButton that appears to the right.
Bin Code: Here you can chose which bins will be included in the report. To see the existing bins, click the Filter field, then click the AssistButton that appears to the right.
Show Qty. (Calculated): Place a check mark in the check box if you want the report to show the calculated quantity of the items.
Show Lot/Serial No.: Place a check mark in this field if you want the report to show lot and serial numbers.
Click the Print button to print out the report. If you want to see the report on the screen before printing, click the Preview button. If you do not want to print the report now, click Cancel to close the window.