[#Field: VCHBATCH Rate] Format : "Symbol,Forex,Decimal:4" I want to make Rate with forex 1.1111 or 1.2366 In above both case the storage is showing only 1.1100 or 1.2400 Thank you for your quick help. Kannan
If I make the number of decimal place 4 then all my report showing 4 decimal place. But I wan to do only in Unit price
Do This in company alteration decimal place will 4 and using TDL we can get only Rate in 4 decimal place [#Field : VCH Value] Add : Option : Decimal Place [#Field : VCHBATCH Value] Add : Option : Decimal Place [#Field : EI ValueTotal] Add : Option : Decimal Place [#Field : EXPINV Amount] Add : Option : Decimal Place [#Field : EXPINV ValueSubTotal] Add : Option : Decimal Place [#Field : EXPINV Total] Add : Option : Decimal Place [#Field : EXPINV AccAmount] Add : Option : Decimal Place [#Field : EXPINV TCSAmount] Add : Option : Decimal Place [#Field : EXPINV AccSRVTAmount] Add : Option : Decimal Place [#Field : ACLSAmt] Add : Option : Decimal Place [#Field : DSPDBDrAmt] Add : Option : Decimal Place [#Field: DSPDBExpAmt] Add : Option : Decimal Place [#Field: DSPDBCrAmt] Add : Option : Decimal Place [#Field : VCHBILL Amt] Add : Option : Decimal Place [#Field: DSP ClCrAmt] Add : Option : Decimal Place [#Field: DSP ClCrAmtA] Add : Option : Decimal Place [#Field: DSP OpAmtA] Add : Option : Decimal Place [#Field: DSP DrAmt] Add : Option : Decimal Place [#Field : DSP ClDrAmtA] Add : Option : Decimal Place [#Field: VCH CurBalance] Add : Option : Decimal Place [#Field: DSP DrAmtA] Add : Option : Decimal Place [#Field: DSP NettCrAmtA] Add : Option : Decimal Place [#Field: DSP CrAmtA] Add : Option : Decimal Place [#Field: DSP NettAmtA] Add : Option : Decimal Place [#Field: DSP ClAmtA] Add : Option : Decimal Place [#Field : VCH ItemValue] Add : Option : Decimal Place ;[# [!Field : Decimal Place] Delete : Format Add : Format : "Decimal:2" Add : Key : Calculator [!Field : Decimal Place Rate] Delete : Format Add : Format : "Decimal:2" Add : Key : Calculator [#Field: Amount Field] Add : Option : Decimal Place [#Field : Amount Forex Field] Add : Option : Decimal Place [#Field : Amount DBase Field] Add : Option : Decimal Place [#Field : Amount Base Field] Add : Option : Decimal Place [#Field : Amount DrCr Field] Add : Option : Decimal Place [#Field : EXPINV SubTot] Add : Option : Decimal Place [#Field : EXPINV Total] Add : Option : Decimal Place [#Field: EI ValueSubTotal] Add : Option : Decimal Place [#Field : EXPINV RateTotal] Add : Option : Decimal Place [#Field : EXPINV RateInclTitle] Add : Option : Decimal Place [#Field : EXPINV VATGCCTotalAmtTitle] Add : Option : Decimal Place [#Field: VCHBATCH Rate] Add : Option : Decimal Place : Not @@Isdecimalplace [#Field : VCH Rate] Add : Option : Decimal Place : Not @@Isdecimalplace [#Field: VCH GST DutyAmount] Add : Option : Decimal Place [#Field: VCH GST ItemValue] Add : Option : Decimal Place [#Field: Total Duty Value] Add : Option : Decimal Place ; Set as : $$RoundDown [#Line: GST As Per Transaction Amt] ; Local : Field : Total Duty Value : Delete : Set as add : Local : Field : Total Duty Value : Add : Set as : ##GSTTotalActualTaxAmount-$$AsAmount:0.050 [#Field : VCH Vat DutyAmount] Add : Option : Decimal Place [#Field : VCH AccAlloc GSTAssessableValue]
system formula @@isdecimalplace are not available and at last line [#Field : VCH AccAlloc GSTAssessableValue] are nor completed please mention that. Regards ASG.