Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Decimal places on sales documents

Posted on by Microsoft Employee

I'm having trouble getting the correct number of decimal places to print on sales orders/invoices. Here is the scenario:

My client needs to be able to sell liquids in eaches as well as gallons.  Their order entry people are accustomed to entering invoices using eaches(drums/totes), not gallons, but their customers want to see the number of gallons they are being billed for, not the number of drums or totes. Our solution was to try to do the math on the invoice using the Qty in Base U of M field in the sales detail table on the sales invoice, which works beautifully. All of my fields are calculating, but now I'm missing my decimal places. I need five decimal places to print for the quantity, and it's not printing any. The items are all set to have 5 decimal places on quantities. When i try to set up a new number format with 5 decimal places in report writer, 336 gallons turns into 0.00336 gallons. Something tells me multiplying my calculated field by 10,000,000,000 is not the right solution.

Any suggestions?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Decimal places on sales documents

    Thanks! That's what it was!

  • Verified answer
    Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: Decimal places on sales documents

    Hi Mike,

    Please change the result type of your calculated field to "Currency".  This will allow the "Format Field" section of the "Report Field Options" window to become available (and then you can select Decimal Places QTYS from Sales Transaction Amounts Work.

    It helps to try to remember that when using calculated fields that the result type "Integer" basically means whole numbers (aka, no decimal places).

    The result type "Currency" means a value that can have decimal places (and, depending on how you use the "Format Field", you may also get a currency symbol). 

    From the RW help:

    When you select a format field for a currency field, the possible formats for currency fields and the integer value associated with them are shown in the following table.

    Integer

    Format

    Integer

    Format

    0

    Control panel defaults

    10

    $1,234.567

    1

    1,234

    11

    $1,234.5678

    2

    1,234.5

    12

    $1,234.56789

    3

    1,234.56

    13

    1,234%

    4

    1,234.567

    14

    1,234.5%

    5

    1,234.5678

    15

    1,234.56%

    6

    1,234.56789

    16

    1,234.567%

    7

    $1,234.

    17

    1,234.5678%

    8

    $1,234.5

    18

    1,234.56789%

    9

    $1,234.56

    Thanks,
    Justin

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Decimal places on sales documents

    Hey Justin, unfortunately that side of the window is greyed out. I created a calculated field to convert from eaches to gallons, could that have something to do with it? Here's a screen shot:

    Here's my the calculation I'm using:

    Result type: integer

    Expression type: calculated

    (SOP_LINE_WORK.QTY Prev Back Ordered + SOP_LINE_WORK.Qty To Back Order) * SOP_LINE_WORK.QTY In Base U Of M

    Maybe my problem is with the calculated field?

  • Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: Decimal places on sales documents

  • Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: Decimal places on sales documents

    Clearly, I don't know how to paste a screenshot here!

    (I hope my text explanation suffices).

  • Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: Decimal places on sales documents

  • Suggested answer
    Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: Decimal places on sales documents

    Hi Michael,

    1.)  In the report layout, double click on your quantity field.  This brings up the "Report Field Options" window.

    2.)  In the lower right-hand corner of this window you have the "Format Field" section.  Here you need to select Sales Transaction Amount Work as the table, then highlight Decimal Places QTYS.  Please see the below screenshot as an example.

    Thanks,
    Justin

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans