How to print the Item Number field on the "PA Billing Invoice Format 10" report in Microsoft Dynamics GP


INTRODUCTION

This article describes how to print the Item Number field on the PA Billing Invoice Format 10 report in Microsoft Dynamics GP.

MORE INFORMATION

To print the Item Number field on the PA Billing Invoice Format 10 report in Microsoft Dynamics GP, follow these steps:
1. Back up the report, and then open the report. To do this, follow these steps:
a.

If you have existing modified Microsoft Dynamics GP reports, back up the Parept.dic file. To find the Parept.dic file, follow these steps:

• On the Tools menu, point to Setup , point to System , and then click Edit Launch File . If you are prompted, type the system password.
• In the Edit Launch File window, click Project Accounting . The location of the Parept.dic file is displayed in the Reports field.



     
b. Click Tools , point to Customize , and then click Report Writer .
c. In the Product list, click Project Accounting , and then click OK .
d. In Report Writer, click Reports on the toolbar.
e. In the Original Reports column, click PA Billing Invoice Format-Invoice Format 10 , and then click Insert .
f. In the Modified Reports list, click PA Billing Invoice Format-Invoice Format 10 , and then click Open .
2. Create the table relationship. To do this, follow these steps:
a. In Report Writer, click Tables on the toolbar, and then click Tables .
b. Click PA_Billing_ITEM_TEMP2 , and then click Open .
c. Click the Relationships button.
d. Click New .
e. Click the ellipsis button (...), click PA PO Receipt Line History , and then click OK .
f.

Click the Secondary Table Key list, click the first key in the list, and then match the following fields in the bottom of the window:

• Match the PA Cost Document No. field to the PA Vendor Invoice Document No field.
• Match the PA Cost Sequence Number field to the Receipt Line Number field.



     
g. Click OK .
h. In the Modified Reports list, select the report, and then click Open .
i. In the Report Definition window, click Tables .
j. Click PA Billing Item Temp2 , and then click New .
k. Click PA PO Receipt Line History , click OK , and then click Close .
l. In the Report Definition window, click Layout .
m. In the Toolbox window, click PA PO Receipt Line History .
n. Drag the Item Number field into the Body section of the report.
o. Close the report layout.
p. When you are prompted to save your changes, click Save .
3. Exit Report Writer. To do this, follow these steps:
a. In the Report Definition dialog box, click OK .
b. On the File menu, click Microsoft Dynamics GP or Microsoft Business Solutions - Great Plains .
4. Grant access to the report by using Advanced Security or by using standard Microsoft Dynamics GP security. To do this, use one of the following methods.

Method 1: Use Advanced Security
a. On the Tools menu, point to Setup , point to System , and then click Advanced Security .

Note If you are prompted, type the system password.
b. Click View , and then click by Alternate, Modified and Custom .
c. Expand Project Accounting , expand Reports , expand Project , expand PA Billing Invoice Format-Invoice Format 10 , and then click Project Accounting (Modified) .
d. Click Apply , and then click OK .

Note By default, the current user and the current company are selected when you start Advanced Security. Any changes that you make are for the current user and for the current company. However, you can select additional users in the Advanced Security dialog box in the User area. You can select additional companies in the Advanced Security dialog box in the Company area.
Method 2: Use standard Microsoft Dynamics GP security
a. On the Tools menu, point to Setup , point to System , and then click Security .

Note If you are prompted, type the system password.
b. In the User ID list, click the user ID of the user for whom you want to grant access to the report.
c. In the Product list, click Project Accounting .
d. In the Type list, click Modified Reports .
e. In the Series list, click Project .
f. In the Access List dialog box, double-click PA Billing Invoice Format-Invoice Format 10 , and then click OK .

Note An asterisk appears next to the report name.

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. 

---------------------------