Qr Code Generator for Tally (dll)

Discussion in 'Tally Integration' started by teja varma, Oct 12, 2019.

    
  1. teja varma

    teja varma Active Member


    Hello Everyone,
    I created a dll which use to generate qr code for the invoice , it contains invoice number , invoice amount and GSTIN

    You can use this as reference and modify the tdl according to your needs

    here is the project link you can download all the files
    https://github.com/tejavarma-aln/Qrcodegenerator

    follow the instructions in readme file to get started

    post here if you face any extremity
     


  2. sattam

    sattam Active Member



  3. Murali.R

    Murali.R Member


    i am facing problem in cmd enable , Please sollution sir
    upload_2019-10-13_10-22-44.png
     


  4. teja varma

    teja varma Active Member


    follow these steps:
    1) download these files (OpenQrgenerator.dll ,Qrcode.dll , Qrcode.txt) and put them in the Tally File location

    2)Open Cmd in administrator Mode (Elavated mode)

    3)CD C:\Windows\Microsoft.NET\Framework64\v4.0.30319 ;; change directory

    4)Type without quote "regasm OpenQrgenerator.dll /codebase" ;;Full path to the OpenQrgenerator.dll file

    5)you will get success message after it registered

    6) Load Qrcode.txt tdl in Tally

    7)Make an Invoice and Print it ;;; you will see Qrcode at top of the Invoice

    ** Note all files Must be in Tally Application Directory;;;;
     
    Last edited: Dec 5, 2019


  5. teja varma

    teja varma Active Member


    you need give full path of OpenQrgenerator.dll

    ex: path\to\the\OpenQrgenerator.dll

    and also make all the downloaded files are in the Tally File location
     
    Last edited: Jan 20, 2020


  6. teja varma

    teja varma Active Member


    you need to Start Command Prompt In Admin mode
    go to start menu -> type cmd -> right click on cmd->choose Run as Administrator

    and follow the steps mentioned above
     


  7. Murali.R

    Murali.R Member


    in tally , but not come image in invoice
     


  8. Murali.R

    Murali.R Member


    in tally , but not come image in invoice
     


  9. Murali.R

    Murali.R Member


    ok thanks sir,
    its work
     


  10. Jay kumar tailor

    Jay kumar tailor Well-Known Member



  11. pravin bhau

    pravin bhau New Member


    QRimg.jpg file not generating nor printing...plz tell me the issue
     


  12. teja varma

    teja varma Active Member


    please put the error screen shot that appears in the calculator panel while executing
     


  13. pravin bhau

    pravin bhau New Member


    QR Code Not Shown on Invoice Nor Generation

    upload_2019-12-5_11-43-47.png

    upload_2019-12-5_11-22-3.png
    upload_2019-12-5_11-29-12.png






    upload_2019-12-5_11-21-35.png




    [COM Interface:Qrinterface]

    Project:OpenQrgenerator
    Class:Class1
    Interface:GenerateQr
    Parameter:p1:String:In
    Return:String


    [#Form:Comprehensiveinvoice]
    Delete : Parts
    Delete : Bottom Parts

    Add:parts:At Beginning:Qrcodepart
    On:print:Yes:Call:Qrengine

    [System:Formulas]
    Qraccount:$BankDetails:Ledger:mad:@VchBankName
    Qrifsc:$IFSCode:Ledger:mad:@VchBankName
    Qrbank:mad:@VchBankMailingName


    [Function:Qrengine]
    Variable:billamount:String:$$String:$Amount
    Variable:billnumber:String:$$String:$VoucherNumber
    Variable:billdate:String:$$String:$Date
    Variable:billaccount:String:$$String:mad:@Qraccount
    Variable:billifsc:String:$$String:mad:@Qrifsc
    Variable:billbank:String:$$String:mad:@Qrbank
    Variable:Qrdata:String:"Bill no-"+##billnumber +","+"Amount-"+ ##billamount +"," +"Date-" +##billdate + "," +"Bank Ac-"+ ##billaccount +"," +"Ifsc-" + ##billifsc +"," +"Bank-" + ##billbank

    01:Exec COM Interface:Qrinterface:##Qrdata
    02:Log:$$LastResult



    [Part:Qrcodepart]
    Graph Type:"Qrimg.jpg"
    Height:5
    Line:Expinvlogo
    ;Invisible:Not $globalqrpath:Company:##Svcurrentcompany

    [#Part:CMP TallyShop F11]
    Add:part:after:CMP TallyShopFeaturesTitle:Qrcodeconfig

    [Part:Qrcodeconfig]
    Line:Qrenableconfig

    [Line:Qrenableconfig]
    Space Top:0.2
    Field:MediumPrompt,Qrlogic
    Local:Field:MediumPrompt:Set as:$$LocaleString:"Enable Qr code?"

    [Field:Qrlogic]
    Use:Logical Field
    Set as:No
    Show Table:Always
    Storage:globalqrpath

    [System:UDF]
    globalqrpath:Logical:7895
     

    Attached Files:

    Last edited: Dec 5, 2019


  14. teja varma

    teja varma Active Member


    you are registering wrong dll file
    you have to register OpenQrgenerator.dll file not Qrcoder.dll
     


  15. teja varma

    teja varma Active Member


    fallow these steps
     


  16. pravin bhau

    pravin bhau New Member


    T
    Thanks ...It Works
     


  17. Deepak Sharma (KNP)

    Deepak Sharma (KNP) New Member



    WELL DONE
     


  18. MithunN

    MithunN Member


    well done sir.
    it's generating the QR code that is fine but i am facing refresh issue.
    consider i have 2 sales transactions. then for 1st invoice ill take the print out then ill get the QR code in invoice again i have go to the another voucher and ill print that invoice in this print also ill get the qr code. if i scan that QR code means ill get the 1st transactions details how to solve this issue.
     


  19. teja varma

    teja varma Active Member


    let me check that one, i will here update if there is a patch
     


  20. MithunN

    MithunN Member


    thank you so much sir.
     


  21. lumos

    lumos Member


    Read the last line in your image.
     


  22. lumos

    lumos Member


    Make sure you have put the files in tally directory, Loaded the tdl file and your invoice format is set to comprehensive Not Simple.
     


  23. teja varma

    teja varma Active Member


    did you get any errors in the calculator panel, if then post the screenshot of the error
     


  24. teja varma

    teja varma Active Member


    you can troubleshoot these options:
    1)check weather tcp is loaded or not
    2)disable all other TDL's for better troubleshooting
    3)check weather Qrimage.jpg is creating in tally directory or not while giving print
    4)make sure you downloaded all the files Openqrgenerator.dll,Qrcoder.dll,Qrcode.txt(tdl)
    5)make sure all files are placed in tally working directory
    ex: D:\TallyERP9
     



  25. I am getting this error
     

    Attached Files:



Share This Page