;;Cheque No & Reference No in Daybook Display (Gopal Solanki) 28-9-2018 [#Line: DB Title1] Add : Fields : AFter : Dsp VchacctTitle : TEPLChequeNoTitle [Field : TEPLChequeNoTitle] Set as : "NEFT / RTGS / Cheque & DD No." Skip : Yes Width : 20 Align : center Style : Normal Line : 0 Border : Thin bottom [#Line: DSP VchaccTitles] Add : Fields : AFter : DSP VchacctTitle : TEPLChequeNoTitle Add : Fields : AFter : DSP VchacctTitle : BILLCol20 [#Line: DSP VchDetail] Add : Right Fields : Before : DSP Vchtype : TEPLChequeNoFld [Field : TEPLChequeNoFld] Use : Short Name Field Set as : $AllLedgerEntries[-1].BankAllocations.INSTRUMENTNUMBER Skip : Yes Align : centre Width : 20 Style : Normal Border: thin Left [#Line: DSP VchDyBkDetail] Add : Field : After : DSP VchAccount : Refnobb [Field:Refnobb] Use : Name Field Set As : $Reference Width : 20 Align : centre color : black Style : Normal Border : Thin Left right [#Line: DBTitle1] ; Fields : DSP VchDateTitle, DSP VchAcctTitle Add : Field : After : DSP VchAcctTitle : BILLCol20 [Field:BILLCol20] Set as : " Customer Invoice No.& Reference No." Width : 20 Align : center Style : Normal border : thin right left Border : Thin bottom Line : 0 [#Collection: Vouchers of Ledger] Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER Fetch : Reference [#Collection: Daybook Vouchers of Company] Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER Fetch : Reference [#Collection : Specific Vouchers of Company] Fetch : AllledgerEntries.BankAllocations.INSTRUMENTNUMBER Fetch : Reference [#Collection: Vouchers of Group] Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER Fetch : Reference
Very good Mr. Solanki. This won't work for all types of Payment/Receipt where multiple Ledgers are debited n credited. A good program must be dynamic in nature. User might be using Single Entry mode or Double Entry mode. It has to work for both. User may have multiple debits and credits in voucher entry. It should pick up automatically from wherever the Bank/Cash A/c has been debited or credited. Try your best to work around the above conditions. And you have a real winner.