790
Hi All,
I Already updated the Setup in Inventory Module (Dynamics GP-->Utilities-->Inventory-->Change Decimal Places ) After this process i checked in the Custome form those unit cost and extended cost decimal places no luck.
Please Advise any suggestions.
Thanks
Nizam
*This post is locked for comments
Hi,
LISTPRICE is not the field you want. All currency fields are stored in the database with 5 decimals. Format is not considered when writing to the data table. What you want is the DECPLCUR field to determine the display format. In the example you posted, each of the items listed are set to 5 decimals. I understand you are new to Dexterity, but I think the best bet for you would be to review the Programmers manuals that come with Dexterity where it will explain in detail how to use a range and extract the exact data you need from the table.
Kind regards,
Leslie
Thanks for your valuable input i have checked in in the table there is column like LISTPRICE have an Decimal places.
Please check below image
I have created one new local field in form,here is my doubt how to pull the data from table to this field,please help me ,i am new to dexterity.
Your inputs will be Appreciated.
Thanks you very much for both ,i will try my end first then i will get back to you,both suggestions will be appreciated.
Btw its working on my dictionary so it must be something else you missed.you can msg me on skype tomorrow and if possible share your screen so I will check.
Hi,
The information for how many decimal places for the price of an item is stored in the ivItemCurr table (IV00105). This is the Item Currency table. You will need to create a field (can be a local field) on your form that pulls the information from this table. You would then link the format of your price fields to that field. That's how I think it works, I haven't actually built a form to try it.
Kind regards,
Leslie
currency index field should be inside scrolling window and there you have to select link format selector.
Yea this is one also tried ,but no luck....:(
pull the currency index field and then link the format to it.
Yea same thing i did,even though Decimal places are not changing ,i want that decimals to .0000 ,please help .
Drag the 'Currency Index' field from Global filed and place it on window, and then go o Tools Menu, select Link format selector . After that click on your field and move your cursor to the 'Currency Index' field.
Edited for correct field.
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (