Adding Text to H12 in PA Invoice Format Detail Page 1

Applies to: Dynamics GP 2010

TechKnowledge Content


Issue

I'm trying to add Text to H12 in PA Invoice Format Detail Page 1.

Potential Cause

Because of the limited number of report sections that can be created per report, H12 has been created to have multiple functions in the report. H12 is used to create blank lines, as a TM or CP/FP cost category type header and as a fee category type header. Because of the multiple functions, any customizations to the header will be displayed multiple times.

Resolution

You need to create a conditional calculated field for your text.

1. Calculated Fields:

a. In the Toolbox choose Calculated Fields from the drop down list.

b. Then choose the New button.

c. In the Calculated Field Definition window, type (name) as the name.

d. For the Result type choose String from the drop down list.

e.The Expression Type should be Conditional.

2. In the fields section:

a. Place your cursor in the Conditional Expression.

b. Choose the Fields tab.

c. Click on the drop down list for Calculated Fields and choose Dummy Total Line.

d. Choose the Add button.

3. In the operators section:

a. Place your cursor in the Conditional Expression.

b. In the operators section, choose the <> button

4. Choose the Addbutton.

5. In the operators section:

a. Place your cursor in the Conditional Expression.

b. In the operators section, choose the AND button

6. Choose the Add button

7. In the fields section:

a. Place your cursor in the Conditional Expression.

b. Choose the Fields tab.

c. Click on the drop down list for PA Invoice Format Detail Page 1 TEMP and choose PA Inv Frmt Description.

d. Choose the Add button

8. In the operators section:

a. Place your cursor in the Conditional Expression.

b. In the operators section, choose the <> button

9. Choose the Add button

10. In the constants section:

a. Place your cursor in the Conditional Expression

b. Choose the Constants Tab.

c. Click on the drop down list for Type and choose String

d. Type space in the Constants field, and choose the Add button.

The Conditional Expression should read: Dummy Total Line <> "" AND PA_Invoice_Format_Detail_Page_TEMP.PA Inv Frmt Description <> ""

True Case: (Type in your Text here)

False Case: ''''

11. Choose the OK button.

This article was TechKnowledge Document ID: 27216