Adding the Serial/Lot Number to the IV Inventory Transaction Inquiry Report


TechKnowledge Content


Issue

How to add the Serial/Lot Number to the Inventory Transaction Inquiry Report

Resolution

Go into report writer and open up the IV Inventory Transaction Inquiry report.

1. Click on the Tables button in the Reports Definition window.

2. Double click the Inventory Transaction Amounts History table.

3. Double click the Item Serial and Lot Number History table.

4. Click on the Restrictions button on the Report Definition window.

5. Select new.

6. Name the restriction new.

7. Select Item Serial and Lot Number History in the Report table field.

8. Select Document Number for the Table Fields.

9. Select the Add Field button.

10. Select the equal sign (=).

11. Select the Add Field button again to add the Document Number from the Item Serial and Lot Number History table.

12. Go into the layout of the report and pull the Serial/Lot Number field from the Item Serial and Lot Number History table onto the B section of the report.

13. Give yourself security access to the report (Setup |System | Security).

This article was TechKnowledge Document ID: 27580

DISCLAIMER


MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE. 

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS