Invoice Format need help

Discussion in 'Tally Developer' started by Mahesh Sethi, Sep 14, 2021.

    
  1. Mahesh Sethi

    Mahesh Sethi Member


    Dear All Experts & Admin,

    i have done the invoice format but need help in fields value replacement.
    For example:



    [Line:OTS Due Date]
    Field: Simple Prompt, Simple Field ;Due Date
    Local: Field: Simple Prompt: Set as: "Due Date:"
    Local: Field: Simple Prompt: Width : 15% page
    Local: Field: Simple Field: Set as: $$BaseOwner:$BasicDueDateOfPymt ;@VDueDate ;"Due Date" ;;$MyEBR2
    Local: Field: Simple Field: Width: 15% Page

    Space Top:0.25
    Space Bottom: 0.25
    ;Border: Thick Bottom

    When i use it it show me due days not date. Pls help me.

    Thanks & Regatds,
     

    Attached Files:



  2. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    VERY SIMPLE,
    @@NewDueDate
    [system :Formula]
    NewDueDate:$Date+$$Number:$DueDate
     


  3. Mahesh Sethi

    Mahesh Sethi Member


    Sir Its Not working


    [Line:OTS DueDate]
    Field: Simple Prompt, Due Date ;Simple Field ;
    Local: Field: Simple Prompt: Set as: "Due Date:"
    Local: Field: Simple Prompt: Width : 15% page
    ;Local: Field: Simple Field: Set as: @@VCHBILLDueDate ;$$BaseOwner:$BasicDueDateOfPymt ;@VDueDate ;"Due Date" ;;$MyEBR2
    ;Local: Field: Simple Field: Width: 15% Page
    Space Top:0.25
    Space Bottom: 0.25
    ;Border: Thick Bottom

    [Field : Due Date]
    Use : Due Date Field
    Set Always : @@NewDueDate


    [system :Formula]
    NewDueDate:$Date+$$Number:$DueDate


    Also Pankaj Ji Pls provide me your mail id & contact no.
     
    Last edited: Sep 14, 2021


  4. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  5. Johar

    Johar Member


    Try this :

    $$String:($LedgerEntries.LedgerEntries.BillAllocations.BillCreditPeriod):UniversalDate
     


  6. Mahesh Sethi

    Mahesh Sethi Member


    Dear Johar Sir,

    Thanks Its Done
    [Field : Due Date]
    Use : Uni Date Field
    Set as : $$String:($LedgerEntries.LedgerEntries.BillAllocations.BillCreditPeriod):UniversalDate ; @@NewDueDate
    Style : Normal

    One another query if i want only month in universal format like if bill date is 25.08.2021 then i want replace only August

    Pls Guide me.

    Thanks in advance
     


  7. Mahesh Sethi

    Mahesh Sethi Member


    Johar Sir,

    One another query if i want only month in universal format like if bill date is 25.08.2021 then i want replace only August

    Pls Guide me.

    Thanks in advance
     


  8. Johar

    Johar Member


    Try this :

    Local : Field : Name Field : Set As : $$FullMonthName:($$String:($LedgerEntries.LedgerEntries.BillAllocations.BillCreditPeriod):UniversalDate)
     


Share This Page