Announcement Announcement module
Collapse
No announcement yet.
Conversation Detail module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts
  • xs_avatar
    Pearl Member
    • Feb 2013
    • 15

    Two TDL INVoce Format for One Tally

    #1
    Dear Sir
    We have Use Two Separate Excise Invoice Format for Excise Invoice we have use one tally but two different types of companies
    How to control two tdl fine with different company any voucher type or other option
    Pls following Two type Code


    Code:1
    [#Form: ExciseMfgr Invoice]
    Delete : Parts : ExciseMfgrInv OpPageBreak, ExciseMfgr InvoiceDtls, EXPINV Jurisdiction, EXPINV InvoiceCompGen
    Add : Parts : SSPLTop, SSPLCMPName, SSPLCMPTax, SSPLParty, SSPLBody

    [Part : SSPLTop]
    Parts : SSPLInv Title

    Code: 2
    [#Form: ExciseMfgr Invoice]
    Delete : Part
    Add : Parts : STDInvoiceTop, ComTop, PujaTop, PujaBuyer,ExciseMfgrInv Column, PujaInvoiceDtls

    [Report : Puja Invoice]
    Use : Printed Invoice
    Delete : Form
    Add : Form : Puja Invoice
    Print set : Report Title : "Puja Group"

    [Form : Puja Invoice]
    Use : STD Invoice Dimensions
    Height : 300 mms
    Width : 260 mms
    Space Bottom: 1
    Space left: 2

    [Part :ComTop]
    width : 260 mms
    Part : PujaHTop

  • xs_avatar
    Pearl Member
    • Jun 2013
    • 11

    #2
    Dear Sada

    it can be done through Option class.

    Form ExciseMfgr Invoice consists option already. So you need to delete the option and add it with your company filter / system Variable

    Go through Sample


    [System: Formula]


    SysCompName : ##SvcurrentCompany = "Demo Company"





    [#Form: ExciseMfgr Invoice]


    Delete : Parts : STDInvoiceTop, TraderInv OpPageBreak, EXPINV Jurisdiction, EXPINV InvoiceCompGen


    Delete : Option


    add : Option : Comp1 : @@SysCompName


    add : Option : Comp2 : Not @@SysCompName



    [!Form : Comp1]


    Add : Parts : SSPLTop ;;, SSPLCMPName, SSPLCMPTax, SSPLParty, SSPLBody





    [Part: SSPLTop]


    Line: SSPLTopLn


    [Line: SSPLTopLn]


    Field : SSPLTopFld


    [Field : SSPLTopFld]


    Use : Name Field


    Set as : "My Demo Company 1"





    [!Form : Comp2]


    Delete : Part


    Add : Parts : STDInvoiceTop, ComTop ;;, PujaTop, PujaBuyer,ExciseMfgrInv Column, PujaInvoiceDtls


    [Part: ComTop]


    Line: ComTopLn


    [Line: ComTopLn]


    Field : ComTopFld


    [Field : ComTopFld]


    Use : Name Field


    Set as : "Other than Demo Company - 2"


    Comment


    • xs_avatar
      Pearl Member
      • Feb 2013
      • 15

      #3
      Thank you [URL="http://td9.tallysolutions.com/vbulletin/member/492-arockia"]Arockia[/URL="http://td9.tallysolutions.com/vbulletin/member/492-arockia"] sir
      for guide me
      i try as per your suggestion if i get any problem i contact you
      thanks again

      Comment


      • xs_avatar
        Pearl Member
        • Jun 2013
        • 11

        #4
        Sadarkhan

        Is it Successful ?

        Comment


        • xs_avatar
          Pearl Member
          • Feb 2013
          • 20

          #5
          Dear expert

          Please help me to solve my problem of two invoice format. I have two voucher type in one company for which I want seperate invoice format. If the voucher type name is Tax on MRP then print Mrp Invoice and if the voucher type name is Tax Invoice then print Tax Invoice.

          I tried but could not get result. please help me.

          Comment


          • xs_avatar
            Pearl Member
            • Jun 2013
            • 11

            #6
            You can Modify the Comprehensive Invoice by adding optional Print Form as below

            [#Form: Comprehensive Invoice]
            Add : Option : TaxInvoice : @@TaxInvoice
            Add : Option : MRPInvoice : @@MrpInvoice

            [System: Formula]
            TaxInvoice : $Vouchertypename = "Tax Invoice"
            MrpInvoice : $Vouchertypename = "MRP Invoice"

            Design your Form as per requirement.
            Existing Parts, Option and Page break are applicable based on existing conditions.

            Hard coding system formula not preferable.

            Last edited by Arockia; 12th June 2013, 18:19.

            Comment


            • xs_avatar
              Pearl Member
              • Feb 2013
              • 15

              #7
              Dear [URL="http://td9.tallysolutions.com/vbulletin/member/492-arockia"]Arockia[/URL="http://td9.tallysolutions.com/vbulletin/member/492-arockia"] Ji

              I try to code as per your suggestion but there is some problem in my codding
              pls can to solve the problem in my code and suggest me where i am wrong
              pls code in following

              [System: Formula]
              SysCompName : ##SvcurrentCompany = "Demo Company"

              [#Form: ExciseMfgr Invoice]
              Delete : Parts
              Add : Parts : STDInvoiceTop,ComTop, CMPParty
              Delete : Option
              Add : Option : NKP Invoices : @@SysCompName
              Space Top : 70 mms
              Space Left : 18 mms

              [Report: NKPInvoice]
              Use : Printed Invoice
              Delete : Form
              Form : NKP Invoices
              Print Set : Report Title : "Excise Invoice"

              [Form: NKP Invoices]
              Use : STD Invoice Dimensions
              Space Top : 5
              Height : 274 mms
              Width : 500 mms

              [Part: ComTop]
              Part : CMPLeft, CMPRight
              Border : Thin Top Bottom
              Width : 275 mms

              [Part: CMPLeft]
              Lines: NKPPrep, NKPRemoval
              Width : 137 mms

              [Line :NKPPrep]
              Field : Medium Prompt,NKPPrep
              Local : Field : Medium Prompt : Set as : "Invoice Preparartion Date & Time :"
              Local : Field : Medium Prompt : Fullwidth : Yes
              Local : Field : Medium Prompt : Style : NormalTime

              [Field : NKPPrep]
              setas : $BasicDateTimeOfInvoice
              Fullwidth : yes
              align : left
              style : NormalTimeBold

              [Line :NKPRemoval]
              Field : Medium Prompt,NKPRemoval
              Local : Field: Medium Prompt : Set as : "Removal Date & Time :"
              Local : Field : Medium Prompt: Fullwidth: Yes
              Local : Field : Medium Prompt : Style : NormalTime

              [Field : NKPRemoval]
              setas : $BasicDateTimeOfRemoval
              Fullwidth : yes
              align : left
              style : NormalTimeBold

              [Part: CMPRight]
              Lines: NKPInvono, NKPInvoDate
              Width : 137 mms

              [Line :NKPInvono]
              Field : Medium Prompt,NKPInvono
              Local : Field: Medium Prompt : Set as : "C.Excise Invoice No :"
              Local : Field : Medium Prompt: Fullwidth: Yes
              Local : Field : Medium Prompt : Style : NormalTime

              [Field : NKPInvono]
              setas : $voucherNumber
              Fullwidth : yes
              align : left
              style : NormalTimeBoldLage

              [Line : NKPInvoDate]
              Field : Medium Prompt,NKPInvoDate
              Local : Field : Medium Prompt : Set as : "C.Excise Invoice Date :"
              Local : Field : Medium Prompt: Fullwidth: Yes
              Local : Field : Medium Prompt : Style : NormalTime

              [Field : NKPInvoDate]
              Set as : $Date
              Fullwidth : yes
              Style : NormalTimeBoldLage
              Align : Left

              ;================================================= ==================================
              [Part: CMPParty]
              Part : CMPPartyLeft
              Right Part : CMPyPartyRight
              Width : 274 mms

              [Part: CMPPartyLeft]
              Lines : CMPPartyBuyerTitle, CMPPartyBuyerName, CMPPartyBuyerAddress
              Bottom Line : CMPPartyBuyerECC,CMPPartyBuyerTin
              Repeat : CMPPartyBuyerAddress : Address
              Width : 137 mms
              Border : Full Thin Bottom Right

              [Line: CMPPartyBuyerTitle]
              Field : Name Field
              Local : Field : Name Field : Set as :"Name & Address of Buyer :"
              Local : Field : Nmae Field : Full Width : Yes
              Local : Field : Name Field : Style : NormalTimeBold

              [Line: CMPPartyBuyerName]
              Field : Name Field
              Local : Field : Name Field : Set As : @@InvPartyName
              Local : Field : Name Field : Full Width:Yes
              Local : Field : Name Field : Style : NormalTimeBoldLage

              [Line: CMPPartyBuyerAddress]
              Field : Name Field
              Local : Field : Name Field : Set As : $Address
              Local : Field : Name Field : Fullwidth : Yes
              Local : Field : Name Field : Style : NormalTime

              [Line: CMPPartyBuyerECC]
              Fields : Medium Prompt, CMPPartyBuyerEccNo
              Local : Field : Medium Prompt : Set As : $$LocaleString:"Excise Regn No." + ":"
              Local : Field : Medium Prompt : Style : NormalTime
              Local : Field : Medium Prompt : Width : 30% Page

              [Field: CMPPartyBuyerEccNo]
              Use : Name Field
              Set As : $TraderSuppExciseRegnNo
              Style : NormalTime
              Full Width : Yes

              [Line: CMPPartyBuyerTin]
              Fields : Medium Prompt, CMPPartyBuyerSTNo
              Local : Field : Medium Prompt : Set As : $$LocaleString:"VAT TIN" + ":"
              Local : Field : Medium Prompt : Style : NormalTime
              Local : Field : Medium Prompt : Width : 30% Page

              [Field: CMPPartyBuyerSTNo]
              Use : Name Field
              Set As : $TraderConsVATTINNo
              Style : NormalTime
              Full Width : Yes

              [Part: CMPyPartyRight]
              Lines : CMPPartyConsTitle, CMPPartyConsName, CMPPartyConsAddress
              Bottom Line : CMPPartyConsECC,CMPPartyConsTin
              Repeat : CMPPartyConsAddress : BasicBuyerAddress
              Border : Thin Bottom
              Width : 137 mms

              [Line: CMPPartyConsTitle]
              Field : Name Field
              Local : Field: Name Field : Set as: "Delivery at / Consignee :"
              Local : Field : Nmae Field : Full Width : Yes
              Local : Field : Name Field : Style : NormalTimeBold

              [Line: CMPPartyConsName]
              Field : Name Field
              Local : Field : Name Field : Set As : If ##ICFGSupplementary Then $BasicBuyerName Else +
              If ##ICFGDefaultDet Then $MailName:Ledger:$PartyLedgerName Else $PartyLedgerName
              Local : Field : Name Field : Full Width:Yes
              Local : Field : Name Field : Style :NormalTimeBoldLage

              [Line: CMPPartyConsAddress]
              Field : Name Field
              Local : Field : Name Field : Set As : If ##ICFGSupplementary Then $BasicBuyerAddress Else $Address
              Local : Field : Name Field : Fullwidth : Yes
              Local : Field : Name Field : Style : NormalTime

              [Line: CMPPartyConsECC]
              Fields : Medium Prompt, CMPPartyConsigEccNo
              Local : Field : Medium Prompt : Set As : $$LocaleString:"Excise Regn No." + ":"
              Local : Field : Medium Prompt : Style : NormalTime
              Local : Field : Medium Prompt : Width : 30% Page

              [Field: CMPPartyConsigEccNo]
              Use : Name Field
              Set As : $TraderConsExciseRegnNo
              Style : NormalTime
              Full Width : Yes

              [Line: CMPPartyConsTin]
              Fields : Medium Prompt, CMPPartyConsigSTNo
              Local : Field : Medium Prompt : Set As : $$LocaleString:"VAT TIN" + ":"
              Local : Field : Medium Prompt : Style : NormalTime
              Local : Field : Medium Prompt : Width : 30% Page

              [Field: CMPPartyConsigSTNo]
              Use : Name Field
              Set As : @@BuyerTaxNumMfgr
              Style : NormalTime
              Full Width : Yes

              ;================================================= ================================================== =

              Comment

              Working...
              X