web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Decimal Places extensi...
Microsoft Dynamics GP (Archived)

Decimal Places extensions on SOP/POP Docs

(0) ShareShare
ReportReport
Posted on by Steve Kalina 125

Currency Decimals at 4 for PO reasons  (i.e. RM cost is .7105 per LB)...Extended amounts for  PO Invoice may end up at say $14.1030 which as we  all know is somewhat diffuclt to pay that extra .0030...Is there a setting to enable to set Documents at 2 decimals and rline items at 3+?

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi Steve,

    I'll take a shot at this one. I feel certain I'm not understanding this right. But, I'll try. You have PO Line items that are 4 decimals. The extended cost on the PO is, of course, also 4 decimals.  The document total of the PO, should only be 2 decimals (isn't it already?).

    As I go through this I can see that I'm not getting it. Can you help me out with some examples of document types and where on the document you want it to be 2 decimals?

    Thanks

    Leslie

  • Steve Kalina Profile Picture
    Steve Kalina 125 on at

    Leslie-

    Yes, it is the PO Invoice as well as the SOP Invoice...The line item and the document totals go out to 4 decimals.

    Steve

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi Steve,

    What fields do you want changed to 2 decimals? Is it just how it appears on the report? You can go into Report Writer and change the format of the data type so that you force it to 2 decimals. Is this what you had in mind?

    Kind regards,

    Leslie

  • L Vail Profile Picture
    L Vail 65,271 on at

    Sorry Steve,

    I just re-read your question and see that you want the Doc totals and 2 decimals and the line items to stay as is.

    I believe you can force the format in Report Writer, my only question now is which documents (or is it a window) do you want to change?

    Leslie

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    There are 2 different settings that you need to consider. First is the number of decimal places for each currency. This is set globally, per currency, on a system-wide basis. This should be what the currency actually uses - for example, for the US Dollar, it should be 2. And this setting will control ALL transactions in GP that use this currency.

    Separately, for each inventory item in GP there is a setting that controls the number of currency decimal places. This is a per ITEM setting and can go up to 5 decimal places. If you're using Multicurrency you can even have the same item use a different number of currency decimal places depending on the currency it is bought or sold in. Often companies with large quantities of small value items will find it useful to have more currency decimal places at the item level than is used for the currency itself.

    However, and this is where I am a little lost by the initial question, if you have an item set to use 4 decimal places for the item currency, but the currency you are buying or selling in is set to have 2 decimal places in the system globally, you will see the following on both the screens in GP and the out-of-the-box reports:

    On a PO:

    Item      Qty     Unit Cost      Extended Cost

    A          12345      1.2345        15,239.90

    Total PO = 15,239.90

    On an SOP transaction:

    Item      Qty     Unit Price     Extended Price

    A           123      2.3456        288.51

    Total SOP transaction = 288.51

    So the Unit Cost/Price will use the number of decimal places for the item, but the Extended Cost/Price and the transaction totals will always use what the currency is globally set to.

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi Victoria,

    I wondered why the dollar part for total wouldn't match the US dollar settings. You are awesome.

    Leslie

  • Steve Kalina Profile Picture
    Steve Kalina 125 on at

    thanks all for the input...Not an issue on the forms as I can easily round the doc totals, the issue is that with a doc amount of $100.01303, when paid, it leaves an extra .0003 remaing..

    I had the Currency set at 4 and the Item at 4 -- always thought the two had to be in sync, but seeing Victoria's response, it sounds lke they don't and I will give that a stab...

    Thanks for the help.

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Steve,

    Hopefully you're doing all of this in a test environment. If your live environment is set up with 4 decimal places for the US dollar and you already have transactions with more than 2 decimal places in the system, you will need to work with someone (either your GP partner or Dynamics GP support) to help you clean this up in database. The GP user interface will not let you lower the number of decimal places, only increase. :-(

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans