I just stumbled on this. I have UoM of Bottle with 0 decimal places in GP. It shows as 0 when I look at it. If I go to IV40201, which is the table for the UoMSchedules, the decimal is 1. I have 20 UoM schedules set up and all of them are off by +1 in the data table.
Has anyone else noticed this?
*This post is locked for comments
Well, I'll say that back a different way. The value in the database indicates the list position. In this case, the value 0, which yes, is a string value in the list, occupies position 1. Therefore, the database stores a 1.
I think I understand. So even though it is an integer field, it is used more of a string to determine the value from another list?
Normal. 1 in the database means it's the first value in the list where the number of decimal places is seleted (zero shows first in the list).
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#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
Share
Report
All responses (
Answers (