News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) BUG. Unit Accounts

Microsoft Dynamics GP (Archived)

BUG. Unit Accounts

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

When creating a unit account there is a drop down for decimal places. The values are: 0,1,2
If you select 0 the DECPLACS field in GL00100 shows 1
If you select 1 the DECPLACS field in GL00100 shows 2
If you select 2 the DECPLACS field in GL00100 shows 3

I believe the developer is storing the position of the item in the dropdown list rather than the value selected.

I wanted to create a report and display the correct decimal places by using the value of DECPLACS even tho the value is actually stored with 5 decimal places because of the field being numeric(19,5)

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Ian Grieve 22,782 on at

Like (0)

Report

RE: BUG. Unit Accounts

As Mark says this is standard behaviour. It isn't uncommon in other systems either.

For this report simply subtract 1 from the value to get the number of decimals.

For other fields you could use a CASE statement to change from the value to the text you want to see.
mpolino on at

Like (0)

Report

RE: BUG. Unit Accounts

Not a bug. Using the position is by design. You'll find that in a lot of places in GP.

Mark
Community Member Microsoft Employee on at

Like (0)

Report

RE: BUG. Unit Accounts

forgot to post version...GP10SP5

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans