RE: Fw: f_price DECIMAL(12,2)
"Nuno Godinho" <[email protected]>
| Newsgroups | gmane.comp.lang.4gl.fourjs.user |
|---|---|
| Message-ID | <4EA9E2774F529143944B50BA22187F7E3E5930@201.86.30.213.rev.vodafone.pt> |
Hi! f_item RECORD LIKE po_stk_det1.* What's the structure of po_stk_det1 ? Regards Nuno -----Mensagem original----- De: Linlong [mailto:[email protected]] Enviada: quinta-feira, 2 de Junho de 2005 10:37 Para: 4JS User Assunto: [fourjs-users] Fw: f_price DECIMAL(12,2) Importancia: Alta ----- Original Message ----- From: Linlong <mailto:[email protected]> To: 4JS Support <mailto:[email protected]> 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