While Importing excel to tally (Payment & Rpt.) getting error "Proper Pay link Name not given for "

Discussion in 'Tally Developer' started by Jaffar Sha, Apr 23, 2015.

    
  1. Jaffar Sha

    Jaffar Sha New Member


    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
     


  2. Jaffar Sha

    Jaffar Sha New Member


    I herewith attached the code.
     

    Attached Files:



  3. admin

    admin Administrator Staff Member


    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
     


  4. Nirav Merchant

    Nirav Merchant Active Member


    hi just chk the ENDIF.. it shd be together.. No space in between. Shd solve ur problem.
     


  5. Ragavan

    Ragavan New Member


    C
    Can u Share the excel template
     


  6. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    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
     


  7. D Lokesh

    D Lokesh Member


    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
     
    gangstar and Ragavan like this.


  8. Ragavan

    Ragavan New Member


    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
     


  9. Nirav Merchant

    Nirav Merchant Active Member


    Just Remove Space Between ENDIF.. i think will solve the problem of Error u mentioned
     


  10. stechsundar

    stechsundar New Member


    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
     
    Ragavan likes this.


  11. HVPatel

    HVPatel Active Member


    Dear Experts,
    I need to import payment / Receipt with Multiple Bank Allocation, any one have idea, please share.
    Thanks

     


  12. D Lokesh

    D Lokesh Member



    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


     


  13. HVPatel

    HVPatel Active Member


    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
     



  14. 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:mad:@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:mad:@PVCHQDATE
    803 : Set Value : INSTRUMENTDATE : $$Date:mad:@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
     


Share This Page