Fw: f_price DECIMAL(12,2)

----- Original Message ----- 
From: Linlong 
To: 4JS Support 
Sent: Thursday, 02 June, 2005 4:49 PM
Subject: f_price DECIMAL(12,2)



Hi,

I encountered a decimal problem, I defined a parameter 
f_price     DECIMAL(12,2)
but it store 4 decimal value, which cause cents diff.
attached herewith the original program.



voice Receipts                                                        apinv800
Batch number[    1]                                Total entries[     0]
Description [SUPPLIER INVOICE - 1          ]       Batch total  [0.00          ]
Entry number[   1]
Vendor no.  [SGOR01  ][ORA TELECOM (S) PTE LTD ]       Ori. txn type[    ]
Pay type    [N  ]            Pay to bank[        ]     Ori. txn no. [          ]
Txn type    [IN  ]           Txn date   [02-06-2005]   Due date     [          ]
Document no.[AA        ]     Tax type   [5   ]         Terms        [30     ]
Currency    [USD]            Exchg rate [        1.64000000]
Txn amount  [          1.00] Base amount[          1.64]
Reference   [                       ]
Description [                              ]
Type----GRN #---Ln--S-------Item code------Rec. qty---Unit price---Total price--
[R  [V3RN000001[  1[Y[BTH3-BK (ROM)       [  100.000[      24.75[      2,475.00]
[   [          [   [ [                    [         [           [              ]
[   [          [   [ [                    [         [           [              ]
[   [          [   [ [                    [         [           [              ]
[   [          [   [ [                    [         [           [              ]

f_price=  24.7506<>a_item[1].price=  24.7500 
dr_amt=       2475.06 
cr_amt=       2475.00