PRINT MSME REG.NUMBER IN INVOICE PRINT

Discussion in 'Free Source Codes' started by ONKAR, Jul 26, 2019.

    
  1. ONKAR

    ONKAR Active Member


    By Member Request @tejeet , so check this code, this can print your company MSME Reg.no or also party MSME Reg.no in invoice print

    SEE THIS IMAGE NO. 1 THIS IS PARTY LEDGER CREATION, SO YOU CAN ENTER YOUR PARTY MSME REG.NO.

    Capture.JPG


    SEE THIS IMAGE NO. 2 THIS IS YOUR COMPANY MSME REG.NO. IN COMPANY FEATURES SCREEN

    Capture 2.JPG
    AND SEE THIS IMAGE NO. 3 THIS IS INVOICE PRINT, IN THIS INVOICE PRINT SEE YOUR COMPANY MSME NUMBER AND ALSO PARTIES MSME NUMBER

    Capture 3.JPG


    SEE THIS CODE,

    ;;;---
    [#Part: CMP Tax Info]

    Add : Line : At End : CMP MsmeNoTL

    [Line: CMP MsmeNoTL]

    Right Field : Medium Prompt
    Local : Field : Medium Prompt : Set as : "Msme Reg. No. :"
    Option : Small Size Line
    Space Top : 0.4

    [#Part: CMP Tax Value]

    Add : Line : At End : CMP MsmeNoVAL

    [Line: CMP MsmeNoVAL]

    Field : Name Field
    Local : Field : Name Field : Storage : CMPMsmeNoVAL
    Local : Field : Name Field : Full width : Yes
    Local : Field : Name Field : Max : 200
    Local : Field : Name Field : Line : 2
    Option : Small Size Line
    Space Top : 0.4


    [#Part: LED Other Details]

    Add : Lines : At End : LED MsmeNo

    [Line: LED MsmeNo]

    Fields : Medium Prompt, LEDMsmeNo
    Local : Field : Medium Prompt : Set as : $$LocaleString:"Msme Reg.No :"
    Invisible : NOT @@IsIndian



    [Field: LED MsmeNo]

    Use : Name Field
    Storage : LEDMsmeNo
    Full width : YEs
    Line : 2
    Max : 200

    [#Part: EXPINV SaleSalesTax]
    ;;[#Part:EXPINV VATDetails]
    Add : Lines : AT END : SalesHCmpMsmeno,SalesBuyerMsmeno

    Line: SalesHCmpMsmeno

    [Line: SalesHCmpMsmeno]

    Space Top : 0.05
    Field : Short Prompt,Name Field
    Local : Field : Short Prompt : Set As : "Our Msme Reg. No.:"
    Local : Field : Name Field : Set As : $CMPMsmeNoVAL:Company:##SVCurrentCompany
    Local : Field : Name Field : Full width : Yes
    Local : Field : Name Field : Style : Normal

    [System: UDF]

    CMPMsmeNoVAL : String : 21110
    LEDMsmeNo : String : 21111


    [Line: SalesBuyerMsmeNo]

    Field : Short Prompt ,Name Field
    Local : Field : Short Prompt: Set As : "Party Msme Reg. No.:"
    Local : Field : Name Field : Set As : $LEDMsmeNo:Ledger:$PartyLedgerName
    Local : Field : Name Field : Full width : Yes
    Local : Field : Name Field : Style : Normal
     


  2. tejeet

    tejeet Member


    THANK YOU VERY MUCH MR. OMKAR
     
    Frz and ONKAR like this.


  3. ONKAR

    ONKAR Active Member


    have a good day bro, keep always happy and helps others
     


  4. Rajsrisrimal

    Rajsrisrimal Member


    Great work, Nice
     


  5. Varadharaj

    Varadharaj New Member



    Hi, MSME no. disappears after closing tally, any fix found?
     


  6. Kishor Choudhary

    Kishor Choudhary New Member


    Please help me tally invoice add me msme number
     


  7. Javed Akhter

    Javed Akhter New Member


    Omkar ji, I am getting Error T0008 could not found the default TDL definition of Part CMP Tax Info, Pl suggest a solution, I am using Tally Prime
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Part CMP Tax Info is not available in PRIME.......... so you need to find the appropriate name for PRIME and use it.
     


  9. Bipin Damania

    Bipin Damania Active Member


    In Tally Prime...

    Company Detail.
    CMPDetailReport3A.jpg


    Party Detail.
    CMPDetailReport3B.jpg

    In Invoice.
    CMPDetailReport3C.jpg
     
    Rajsrisrimal likes this.


  10. Javed Akhter

    Javed Akhter New Member


    @bipin ji can you pl share code for this
     


  11. Rajsrisrimal

    Rajsrisrimal Member


    sir,
    Can we get this TDL
     


  12. DEEPAK B

    DEEPAK B Member


    Sir Can I get this TDL Please
     


  13. DEEPAK B

    DEEPAK B Member


    I have changed this above code and its printing fine but I do not want the MSME Number to print at the bottom of address line (see Image 1). I want to print this at the Right side of the Last Line in the address (See Image 2). Help me with this

    Code:
          [#Part: Company MailingDtlsAddress]
                ADD        : BOTTOM LINE        : AT END        : AURUEM CMP MSME Number
       
            [ Line: AURUEM CMP MSME Number ]
                FIELDS            : MEDIUMPROMPT , CMP MSME NUMBER
                LOCAL            : FIELD    : MEDIUMPROMPT        : SET AS    : $$LOCALESTRING:"COMPANY MSME NUMBER"
                LOCAL            : FIELD    : MEDIUMPROMPT        : WIDTH    : 30
    ;;            LOCAL            : FIELD    : DEFAULT            : COLOR    : DARK VIOLET
                LOCAL            : FIELD    : DEFAULT            : COLOR    : BLUE
            [ FIELD                : CMP MSME NUMBER ]
                USE                : NAME FIELD
                STORAGE            : CMPMSMENUMBERUDF
            [ SYSTEM                : UDF ]
                CMPMSMENUMBERUDF    : STRING        : 3
            [ #PART            : EXPINV Company ]
                ADD            : LINES            : AT END        : COMPANYMSMELICNO
            [ LINE            : COMPANYMSMELICNO ]
                FIELD        : MEDIUM PROMPT ,NAME FIELD
                LOCAL        : FIELD        : MEDIUM PROMPT        : SET AS        : "MSME NUMBER"
                LOCAL        : FIELD        : NAME FIELD        : SET AS        : $CMPMSMENUMBERUDF:company:##svcurrentcompany
    
     

    Attached Files:



  14. subash pal

    subash pal Member


    How Can prevent duplicate Ledger Through Msme Reg. No. or How Can Msme Reg. Make Unique It Not Accept if already Entered with another ledger.
     


  15. Rajeshaga90

    Rajeshaga90 New Member


    Hi

    The last TDL code by @Mr Deepak B is working fine but in the case of the 10 companies data is maintained in the same tally data folder where only 2 companies had MSME numbers and the rest are not registered, but in all those cases on the sale invoice of all those companies had "MSME number printed on sales bill as blank". How short this issue ?
    upload_2023-2-7_12-16-50.png
     


  16. Rajsrisrimal

    Rajsrisrimal Member



Share This Page