TDL for Previous & current Balance on invoice ( not in Excise but in normal)

Discussion in 'Free Source Codes' started by JObimon Arackal JOhn, Apr 16, 2013.

    
  1. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member




    please check this file. this is a correction of option b
     

    Attached Files:

    Gagan Jyoti likes this.


  2. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member


    try these codes both option
     

    Attached Files:

    Sunder likes this.


  3. laxman

    laxman Member


    Dear JObimon Arackal JOhn any idea to show discount value in invoice printing (In Disc(%) Column
    just like closing balance see attach
     

    Attached Files:



  4. Gagan Jyoti

    Gagan Jyoti Member


    Hello Mr. John

    I was working on the file with option "C"

    I am unable to know where we are using Line "Closingbal1"

    and further i am using Border at the bottom after closing balance then also it is showing error. For this I am using following syntax

    " Border: Full Thin Top, Full Thin Bottom "

    Thanks for the help

    Gagan
     


  5. Ras Raj

    Ras Raj Member





    Use
    Border : Thin Top Bottom
     
    JObimon Arackal JOhn likes this.


  6. R. VIJAY

    R. VIJAY Member



    is it any tdl file for open tally data in tally erp 9 rel 1.189 to tally erp 9 rel 4.8 without rewrite and migrate tally data
    thank you in advance
     


  7. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member



    No it is not possible in TDL. Because Data Structure is different in both Tally. Number of new feilds , UDF,Forms,Collections are introduced/ replaced in newer version of tally.Other wise one has to write tdl which is equivalent for entire tally programming code.
     
    mpal2311 and Ras Raj like this.


  8. mpal2311

    mpal2311 Active Member


    Don't upgrade and degrade your Tally data on regular basis, otherwise you may loose some or all data.

    Not Possible to migrate without rewrite.
     
    Ras Raj likes this.


  9. ravimadurai

    ravimadurai New Member


    Dear John,
    Grt job. I am getting the error message while using both the options in tally like as
    Function:STXCanUpdateDutyLed"

    Kindly help me for the same
     


  10. ravimadurai

    ravimadurai New Member


    Dear John,
    Grt job. I am getting the error message while using both the options in tally like as
    Function:STXCanUpdateDutyLed"

    Kindly help me for the same
     


  11. Amit Mahajan

    Amit Mahajan New Member


    whe
    where i put this line
     


  12. Saudi Solutions

    Saudi Solutions New Member


    How to omit the Cash Ledger become customer in sales. I am not getting. Now cash sale invoice shows Cash Balances
    IF $$ISCASHLEDGER:$PARTYLEDGERNAME THEN "" ELSE
     


  13. Rajan Pillai

    Rajan Pillai New Member


    Hello Experts
    Any body can help me to print Invoice with Company's "Drug Lic No: " and Customers' "Drug Lic No" on the Default Invoice format of Tally.
    Drug Lic No is around 60-65 charactors width and is mandatory for Pharmaceutical Business.
    Thanks for all of you.
    askrajan@gmail.com
     


  14. MANU PARAKKAL

    MANU PARAKKAL New Member


    Hai all
    Thanks Jobimon for U R great works in this form.

    Is there any chance of getting current balance of debtors and it sub ledgers printed in receipt and payment voucher
     


  15. admin

    admin Administrator Staff Member


    $ClosingBalance:Group:$$GroupSundryDebtors
     


  16. Hardik

    Hardik New Member


    Hello Experts,

    I am using this Source code & enjoying printing Party's Balance on invoice.

    But i have some issue
    After activating this Code party's balance is printing on Delivery challan (Delivery Note) also.

    I generally don't disclose any amount on Delivery Note.
    Please help me to remove party Balance from Delivery Note.

    I have done some minor change & final code is as follows

    ;;========================GOD IS LOVE & WORK IS WORSHIP=====================;;

    ;;TDL Developed by CKS

    ;;Following Code is to print "Mini Statement" on Invoices

    [#Part: EXPINV Words]
    Add:Lines:InvBal1, InvBal2, InvBal3

    [Line:InvBal1]
    Fields:preBal, SepFld, PreBalAmt

    [Field:preBal]
    Use:Name Filed
    Set as:mad:PreBal
    Width:15
    Invisible:Not ##InvBalPrint
    PreBal:IF $$IsDr:(($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) - $$abs:#EXPINVTotal) +
    Then "Opening Amt." Else If $$IsDr:(($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) + $$abs:#EXPINVTotal) +
    Then "Advance" Else "Advance"


    [Field:preBalAmt]
    Use:Amount Field
    Set as: @PreBalAmt
    Format:"Symbol,DrCr"
    Invisible: Not ##InvBalPrint
    PreBalAmt: If ($$IsDr:$$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) +
    Then($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) - $$abs:#EXPINVTotal else +
    ($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) + $$abs:#EXPINVTotal



    [Line:InvBal2]
    Fields:InvAmtTit, SepFld,InvAmt

    [Field:InvAmtTit]
    Use:Name Field
    Set as:"Add Bill Amt."
    Width:15
    Invisible:Not ##InvBalPrint

    [Field:InvAmt]
    Use:Amount Field
    Set as:#EXPINVTotal
    Align:Right
    Format:"Symbol,DrCr"
    Border:Thin Bottom
    Invisible:Not ##InvBalPrint


    [Line:InvBal3]
    Fields:InvNetTit, SepFld,InvNet

    [Field:InvNetTit]
    Use:Name Field
    Set as:mad:NetBal
    Width:15
    Invisible:Not ##InvBalPrint
    NetBal:IF $$IsDr:($$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) +
    Then "Net Receivable" ELSE "Net Advance"

    [Field:InvNet]
    Use:Amount Field
    Set as: @InvNetAmt
    Align:Right
    Format:"Symbol,DrCr"
    Border:Double Bottom
    Invisible:Not ##InvBalPrint
    InvNetAmt:$$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries




    [Field:SepFld]
    Use:Name Field
    Set as:":"
    Width:1
    Align:Centre
    Space Left:0.2
    Space Right:0.3

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

    ;;Following Code is to incert option in print configuration - CKS

    [#Part: IPCFG Right]
    Add:Line:At End:InvBalPrint

    [Line:InvBalPrint]
    Fields : Medium Prompt, InvBalPrint
    Local : Field : Medium Prompt : Set as:"Show Mini Statement?"

    [Field: InvBalPrint]
    Use : Logical Field
    Modifies : InvBalPrint

    [System:Variable]
    InvBalPrint:Yes

    [Variable:InvBalPrint]
    Type:Logical
    Persistent:Yes

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

    ;;End of File - CKS




    Thanks in Advance
    Regards,
    Hardik Kothari
     
    Last edited: Oct 5, 2015


  17. MANU PARAKKAL

    MANU PARAKKAL New Member


    is there any chance to print current balance in sales purchase receipts and payments which is seen under the ledger name
     


  18. tejeet

    tejeet Member







    this codes is not working for tally.erp9 v6.03 gst invoice printing
     


  19. tmdmuzammil

    tmdmuzammil New Member


    Dear developer me too not able to print please help us..
     


  20. jaingourav25

    jaingourav25 New Member


    I made a slip for rough estimate. how i add this with tally invoice and i also wants previous balance in it. please suggest
     

    Attached Files:



  21. dipu369

    dipu369 Member


    for taking care of the Sales Return Entry where i will put
    Invisible:not $$IsSales
     



  22. Dear Sir

    I am trying to include receipt in two line 1. Received in Cash 2. Received in Bank. can you please share how can i set filter in local formula, Or in other way.
    Thank You
     


Share This Page