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
I have the same question (0)
