Dear Experts, Greetings of the day..! Today I am writing a code to control duplication of cheques. For this, I wrote a separate field on the sales entry screen with the name Cheque No: for this field, I need a Duplicate alert control message and also this field is needed to fetch in the Bank Reconciliation report.Here i am attaching my code here Please guide me [#Part: DBLLINE Narration] Add:Option:CHS NARRATION@IsPayment [!Part:CHS NARRATION] Add:Line:Before:VCH NarrPrompt:CHS CHIQUENO [Line:CHS CHIQUENO] Field:Simple Field, CHSCHEQUENO Local:Field:Simple Field:Set as:"CHEQUE NO" Local:Field:Simple Field:Skip:Yes [Field:CHSCHEQUENO] Use:Name Field Set as:$$Value Storage:CHSCHEQUENO Unique:Yes [System:UDF] CHSCHEQUENO:String:1994 ;;;;;;;; BAnk Reconciliation report;;;;;;;;;; [#Line: EBanking Recon Summary Title] Add:Field:After: EBanking Summary ChqNo:ChsChequeNumber Local:Field:ChsChequeNumber:Set as:$$LocaleString:"Cheque No." [#Line: EBank Recon Vouchers] Add:Field:After: EBanking Summary ChqNo:ChsChequeNumber ; Local : Field : EBanking Summary ChqNo elete : Set as : If NOT ##AutoBRSUpdateBankDate AND NOT $$IsEmpty:$BankersDateTemp Then $TransactionChequeNo Else If ##AutoBRSUpdateChqNum Then If NOT $$IsEmpty@AutoBRSMT490InstNum Then @@AutoBRSMT490InstNum Else $TransactionChequeNo Else $TransactionChequeNo ; Local : Field : EBanking Summary ChqNo :Set as:$"Suresh" [Field:ChsChequeNumber] Use:Name Field Set as:$CHSCHEQUENO Set always:Yes Skip:Yes [#Collection:EBank Recon Vouchers] Fetch:CHSCHEQUENO
Dear experts, Please guide me.... I tried and got the solution for the Cheque Number Duplicate control, But I need to fetch that cheque number in the bank reconciliation report ;;;;;;;; Bank Reconciliation report;;;;;;;;;; [#Line: EBanking Recon Summary Title] Add:Field:After: EBanking Summary ChqNo:ChsChequeNumber Local:Field:ChsChequeNumber:Set as:$$LocaleString:"Cheque No." [#Line: EBank Recon Vouchers] Add:Field:After: EBanking Summary ChqNo:ChsChequeNumber [Field:ChsChequeNumber] Use:Name Field Set as:$CHSCHEQUENO Set always:Yes Skip:Yes [#Collection:EBank Recon Vouc