Qr Code in Sales - scan to make payment with UPI payment apps

Discussion in 'Tally Integration' started by teja varma, Jul 4, 2020.

    
  1. teja varma

    teja varma Active Member


    Hello Everyone,
    1) With this TDL Qr Code will be generated in Sales Invoice
    2) You can scan to make payment
    3) All UPI payment apps are supported - Gpay Bhim,Phone Pey,etc..

    Get Started:
    1) Download all the files from the below link
    2) Register the DLL (PaymentsQr.dll)
    3) Load the tcp in Tally (Payment Qr.tcp)
    4) Goto->f11->Accounting features->Enable Qr Code in Sales(at last)
    5) Enter Payment Mode (you like to receive through)
    6) And Enter the Information it asked (Make sure all details are valid)
    7) Then go and create/display a sales invoice
    8) You will find a button (Generate Qr Code) Click on that Button to generate Qr Code (Don't forget) - Not needed everytime
    9) Success Message will be Shown in Calculator Panel
    10) Now Print the invoice , Qr Code will be displayed at Payment Terms Box (if everything is okay)

    Link to Download Files :
    https://github.com/tejavarma-aln/QrCodeForPayments-Compiled

    **Read the README File in the above link and read the steps to Register the DLL

    **Qr code will not be shown in Customized invoice

    Thank you
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Very Good Utility and good work Mr. Teja...........
     


  3. akaash kapoor

    akaash kapoor New Member


    Amazing work sir! The QR code shows up in the invoice and scans successfully! The only issues is that the QR code is displayed in plce of terms of delivery and replaces it.
    Can the TDL be modified to place the QR CODE in place of customers seal and signature?
     


  4. teja varma

    teja varma Active Member


    Yes
    We will soon release open-source version
    in that you have to write tdl as per your needs
     


  5. akaash kapoor

    akaash kapoor New Member


    Sounds perfect. if I get the open code, then i'll be able to write the tdl accordingly. Great work though! Thanks.
     


  6. Rizwan

    Rizwan New Member


    Error - Com Interface is not invokable getting this error
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It means you have not copied BOTH the dll files in the appropriate folder. Follow the instructions carefully.
     


  8. teja varma

    teja varma Active Member


    ->Here is the sample code which shows how to work with QRcode dll and its usage
    ->You can modify the code according to your needs

    Code:
    [#Form:Sales Color]
        Add:Button:GenerateQR
    
    [#Part: EXPINV Terms]
      Delete:Lines
      Delete:Parts
      Delete:Repeat
      Delete:Invisible
      Add:Graph Type:(@@QrFileDir+"\"+@@QrFileName+".jpg")
      Add:Height:8
      Add:Line:EXPINV Logo
       
    [Button:GenerateQR]
        Title:Generate QrCode
        Key:CTRL+G
        Action:Call:InitQrCodeGeneration
     
    
    [Function:InitQrCodeGeneration]
     
        01:Exec COM Interface:ExecuteQrEngine:@@QrData:@@QrFileDir:@@QrFileName
        02:Log:$$LastResult
    
    [COM Interface:ExecuteQrEngine]
        Project:PaymentsQr
        Class:QrClass
        Interface:GenerateQr
        Parameter:p1:String
        Parameter:p2:String
        Parameter:p3:String
        Return:String
    
    [System:Formula]
        QrFileName:"QrImage" ; replace with file name you want
        QrFileDir:"G:\Tally.ERP9\QrImages" ; replace with directory you want
        QrData:"upi://pay?pa=123456789@ybl&pn=payee&mc=0000&tr=bill_payer&tn=bill_payer_Pay%20to%20payee&am=&mam=0&cu=INR"
    
    ;(123456789@ybl - replace with your upi id)
    ; if you want amount to be included set (am=amount) in QrData ;
    ; you can add payee name (pn=payeename)
    ; you can change currency if you want (cu=INR)
    ; you can show the QR image wherever you want by using graph type in the part level
    
    
     
    Last edited: Oct 11, 2020
    gangstar and Vikram Bhat like this.


  9. amitkjangid

    amitkjangid New Member


    When entered 15 digit PNB account number showing error.
     


  10. teja varma

    teja varma Active Member


    Post the Qr Code image
    for analyzing the issue
     


  11. amitkjangid

    amitkjangid New Member


    No Sir. Error Show when enter 15 digit account number and ifsc code See the image Whats error ?
     

    Attached Files:



  12. teja varma

    teja varma Active Member


    there is no error here
    the red line is hint line which is the default, don't think it as an error
    and why the account number is decimal and negative
     
    Last edited: Aug 27, 2020


  13. amitkjangid

    amitkjangid New Member


     
    Last edited: Aug 27, 2020


  14. amitkjangid

    amitkjangid New Member


    your QR code takes only 14 digit account number. When enter 15 digit or above in account number its convert automatically decimal and negative.
     


  15. teja varma

    teja varma Active Member


    okay then leave that TCP and develop custom one according to your needs
    I already posted above regarding how it works and how one can develop their own TDL
     


  16. akaash kapoor

    akaash kapoor New Member


    Whenever i am scanning the QRCODE from an application like PAYTM the error message shows ref-id length invalid and even googlepay doesnt work and shows an error. Only phone pay is working. What can be the reason for this error?
     


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Read the remarks at the bottom of the Code.

    Above is meant as a sample data. User can change the values in QRDATA as per their needs.
     


  18. akaash kapoor

    akaash kapoor New Member


    Hello Sir. I am talking about the issues with the TCP file shared at the begining of the thread. I guess you are talking about the open source code shared later on.
     


  19. teja varma

    teja varma Active Member


    post the Qr image which was generated by DLL
    so we can decode and see where went wrong
     


  20. akaash kapoor

    akaash kapoor New Member


    Can you please send me a mail on akash.kap1991@gmail.com or tell me your E-mail ID here so that i can share the code? Whatever is convenient for you.
     
    Last edited: Oct 14, 2020


  21. teja varma

    teja varma Active Member



  22. akaash kapoor

    akaash kapoor New Member


    The QR code has been sent to your mail. Please Check.
    Regards.
     


  23. Sanjay Manna

    Sanjay Manna Member


    please send the code my mailid- smannapampa@gmail.com
     


  24. harsh sachdeva

    harsh sachdeva New Member


    Sir I have completed the Payment Qr Code for Invoice Print Now i want To print it in Ledger Voucher beside bank detail I m attaching the screenshot where i want to locate plz guide me sir
     

    Attached Files:



  25. Samiksha

    Samiksha New Member


    Just as you have added details at the bottom, add the code for QR alongside.
     


Share This Page