Dear respected members, We have voucher type "Cheque deposit" like contra where we pass entry dr bank account and cr ledger "Cheque".But I can't understand the mistakes of this function. Please help me sir. [Button: Chqdepopass] Key : F8 Title : "Chq Deposit Entry" Action:Execute : Chqdepositentry [Report: Chqdepositentry] Form : Chqdepositentry [Form: Chqdepositentry] Part : Chq deposit Info Space Top : 1 Space Left : 1 Space Right : 1 Space Bottom : 1 ;Option : Small Size Form Height : 40 % Page Width : 50 % Page Vertical Align : Centre On : Form Accept : Yes : Form Accept On : Form Accept : Yes : CALL : ChqdepositVchCreate [Part: Chq deposit Info] Lines : chqdepbank,chqrecfrm,Chqdepdate Local : Line : Default : Space top : 1 [Line: chqdepbank] Fields : Medium Prompt,chqdepbankfld Local : Field : Medium Prompt : Set as :"Deposit Bank Account :" [Field: chqdepbankfld] Use : Name Field Modifies : chqdepfldvar1 Table :List of BankLedgers Show Table:Always Full width : Yes Set as :"" [Line: chqrecfrm] Fields : Medium Prompt,chqrecfrmfld Local : Field : Medium Prompt : Set as :"Cheque Recevied From :" [Field: chqrecfrmfld] Use : Name Field Modifies : chqdepfldvar2 Full width : Yes Set as :"" [Line: Chqdepdate] Fields : Medium Prompt,Chqdepdatefld Local : Field : Medium Prompt : Set as :"Cheque Deposit Date :" [Field: Chqdepdatefld] Use : Uni Date Field Modifies : chqdepfldvar3 ;Full width : Yes Set as :"" [Variable: chqdepfldvar1] Type : String Persistent : Yes [Variable: chqdepfldvar2] Type : String Persistent : Yes [Variable: chqdepfldvar3] Type : Date Persistent : Yes [system : Variable] chqdepfldvar1 :"" chqdepfldvar2 :"" chqdepfldvar3 :"" [Collection: Chqdepentrypass] Data Source : Report : Selected;;Current Fetch : All Ledger Entries,DueDateOfPymt,OrderDate,partybankname,partybankbranch [Function: ChqdepositVchCreate] VARIABLE : SVViewName : String Variable : ProgressCount: Number Variable : Counter : Number 00 : Set : Counter : 0 01 : Query Box : "Create Cheque deposit Voucher ?":Yes:No 02 : SET : ProgressCount : 1 03 : IF : NOT ($$NumItems:Chqdepentrypass> 0) 04 : RETURN 05 : END IF 06 : START PROGRESS: ($$NumItems:Chqdepentrypass) : "Createing" : "Cheque deposit Voucher" 07 : SET : SVViewName : $$SysName:AcctgVchView 08 : Walk Collection : Chqdepentrypass 09 : If : $$LastResult Action : 10 : NEW OBJECT : VOUCHER Action : 11 : SET VALUE : Date :##chqdepfldvar3 Action : 12: SET VALUE : EFFECTIVEDATE :##chqdepfldvar3 Action : 13 : SET VALUE : Voucher Number :$VoucherNumber Action : 14 : SET VALUE : VoucherTypeName : "Cheque Deposit" Action : 15: SET VALUE : CLASSNAME : "Cheque Deposit" Action : 16 : SET VALUE : Narration :$Narration Action : 17 : SET VALUE : Narration : "This Cheque Being Deposited to the Bank Account" Action : 18 : SET VALUE : OrderDate : $OrderDate Action : 19 : SET VALUE : DueDateOfPymt : $DueDateOfPymt Action : 20 : SET VALUE : PARTYLEDGERNAME : "Cheque" Action : 21 : SET VALUE : ISINVOICE : "No" Action : 22 : INSERT COLLECTION OBJECT : AllLedgerEntries Action : 23 : SET TARGET : LedgerEntries Action : 24 : SET VALUE : LedgerName : $Partyledgername Action : 25 : SET VALUE : Is Deemed Positive : "no" Action : 26 : SET VALUE : Amount : $Amount Action : 27 : SET TARGET : ... Action : 28 : INSERT COLLECTION OBJECT : AllLedgerEntries Action : 29: SET TARGET : LedgerEntries Action : 29a : SET VALUE : LedgerName : ##chqdepfldvar1 Action : 29b : SET VALUE : Amount : $Amount Action : 30 : SET VALUE : Is Deemed Positive : "yes" Action : 30a : SET VALUE : Is Last Deemed Positive : "yes" Action : 30b : SET VALUE : Is Party Ledger : "yes" Action : 31 : SET TARGET : .. Action : 32 : INSERT COLLECTION OBJECT : BANKALLOCATIONS Action : 33: SET TARGET : BANKALLOCATIONS Action : 34 : SET VALUE : Date : ##chqdepfldvar3 Action : 35 : SET VALUE : INSTRUMENTDATE : $OrderDate Action : 36 : SET VALUE : Name : $MasterID Action : 37 : SET VALUE : TRANSACTIONTYPE:"Cheque/DD " Action : 38 : SET VALUE : BANKNAME : $partybankname Action : 39 : SET VALUE : BANKBRANCHNAME : $partybankbranch Action : 40 : SET VALUE : PAYMENTFAVOURING : ##chqdepfldvar2 Action : 41 : SET VALUE : TRANSACTIONNAME : "Cash" Action : 42 : SET VALUE : INSTRUMENTNUMBER : $$VoucherNumber Action : 43 : SET VALUE : UNIQUEREFERENCENUMBER : $UniqueReferenceNumber Action : 44 : SET VALUE : PAYMENTMODE:"Transacted" Action : 45 : SET VALUE : Amount : $Amount Action : 46 : SET TARGET : ... Action : 80 : SET VALUE : CrDtTm1 :$$CmpUserName Action : 81 : SET VALUE : CrDtTm2 :$$MachineDate Action : 82 : SET VALUE : CrDtTm3 :$$MachineTime ;90 : END WALK 91 : SET VALUE : PersistedView : ##SVViewName 92 : CREATE TARGET 93 : SHOW PROGRESS : ##ProgressCount 94 : SET : ProgressCount : ##ProgressCount + 1 95 : End If 96 : END WALK 97 : Increment : Counter 98 : Msg Box : "Status" : "Cheque deposit Vouchers Created successfully" 99 : RETURN
It would be more helpful if you mention WHERE and WHEN and WHAT errors you are facing? Also your function would be showing some error in the Calculator panel if any error in function. You don't expect people to look at your codes, load them .. make a suitable database ... like your ChequeEntry type of Voucher and then do RnD for you. Post descriptive narrations and also screenshots.
Thanks for your reply sir.we have vch type "gst cheque receipt" under receipt and "cheque deposit" under contra voucher.(see screenshot)we have a report with all "gst cheque receipt" voucher.now I try to create selected "cheque deposit"voucher automatically when we click the button "chq deposit entry" with the function of above code.hope you understand sir. please help.
There is no error means the function is not the problem maybe. Is it possible for you to make a dummy tally data with a few ROUGH entries, so that i can run your code and see...... Also possible the problem might be with the other part of code. or is this the full code?
There seems to be no problem with the submissions made by you. However this error came up...but as the relevant file --PartyChequeRegister1 is missing - so you need to check from your end. If you do have problems in sharing code here in a public forum, you can email me...but do not expect answers from half codes. Good luck.
dear Dear Amit ji there is some misunderstanding.I do not hide anything.there is no such file named "partychequeregister1 ".PartyChequeRegister1 is a report which exist in my code PartyChequeRegister.plese see the code.I have not any prob to share code.
I cant understand this error. in my end there is no such error.how ever the field showing price field,group field etc no such field exist in my code
Ok..will try again ... in next week Also where is the report from your 3rd photo...how to get there? where your button F8 is and where your function is not working. Refer the file you sent me...........Info Fiels in Sales Voucher.txt ....... at halfway mark you will find these fields.