Sir... its superb.... your guidance always not fail.... The new code working fine [#Form: DayBook] [#Line: DBTitle1] Add: Right Field: At Beginning: DBUkT [Field: DBUkT] Use : NameField width : 5 Set as : "Disc" [#Line: DSPVCHDetail] Add: Right Field: At Beginning: ukdisc1 [Field:ukdisc1] Use : Amount Field Width : 5 Set as : $(Voucher, $MasterId).AllLedgerEntries[1, @@DLedger].Amount Align : Left Space Left: 3 Style : Small [System : Formula] DLedger : $LedgerName Contains "Discount"
Code: [#Line : DSP ColVchTitle] Add : Field: Before: DBC Qty : MRP Add : Field: after: DBC GrossAmt : Scheme Local : Field : MRP : Set as : "MRP" Local : Field : Scheme : Set as : "Scheme" [#Line : DSP ColVchDetail] Add : Field: Before : DBC Qty : MRP Add : Field: after: DBC GrossAmt : Scheme [Field: MRP] Use : Rate Price Field Style : Normal Bold Width : 10 Scroll : Yes Set as : $$GetEIStkItemMRP:$StockItemName:$Date ;$(StockItem, $StockItemName).MRPDetails[Last].MRPRateDetails[1].MRPRate Border : Thin Left [Field: Scheme] Use : Rate Price Field Style : Normal Bold Width : 10 Scroll : Yes Set as : $EIDiscountAmt Border : Thin Left I want EIDiscountAmt to appear in columnar report, Please help