Solved

Unit Price decimals

Posted on 2011-02-21
9
316 Views
Last Modified: 2012-05-11
How can I increase unitPrice decimals to 4 digits instead of 2 in Axapata 2009 ?

I changed EDT but the price still displays as 1.8900 instead of 1.8888

Thanks
0
Comment
Question by:smetechit
  • 5
  • 4
9 Comments
 

Author Comment

by:smetechit
Comment Utility
The Trade agreament sales price is set to 1.8888

When create sales order the unit price is set to 1.8900

How can I avoid this price rounding?



0
 
LVL 4

Expert Comment

by:agusacil
Comment Utility
Hi,

In addition to that you need to set the round off price to 0.0001 for 4 decimals digit.
It is set up per currency code in General Ledger > Setup > Exchange Rate > Go to round off tab > Rounding price set from 0.000 to 0.0001.
Note that this setting affects many places that calculate price so you may need to test it thoroughly.
0
 

Author Comment

by:smetechit
Comment Utility
I changed rounding settings from 0.0000 to 0.0001 but still my problem not solved.
0
 
LVL 4

Expert Comment

by:agusacil
Comment Utility
Hi,

That should take effect the next time you create a new sales line. There are several similar field, make sure you set the correct field (Rounding price field within Prices field group) and at the correct currency code.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:smetechit
Comment Utility
Dear agusacil:,

I tried your solution but still Sales Price has two digits only. What is wrong?
0
 
LVL 4

Accepted Solution

by:
agusacil earned 500 total points
Comment Utility
Hi smetechit,

I don't see anything else should be set up as I have it works with that set up. In that case you might need a developer help to debug the code on the following and see what might cause the price value is changed:
SalesTable.initfromPriceDisc table method, and
PriceDisc.findPriceAgreement class method.
0
 

Author Closing Comment

by:smetechit
Comment Utility
The solution did not solve the problem
0
 
LVL 4

Expert Comment

by:agusacil
Comment Utility
This question shouldn't have been closed.
Could you let me know what is your finding on those method I mentioned? I just wonder as I do this without problem.
0
 

Author Comment

by:smetechit
Comment Utility
I still have the unt pric rounded as 1.8900 instead of 1.8888
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now