Dear Sir, I have done excel to tally for Payment & receipt After the installation of the release 4.8 above, While Importing excel to tally , getting error message " Proper Pay link name not given for " Indian Bank How I fix it issue. Kindly advise me Thanks in advance. Regards Jaffar sha
This problem is pertaining to bank allocations. You can export the voucher XML and check all storage's are there in your code. Or else check default code, in one function it is written for bank allocations
Fill all Required fileds for Bank Allocations , as per sample given below 16H : Insert Collection Object : BankAllocations 16I : Set Value: PaymentMode : $$SysName:Transacted 16j: Set Value: Date: @Astdate 16K : Set Value : InstrumentNumber : ($$StringPart:$_4:6:6) 16L : Set Value: InstrumentDate : @Astdate 16M : Set Value : PaymentFavouring: $$String:$_5 16N: Set Value: BankName:##Selledgername 16O: Set Value: UniqueReferenceNumber : $$MakeTallyUniqueID 16P : Set Value: Amount: $$AsAmount:$$Number:$_7 16Q : Set Value: Transactiontype: "Cheque" 16R : Set Value: BANKPARTYNAME:$$String:$_5 ;16R: Set Value: ChequeCrossComment : 16S: Set value: Name : $$MakeUniqueID 16T : End If
Hi Jaffar Sha, I Studied you code in inserting bank Allocation you missed 3 major Lines After 4.6 in Tally they made some changes in bank allocation for that we have introduced this 3 line majorly. They are 330 : Set Value : Name : $$MakeUniqueID 338 : Set Value : PAYMENTMODE : "Transacted" 340 : Set Value : BANKPARTYNAME : ##RVINCOMELEDGER ;;--------------- Sample Code for Inserting bank ledger in Payment & Receipt 230 : Insert Collection Object: Ledger Entries 240 : SET TARGET : LedgerEntries 250 : SET VALUE : LEDGERNAME : ##RVBANKCASHLEDGER 260 : SET VALUE : Amount : ##RVDRAMOUNT 265 : SET VALUE : ISDEEMEDPOSITIVE : "Yes" 270 : If : Not $$IsEmpty:##RVBankAllocChequeNo 322 : Insert Collection Object : BANKALLOCATIONS 324 : Set Target : BANKALLOCATIONS 326 : SET VALUE : DATE : @@RVDATE 328 : SET VALUE : INSTRUMENTDATE : @@RPCheqDt 330 : Set Value : Name : $$MakeUniqueID 332 : SET VALUE : TRANSACTIONTYPE : ##RVBankAllocTransType 333 : Set Value : BANKNAME : ##RVBankAllocBankName 334 : Set Value : BANKBRANCHNAME : ##RVBankAllocBranch 335 : SET VALUE : PAYMENTFAVOURING : ##RVDONNARNAME 336 : SET VALUE : INSTRUMENTNUMBER : ##RVBankAllocChequeNo 338 : Set Value : PAYMENTMODE : "Transacted" 340 : Set Value : BANKPARTYNAME : ##RVINCOMELEDGER 342 : SET VALUE : CHEQUECROSSCOMMENT: "A/c Payee" 344 : SET VALUE : STATUS : "No" 348 : SET VALUE : AMOUNT : -1 * ##RVDRAMOUNT 350 : Set Target : .. 351 : End If
Lokesh Ji Can u plz provide the final working tdl for the above ? how to capture New ref/On Account or Against ref against each type of txn as per user desire in the above ? Also multiple ref in a single receipt/payment
I too faced the same problem, but resolved it myself. It is very simple that you have to insert the method "name" in bankallocations, (that can be the cheque no). Stechsundar Chennai
Dear Experts, I need to import payment / Receipt with Multiple Bank Allocation, any one have idea, please share. Thanks
PFA Before Bank Allocation just write walk collection. 590 : Insert Collection Object: Ledger Entries 592 : SET TARGET : LedgerEntries 594 : SET VALUE : LEDGERNAME : #PPMSBankName 596 : SET VALUE : Amount : ##PPMSJrnlNetReim 598 : SET VALUE : ISDEEMEDPOSITIVE : "No" 600 : Walk Collection : SalaryPay Import 597c : Set : PPMSJrnlTotSal : $PPMSJrnlTotSal 598c : Set : PPMSJrnlTotDeb : $PPMSJrnlTotDeb 599c : Set : PPMSJrnlNetPay : $PPMSJrnlNetPay 600c: Set : PPMSJrnlNetReim : $PPMSJrnlNetReim 601c: Set : PPMSJrnlSalCheqNo : $PPMSJrnlSalCheqNo 602c: Set : PPMSJrnlReimCheqNo: $PPMSJrnlReimCheqNo 620 : If : ##PPMSJrnlReimCheqNo ! = $$Number:0 622 : Insert Collection Object : BANKALLOCATIONS 624 : Set Target : BANKALLOCATIONS 626 : SET VALUE : DATE : @@PPMSJrnlDate 628 : SET VALUE : INSTRUMENTDATE : @@PYCheqDt 630 : Set Value : Name : $$MakeUniqueID 631 : Set Value : UNIQUEREFERENCENUMBER : $$MakeUniqueID 632 : SET VALUE : TRANSACTIONTYPE : "Cheque";;##PYTransType 634 : SET VALUE : PAYMENTFAVOURING : ##PPMSJrnlEMPNAME 636 : SET VALUE : INSTRUMENTNUMBER : ##PPMSJrnlReimCheqNo 638 : Set Value : PAYMENTMODE : "Transacted" 640 : Set Value : BANKPARTYNAME : #PPMSLederHead 642 : SET VALUE : CHEQUECROSSCOMMENT: "A/c Payee" 644 : SET VALUE : STATUS : "No" 648 : SET VALUE : AMOUNT : ##PPMSJrnlNetReim 650 : Set Target : .. 652 : End If 654 : End Walk 656 : End Walk
Dear D Lokesh I have Tried above suggested, not yet achieved result, can u check it with tally.erp 9 rel 4.93, 32bit. Regards
Dear experts can you plz check why Bank Allocation does not getting imported 120 : NEW OBJECT : Voucher 014 : LOG : " Voucher Details : " + $PVVchrDate +" " + $PVDrLedger +" " + $PVDrAmount +" " + $PVCrLedger +" " + $PVDrAmount +" " + $PVNarration +" " + $PVChqNo ;+ $$Date@CHQDATE 130 : SET VALUE : Date : @@PVVchrDate 140 : SET VALUE : VoucherTypeName : $$VchTypePayment 150 : Set Value : PARTYLEDGERNAME : ##PVCrLedger 155 : Set Value : NARRATION : ##PVNarration 160 : SET VALUE : ISINVOICE : No 170 : Insert Collection Object: Ledger Entries 180 : SET TARGET : LedgerEntries 190 : SET VALUE : LEDGERNAME : ##PVDrLedger 200 : SET VALUE : Amount : ##PVDrAmount 210 : SET VALUE : ISDEEMEDPOSITIVE : "Yes" 220 : Set Target : .. 230 : Insert Collection Object: Ledger Entries 240 : SET TARGET : LedgerEntries 250 : SET VALUE : LEDGERNAME : ##PVCrLedger 260 : SET VALUE : Amount : ##PVDrAmount 265 : SET VALUE : ISDEEMEDPOSITIVE : "No" 330 : SET VALUE : PersistedView : ##SVViewName 800 : Insert Collection Object : Bank Allocations ; 324 : Set Target : BANKALLOCATIONS 802 : SET VALUE : Date : $$Date@PVCHQDATE 803 : Set Value : INSTRUMENTDATE : $$Date@PVCHQDATE 804 : Set Value : Name : $$MakeUniqueID 805 : SET VALUE : TRANSACTIONTYPE : "Cheque" 806 : Set Value : PAYMENTFAVOURING : "Cash" 807 : Set Value : CHEQUECROSSCOMMENT : "A/c Payee" 808 : SET VALUE : INSTRUMENTNUMBER : ##PVChqNo 809 : SET VALUE : UNIQUEREFERENCENUMBER : $$MakeTallyUniqueID 810 : SET VALUE : STATUS : No 811 : Set Value : PAYMENTMODE : "Transacted" 812 : Set Value : BANKPARTYNAME : ##PVDrLedger 813 : Set Value : ISCONNECTEDPAYMENT : No 814 : Set Value : ISSPLIT : No 815 : Set Value : ISCONTRACTUSED : No 816 : Set Value : ISACCEPTEDWITHWARNING : No 817 : Set Value : ISTRANSFORCED : No 818 : Set Value : AMOUNT : ##PVDrAmount ;($$AsAmount:##PVDrAmount) *-1 819 : Set Target : .. 340 : CREATE TARGET 350 : SHOW PROGRESS : ##ProgressCount 360 : SET : ProgressCount : ##ProgressCount + 1 380 : END WALK 385 : Increment : Counter 072 : Log : "-------------------------------------------------------" 390 : Msg Box : "Status" : "Payment Vouchers Imported \n successfully!!! " 074 : SET FILE LOG OFF 075 : EXEC COMMAND : "TDLFunc.Log" 370 : End If 400 : Return