Field formats in Microsoft GP

(0) Share

Report

Posted on by briant

185

I am trying to format fields in a report to print with only 2 decimal places. Currently we have our global GP setting to reflect 4 decimal places and cannot change that for customer reasons. How can I format the reports to show only 2 decimal places - can I do this for ALL reports or does each report I have need to be adjusted individually. Please be a specific as possible.

Thank you for your responses in advance.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Richard Whaley 25,195 on at

Like (0)

Report

If you are using the GP Report Writer, you need to set the format for each report. You select a field, open properties, and select the format desired. There is a two decimal format already defined.

Was this reply helpful? Yes No
briant 185 on at

Like (0)

Report

I thought I had performed the above functions and received no change to the report. Could you please be more specific in your answer. Any help is greatly appreciated.

Which format is the two decimal format as it looks like there are many.

Was this reply helpful? Yes No
briant 185 on at

Like (0)

Report

Also when I select a field - how do I open properties? I only see report field options. Am I in the right place or is there some where else I should be looking.

thank you

Was this reply helpful? Yes No
Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

you are in the correct place.

Did you give permission in Alternate/Modified Reports/Windows (under Administrator) to the modified version of the report?

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
I will be providing the modification on the Payable Trials Balance > Aged Trial Balance Report on a step by step bases for further illustration;

On the report Writer, Click on the (Field) which you want to change its decimals,

On the Properties pane shown beside the report, Go to "format field" and then click the lookup button as shown below;

The report field option will show,

Click on the button to go to the formal lookup

Click (Open) to go for the (Format Definition) window. On which, Change the value of the decimal places to the required value.

Close the report writer and save the changes.

Now, you go to Tools > Setup > System > Alternate/ Modified forms and Report. To choose the modified report

Product: All Product

Type: Reports

Series: All

Result:

The decimal places on the Aged Trial Balance Report is changed for the document Amount Field from (Two) decimals to (Zero) decimals.

Before Modification

After Modification

Was this reply helpful? Yes No
Ian Richardson 4,150 on at

Like (0)

Report

amazing post as usual Mahmoud. Great Pictures!

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Thanks a lot Ian ...

Privileged by your statement.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Briant

Another option, this article show how to round a calculated field in report writer. You can set number of decimal places at point 11.

http://support.microsoft.com/kb/872275

Cheers!

Sanjay

Was this reply helpful? Yes No