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
Thanks! That's what it was!
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
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?
Clearly, I don't know how to paste a screenshot here!
(I hope my text explanation suffices).
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156