BUG. Unit Accounts

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

forgot to post version...GP10SP5

Was this reply helpful? Yes No
mpolino on at

Like (0)

Report
Copy link

Link copied!

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

Mark

Was this reply helpful? Yes No
Suggested answer

Ian Grieve 22,784 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No