I Have Customized a new invoice request you to help me further

Discussion in 'Tally Developer' started by vinayprasad.Dubai, Nov 4, 2018.

    

  1. i have tried my best but i am stuck please help me to fetch bank details in the in invoice and discount and vat value is not coming please help me

    thank you in advance
     

    Attached Files:



  2. sattam

    sattam Active Member


    For ac name, set as:$BankAccHolderName:Ledger:mad:@VchBankName
    For ac no , set as:$BankDetails:Ledger:mad:@VchBankName
    For Bank name, set as:If NOT $$IsEmpty:mad:@VchBankMailingName Then @@VchBankMailingName Else ##SABankName
    For Bransch & Ifsc, set as:If $$IsEmpty:mad:IFSCode Then @BranchName Else +
    If $$IsEmpty:mad:BranchName Then @IFSCode Else $$Sprintf:"%s & %s":mad:BranchName:mad:IFSCode
     



  3. thank you so much i will try this
     




  4. sattam

    sattam Active Member


    bro delete "mad:" where u just copy paste
     



  5. Code:
    [Part: Bottom2]
       
    Lines: GEN Payment Terms, GEN Payment Mode, GEN Account Name, GEN Account No., GEN Bank name, +
    GEN Swift Code , GEN IBAN, GEN Accounts Dept
    Repeat: GEN Payment Terms : BankColl
    Common Border: No
    
    
    
    [Line: GEN Payment Terms]
    Fields: Simple Field,
    Right Field: GEN Payment Terms   
    Local: Field: Simple Field : Set as : "Payment Terms :"
    Local: Field: Simple Field : Width: 65 mm
    Local: Field: Simple Field : Style :  Book Antiqua Bold
    Space Top: 2 MM
    Height: 2 MM
    Space Bottom: 2 MM
    
    [Field: GEN Payment Terms]
        Use: Name Field
        Set as: $BASICDUEDATEOFPYMT
        Print BG: Grey
       
    [Line: GEN Payment Mode]
    Fields: Simple Field, GEN Payment Mode
    Local: Field: Simple Field : Set as : "Payment Mode"
    Local: Field: Simple Field : Style :  Book Antiqua Bold
    Space Top: 2 MM
    Height: 2 MM
    Space Bottom: 2 MM
    
    [Field: GEN Payment Mode]
        Use: Name Field
        Set as: $$BASICDUEDATEOFPYMT
       
    [Line: GEN Account Name]
    Fields: Simple Field, GEN Account Name
    Local: Field: Simple Field : Set as : "Account Name"
    Local: Field: Simple Field : Style :  Book Antiqua Bold
    Space Top: 2 MM
    Height: 2 MM
    Space Bottom: 2 MM
    
    [Field: GEN Account Name]
        Use: Name Field
        Set as: $$BankAccHolderName:Ledger:@VchBankName
    
    [Line: GEN Account No.]
    Fields: Simple Field, GEN Account No.
    Local: Field: Simple Field : Set as : "Account No."
    Local: Field: Simple Field : Style :  Book Antiqua Bold
    Space Top: 2 MM
    Height: 2 MM
    Space Bottom: 2 MM
    
    [Field: GEN Account No.]
        Use: Name Field
        Set as: $BankDetails:Ledger:@VchBankName
    
    [Line: GEN Bank name]
    Fields: Simple Field, GEN Bank name
    Local: Field: Simple Field : Set as : "Bank name"
    Local: Field: Simple Field : Style :  Book Antiqua Bold
    Space Top: 2 MM
    Height: 2 MM
    Space Bottom: 2 MM
    
    
    [Field: GEN Bank name]
        Use: Name Field
        Set as: If NOT $$IsEmpty:@VchBankMailingName Then @@VchBankMailingName Else ##SABankName
       
    [Line: GEN Swift Code]
    Fields: Simple Field, GEN Swift Code
    Local: Field: Simple Field : Set as : "Swift Code"
    Local: Field: Simple Field : Style :  Book Antiqua Bold
    Space Top: 2 MM
    Height: 2 MM
    Space Bottom: 2 MM
    
    
    [Field: GEN Swift Code]
        Use: Name Field
        Set as: If $$IsEmpty:IFSCode Then @BranchName Else +
    If $$IsEmpty:BranchName Then @IFSCode Else $$Sprintf:"%s & %s":BranchName:IFSCode
       
    [Line: GEN IBAN]
    Fields: Simple Field, GEN IBAN
    Local: Field: Simple Field : Set as : "IBAN"
    Local: Field: Simple Field : Style :  Book Antiqua Bold
    Space Top: 2 MM
    Height: 2 MM
    Space Bottom: 2 MM
    
    
    [Field: GEN IBAN]
        Use: Name Field
        Set as: $IBAN
    
    [Line: GEN Accounts Dept]
    Fields: Simple Field, GEN Accounts Dept
    Local: Field: Simple Field : Set as : "Accounts Department"
    Local: Field: Simple Field : Style :  Book Antiqua Bold
    Height: 2 MM
    Space Top:5 MM
    Space Bottom: 5 MM
    
    [Field: GEN Accounts Dept]
        Use: Name Field
        Set as: ""
        Border: thick Box
    
     



  6. upload_2018-11-5_14-30-56.png


    help me fetch the subtotals, gcc vat and discount please...

    earlier response will be appreciated !!

    thank you
     


  7. Avrt Technologies

    Avrt Technologies New Member


    Hi Vinay,

    We will definitely help it out. We are expertise in TDL having decade of experience in product customization.

    We have gone through your tdl code. You have pasted partial tdl code and it is difficult to figure out the issue. However we noticed that for the few fields set as referred to local formula. This local formula is not declared in the field.

    [Field: GEN Account No.]
    Use: Name Field
    Set as: $BankDetails:Ledger:mad:VchBankName

    If your issue is not sorted out yet, please share your source code or mail to reachus@processpace.org.
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I've removed Advertising content. Kindly follow FORUM rules and do not post any kind of advertisement contents.

    However, you are free to invite members elsewhere and conduct your business there.
     






  9. I have Resolved my query long back..... Thq for your response...
     


Share This Page