Thank you for your inputs. Is it possible to add a button in the DayBook or ledger screen to turn on or turn off the cheque number column display ?
I am trying to learn TDL. There is code to add custom cheque number field in some other topics on this forum. Based on the code posted there as well as the code posted in this topic, UDF value is appearing in the day book report. However, in Ledger Vouchers report it is not appearing. Credit to the original creators of the various codes on the basis of which this file is created. Please suggest where it is getting wrong.
Dear Mr. Jay Kumar, Can u plz provide the final code for Display Chq number in ledger and Daybook of Payment,Receipt & Contra entry. Thanks,
Some peoples are selling codes which are collected from forum. So I deleted the most of codes which is posted earlier. As Seniors say. Currently only snippets.
Is that method any different.........??? What is the guarantee you would not sell or market or pass on to others who does so ?? If you really like something, kindly take positive steps to start making it so......... I personally know many members including JAYKUMAR TAILOR, who has migrated from asking to making TDL softwares. And there is no reason whatsoever that a CODER will give away free his toil of labour.............. If you really like it then buy it......if not affordable then make it............. You can ask 100 or 1000 questions....if stuck in coding, experts will help you.
No sir Not a mistake Before now I And many other do This earlier. But Now I Try to Make/Change Things Always. Ask for Queries Always. Please Give A little Effort to this. And got amazing Result. Try to change [Collection]
Yes you can..........but only in the exploded part.........because the receipt/payment details will be only available when you explode it.
Dear All Cheque No. is displayed properly in Daybook report. But when Only Payment Vouchers are selected using F4, the cheque No. Field does not show any data Following code is used Code: ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara ;; Om Muruga : Om Shridi Sai Baba ;; Cheque No Field in Contra, receipt and payment /* - This code adds a new field cheque number in the narration line ---- It will also add a column in day book and ledger view to display the cheque number ---- also in group vouchers report cheque number column will be shown -------- */ [#Part: DBL LineNarration] Add: Option: PK RcptPymtContra: (@@IsReceipt or @@IsContra or @@IsPayment) [!Part: PK RcptPymtContra] Add: Line: Before: VCH NarrPrompt: PK RcptPymtContra [Line: PK RcptPymtContra] Field: Medium Prompt, PK ChNo Local: Field: Medium Prompt: Setas: "Cheque No.:" Local : Field : Medium Propmpt : Inactive : @@HasMyBankEntry and @@PKRcptnotContra [Field: PK ChNo] Use: Name Field Storage: PKChNo Inactive : @@HasMyBankEntry and @@PKRcptnotContra [System: UDF] PKChNo: String: 101 ;;--------------------- adds chno to narration [#Field: VCH Narration] Use : Voucher Narration Field Lines : 4 Storage : Narration ;;Set as : If $$InCreateMode or $$InAlterMode Then $$LocaleString:"Ch.No.: "+$$String:$PKChNo Else $Narration Set as : If @@IsReceipt or @@IsContra or @@IsPayment Then $$LocaleString:"Ch.No.: "+$$String:$PKChNo Else $$LocaleString:"" Width : 50% Screen Key : PrevVchNarration, PrevLedNarration Set Always : Yes ;;---------------------------------------------------------------- ;; Table to Filter in DayBook [#Form: DayBook] Add: Button: PK DB FilButton [#Report: DayBook] Add: Set: PKChNoVar: $$SysName:NotApplicable [Button: PK DB FilButton] Title: "Cheque No." Key:Alt+9 Action: Alter: PK DB Form [Report: PK DB Form] Form: PK DB Form [Form: PK DB Form] Part: PK DB Form NoConfirm: Yes [Part: PK DB Form] Line: PK DB Form [Line: PK DB Form] Field: Medium Prompt, PK DB Field Local: Field: Medium Prompt: Setas: "Select Ch. No:" [Field: PK DB Field] Use: Name Field Modifies: PKChNoVar Table: PKChqNoTable, NotApplicable ShowTable: Always [Variable: PKChNoVar] Type: String Persistent : No [System: Variable] PKChNoVar: "" [Collection: PKChqNoTable] Type: Voucher Filter: PKRcptPayContra Fetch: PKChNo Format: $PKChNo, 20 Title: "List of Cheque No" [System: Formula] PKRcptPayContra: ($$IsReceipt:$VoucherTypeName or $$IsPayment:$VoucherTypeName or $$IsContra:$VoucherTypeName) PKRcptnotContra: ($$IsReceipt:$VoucherTypeName or $$IsPayment:$VoucherTypeName) PKChqNoFilter: If ##PKChNoVar = $$SysName:NotApplicable then True else $PKChNo = ##PKChNoVar HasMyBankEntry : $$FilterCount:AllLedgerEntries:HasBankEntry = 0 [#Collection : vouchers of Group] Add: Fetch: PKChNo Add: Filter: PKChqNoFilter [#Collection : vouchers of ledger] Add: Fetch: PKChNo Add: Filter: PKChqNoFilter [#Collection: Daybook Vouchers of Company] Add: Fetch: PKChNo Add: Filter: PKChqNoFilter [#Line: DSP VchDetail] Add : Right Fields : Before : DSP Vchtype : TEPLChequeNoFld [#Line: DSP VchAccTitles] Add : Right Fields : Before : DSP VchTypeTitle : TEPLChequeNoTitle [#Line: DB Title1] ; required for daybook Add : Right Fields : Before : DSP VchTypeTitle : TEPLChequeNoTitle [Field : TEPLChequeNoTitle] Set as : "Cheque No." Skip : Yes Width : 8 [#Line: DSP VchDetail] Add : Right Fields : Before : DSP Vchtype : TEPLChequeNoFld [Field : TEPLChequeNoFld] Use : Name Field Set as : $PKChNo Skip : Yes Align : Left Width : 6 [Field : TEPLChequeNoFld1] Use : Name Field Set as : $VchRef Skip : Yes Align : Left Width : 6 [#Form: DayBook] Add: Button: PK DB2 FilButton [Button: PK DB2 FilButton] Title: "Display Cheque No." Key:Alt+8 Action: Alter: PK DB Form The screen shots are as follows
Just like Collection -- vouchers of ledger and Daybook Vouchers of Company ............. Find the appropriate Collection for Filtered Vouchers in Daybook... Fetch and Compute the same and you will get it.
amit sir i am getting cheque no in CONTRA, JOURNAL, RECEIPT AND PAYMENT( Double ENTRY) By using this Set as : If $$IsPayment:$VoucherTypeName then $AllLedgerEntries[-2].BankAllocations.INSTRUMENTNUMBER else $AllLedgerEntries[-1].BankAllocations.INSTRUMENTNUMBER BUT if payment is done in single entry then not showing. please guide
In your Field .......... you should have multiple values........ Val1 : If this then that else this.... and so on (as per Vouchertype) Val2: If this then that else this.... and so on (as per Entry mode) then......in Set As : If $$IsEmptyVal1 then @Val2 Else @Val1 .......... You need to work out the formulas to obtain the value in case of Single Entry mode...........