Topic Options
#3392 - 05/15/03 10:47 AM Re: Price list with 3 decimal places
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello Wayne Matson,

I assume that you've adjusted the format of the amount in your Crystal report. That's the first item. Secondly, Adagio OrderEntry carries the pricing to 6 decimal places while the invoices are being printed. You may need to redo the mathematic to determine the unti price to the appropriate number of decimals.


Top
#3394 - 05/15/03 08:14 PM Re: Price list with 3 decimal places
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11640
Loc: Vancouver, BC Canada
Hi Wayne,

Due to how the database stores the numeric information, you will need to create a formula to display the correct information for Alternate Price lists with 3+ decimal places.

In your case, you need to create a formula that divides the numeric field by 10, then format the formula field to have 3 decimal places.

If you want to print multiple price lists with different decimals, then you have to use the 'Pricing Decimals' field in conjunction with an If/Then/Else statement:

If Pricing Decimals = 3 then Price/10 else Price

The reports and processing built into Order Entry (both Adagio and Accpac Plus) already take this into consideration. As you are creating a report on the 'raw' data, you may have to manipulate the data somewhat to get what you want.


Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 111 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1873 Members
5 Forums
14552 Topics
71029 Posts

Max Online: 432 @ 01/20/25 10:17 PM
October
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31