How to Change Decimal Places on the Unit & Discount Price on SOP Blank Invoice Form

(0) Share

Report

Posted on by Community Member

Customer uses 4 decimal places in GP for inventory items and does not wish to change. However, they would like to change the format of these fields to reduce the decimal places that display on the sop blank invoice form. I have gone into the formatting of the current fields and tried every combination and cannot get it to print any differently. I have also tried creating a new TEST format and still it does not work. Any Suggestions?

Thanks,

Nancy

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: How to Change Decimal Places on the Unit & Discount Price on SOP Blank Invoice Form

In case the formatting is not meeting your requirement, you do need to consider the "rounding" function in order to decrease the number of decimals. Consider the support article for this issue Article ID: 872275 How to round a calculated field in Report Writer in Microsoft Dynamics GP

One important point to consider when using the rounding function, the parameter you pass for this function doesn't reflect the real number decimals you want. For example, if you want to retrieve 2 decimals as in your case, you need to pass 3.

Never hesitate to share any further inquiries,

Was this reply helpful? Yes No
Redbeard 12,931 on at

Like (0)

Report

RE: How to Change Decimal Places on the Unit & Discount Price on SOP Blank Invoice Form

We had an experience with a client recently who wanted this type of change to the invoice for just this reason. The primary method to make this change would be to change the format that applies to the field on the invoice; however, this format applies to many reports all over Great Plains (like checks, inventory reports, etc.)

So this change affected almost every report in GP - so be very careful attempting this change. In the end our team's developer was able to create a custom calculated field to replace the default field on the invoice only, so the change did not permeate throughout Dynamics GP.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: How to Change Decimal Places on the Unit & Discount Price on SOP Blank Invoice Form

Thanks very much Mahmoud.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to Change Decimal Places on the Unit & Discount Price on SOP Blank Invoice Form

Thanks for your reply Harry. I will go with the calculated field as suggested by Mahmoud as well.

Was this reply helpful? Yes No