You cannot view this unit as you're not logged in yet.

35 thoughts on “Live Project ( Tally TDL) : Customise Invoice – Part III

  1. narendra jain says:

    ;;raju jain
    ;;narendrajain1977@gmail.com
    ;;;;[Line: EI InvInfo]

    ;;Fields : EI DeemedPos, VCH StockItem
    ;;Right Fields: VCH ActualQty, VCH BilledQty, VCH RateIncl, VCH Rate, VCH RateUnit, VCH PrevItem, VCH Discount, VCH Value

    [#Line: EI InvInfo]
    Add: Field: Before: vch stockitem: itemsrfld, stkcodefld
    [Field:itemsrfld]
    Use: number field
    Set as: $$Line
    [Field: stkcodefld]
    Use: name field

    Storage: stkcode
    [System: UDF]
    stkcode: String: 210010
    showing error in storage

  2. Anil Parekh says:

    ;; Anil N Parekh

    [#Line: EI InvInfo]
    Add:Field:Before:VCHStockkItem:InvSrNoFld,InvCodeFld
    Field:InvSrNoFld,InvCodeFld
    [Field:InvSrNoFld]
    Use:Number field
    Set as:$$Line
    [Field:InvCodeFld]
    Use:Name field
    storage:ItemCode
    [System:UDF]
    Itemcode:String:20001

    no error but not being shown in sales invoice

  3. yugalbini says:

    [#Line : EI InvInfo]
    Add: Fields : Before: vch stockitem : srnofld,itmcdfld
    Field : srnofld
    Right Field: itmcdfld

    [Field : srnofld]
    Use : number field
    Set as : $$Line
    [Field : itmcdfld]
    Use : name field
    Storage : itemcode

    [System : UDF]
    itemcode:String : 10006

    ;; there is noting shows

  4. Giridharan Varadharajan says:

    Giridharan Varadharajan

    Sir,
    please refer my folder in tally mentor.
    I will definitely work other field.
    What ever you thought I have presented.

  5. Giridharan Varadharajan says:

    Giridharan varadharajan

    Sir,
    I have uploaded the assignment in my folder.
    Please verify.

  6. Hello Sir,
    I want to customize the Account voucher in Sales. I want look like this one header title :

    Particulars Working Days Duties Rates Amount

    And put the formula for display result in amount section and the formula is :
    (Rates / Working Days) * Duties

    I have to learn from your side but i cann’t understand how to set this one and which line and define is call for this , where my formula is put down
    I have written code but this is not helpful for me. My code is :

    [#Line: EI ColumnOne]

    Add:Right Field:Before:VCH QtyTitle:ItemCodeTitle

    Local:Field:ItemCodeTitle:Info:$$LocaleString:”Working Days”

    Local:Field:VCH ItemTitle:Space Left:4

    [Field:ItemCodeTitle]
    Use:Name Title Field
    Style: Normal Bold

    [#Line:EI InvInfo]

    Add:Right Field:Before:VCH ActualQty:InvCodefld
    Local:Field:InvSrNoFld:Space Left:8
    Local:Field:InvCodefld:Space Left:8
    Local:Field:VCH StockItem:Space Left:10

    [Field:InvCodefld]
    Use:Name Field
    Storage:ItemCode

    [#Field: VCH Value]
    Use : Amount Forex Field
    Width : @@VCHAmountWidth
    Storage : Amount
    Set always : Yes
    Inactive : $$IsSysName:#VchStockItem
    ResetVal : If (@@NoBaseUnits OR $$IsEmpty:$InvCodefld) then $$Value else (($Rate * $InvCodefld * (100 – $Discount)) / 100)

    BatchTotal : $$CollAmtTotal:BatchAllocations:$Amount

    [System:UDF]
    ItemCode:String:21001

    So please help me in detail
    Thanks a lot in advance……..

    1. Hello Jagrit,
      This course is not a ready reference and we don’t encourage student to join the course to get a ready made solutions.

      It is never possible to offer a ready made solutions. Else everyone will join the course for some Rs.6-7k and will ask me to fix issues their issues.

      The purpose of the course is to learn and not to provide any ready made solutions.

      I suggest you please start using the course from the chapter one and save your codes/examples in the Dropbox.

      and You have to do the course projects. once you do that, you can be able to fix the issues on your own.

      Our support is available only for the Course related projects.

  7. I have to one issue, please go to Jagrit folder and in that one text file which name is issue. In text file i have written to all my requirement
    So please guide me in properly way

    1. Hello Jagrit,

      Once Again, I repeat that you need to study the course.
      If you don’t write any single line of codes then I can’t help you.
      WE don’t offer any ready made solutions and we help only for the course related proejcts where the studnet first write codes and follow the course structure.

      If you are not following the course chapters then I am sorry, I can’t help you

      You can buy the ready made solutions

      So, let me know if you want to learn it or want to buy the ready made solutions?

  8. jitendratallyagra says:

    SIR, I M UNABLE TO STORE WEIGHT, PLS RECTIFY MEE

    [#Line: EiColumnone]

    ;; add field for serial number ,item code in invoice & WEIGHT FIELD
    Add:Field:Before:VCHItemTitle:vchserialno , itemcodetitle , weight

    Local:Field:itemcodetitle:Info:$$LocaleString:itemcode

    Local:Field:vchserialno:Info:$$LocaleString:sr.no
    Local:Field:weight:Info:$$LocaleString:itemweight
    Local:Field:vchitemtitle:Space Left:2 ;; provide space between lines

    Local:Field:itemweight:Space Left:2 ;; provide space between lines
    [Field:vchserialno]

    Use:number field

    Set as:”SERIAL NUMBER”

    [Field:itemcodetitle]
    Use:NAME field

    [Field:weight]
    Use:qTY field

    ;;Add serial number in invoice

    [#Line: EI InvInfo]
    Add:Field:Before:vchstockitem:srnofld, codefld , WEIGHTFLD
    [Field:srnofld]
    Use:number field
    Set as:$$Line
    Skip:Yes

    ;;add item code in invoice

    [Field:codefld]
    Use:name field
    Storage:codefld
    [System:UDF]

    codefld:String:abc
    ;; WEIGHT FIELD

    [Field:WEIGHTFLD]
    Use:QTY FIELD
    Storage:WEIGHTFLD
    [System:UDF]
    WEIGHT:Quantity:10001

  9. Shabuddin Daredia says:

    File uploaded ……. Shabuddin\InvoiceCustomisePart3.txt

  10. SURAJIT SARKAR says:

    [#Line: EI ColumnOne]
    /* Fields : VCH ItemTitle
    Right Fields: VCH QtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle, VCH AmtTitle
    */

    Add: Field: Before: VchItemTitle:VchSrNoTitle, ItemCodeTitle
    Local: Field: VchSrNoTitle:info:$$LocaleString:”Sr.No”
    Local: Field: ItemCodeTitle:info:$$LocaleString:”Item Code Po No”
    Local: Field: VchItemTitle: Space Left: 8
    Local: Field: ItemCodeTitle: Space Left: 8
    [Field: VchSrNoTitle]
    Use : Title Field
    ;Set as : “Sr.No”
    Width: 9
    Skip: Yes

    [Field: ItemCodeTitle]
    Use : Title Field
    ;Set as : “Item Code Po No”
    Skip: Yes

    [#Line: EI InvInfo]
    Add: Field: Before: VCH StockItem:InvSrNoFld,InvCodefld

    [Field: InvSrNoFld]
    Use: Number Field
    Set as:$$Line

    [Field: InvCodefld]
    Use: Name Field
    Storage:ItemCode
    [System: UDF]
    ItemCode:String: 21001

    Sir this code is running.

    But sir my one question ? If i want to modify Name of Item to “Item Description” . How can I do It.

  11. SURAJIT SARKAR says:

    Sir This is my fault that I don’t understand what you say. kindly discuss with example code.

    1. Better go as per the course chapter and do what is there. First make yourself familiar with the codes

      and eventually after studying the other modules you can come back to your project anytime later when you get a better idea.

      Don’t try to do things which are not there until you become familiar with the codes

  12. madhupandat says:

    Sir, I have Added the Assignment (Additional Fields in Sales Invoice) to My Dropbox.
    Please Verify the Same.

  13. Sir, this code not works proprely. Only title apears, but entry field (item code) not appeared.

    ;; TDL for making a GOODS RECEIPT NOTE ————-
    ;; SHIV NARAYAN SHARMA
    ;;

    [#Line: EI ColumnOne]
    Add : Field:Before: VchItemTitle: VchSrNoTitle,ItemCodeTitle
    Local : Field:VchSrNoTitle :info:$$LocaleString:”Sr.No”
    Local : Field:ItemCodeTitle:Info:$$LocaleString:”Item Code/PO No”
    Local : Field:ItemCodeTitle :Space Left: 8
    Local : Field:VCH ItemTitle :Space Left: 8

    [Field: VchSrNoTitle]
    Use : Title Field

    [Field: ItemCodeTitle]
    Use : Title Field
    [#Line: EI InvInfo]
    Add : Field:Before: VCH StockItm: InvSrNoFld, InvCodFld

    [Field: InvSrNoFld]
    Use : Number Field
    Set as : $$Line

    [Field: InvCodFld]
    Use : Name Field
    Storage : ItemCode

    [System: UDF]
    ItemCode : String: 21001

    1. Please re check your codes and compare it with the course chapter. If it is as per the course chapters then it will work 100% because so many students have done it without any issue and there is no reason that it won’t work.
      Also, please do not post your codes in the comment section. Use Zopim chat to post your codes.

      if you had made any changes in your code then make sure you saved the code and refresh the TDL. sometimes we forget to save the code so it may not appear in the output result.
      So, check your codes 2-3 times and even after that it don’t work then give me remote access so that I can check it.

  14. seema kasliwal says:

    ;dear sir check it from seema
    [#Line: EI ColumnOne]
    Add :Fields: Before : VCHItemTitle :VCH SrNoTitle, Item codeTitle,Challan qtyTitle, Receiv qtyTitle, Accept qtyTitle, Reject qtyTitle, ShortageTitle, InspectedTitle

    1. Did you tested the code?
      Is it working and giving result as per the course project?
      Or if you are facing any issue.

      Please save your code to Dropbox only and not in the comment section as commens are publically visible.

  15. KISHORE KUMAR B N says:

    Sir,
    I have finished this assignments and added txt file to [my new title in sales invoice.txt] drop box. kindly check it sir

    Thanking you

  16. Manikandan SolutionPoint says:

    Sir,
    String : 21001
    Why we are using 21001 code, Is it same like Ledger Master Index.
    For each UDF should we enter a separate index like this…
    Pls guide.

    1. string is Field type
      IF you want to store data you need a storage at the field level
      Then you need to define that storage at the system udf level
      System udf has storage name, field type and index number

      index number can be anything 99 to 99
      21000 to 29999 etc

      each storage will needs its own index number
      there is a whoe chapter covering this topic
      If you have not skipped any chapter then you will get it in the sequence and you will understand these things more clearly

  17. akash sharma says:

    Hello Sir,
    I have written the codes for making a voucher as per the given image. however faced some issues regarding
    1. Not able to disable rate and amount column
    2. Not able to Align the fields.
    Have put the code under Akash Sharma with file name as “Live Project” in drop box for your review.
    kindly correct me where i am wrong and will wait for your review.

    Thank You. Such wonderful Chapters. Getting to learn a lot from you sir.

    1. Why you want to disable rate and amount coloumn?Because the chapter is not related to disable any existing fields
      However still if you want to disable it then go to the root definition line code which is already mentioned in the chapter

      once you go to the root /default code line copy that line and its fields to your codes and then delete the field by modifying the line defintions
      [Line : my line]
      Delete : Field name

      but if you deelte an existing defintions/fields it will mess up the structure so better don’t do that and just follow the course so that you can understand how things works eventually

  18. Muruga Vel says:

    Murugavel.k

    Sir I have finished this assignments but not working added txt.file to [Sales Invoice New Column Add] drop box. Kindly check it sir.

    1. Hello Muruga Vel,

      Just saying that code are not working doesn’t help to solve the problem.
      Becuase code in itself doesn’t tell us if they have a problem.
      So, you need to specify in what sense it is not working.

      Because even If I test your codes and I dont’ find any issue then how to solve it?
      So, firs tyou need to specify exactly in what sense the codes are not working.

      in your Dropbox folder create one more folder name it the live project and then put your code file inside that sub folder
      then test the code with your Tally, take a screen shot and put the screen shot in the same folder.
      once this is done, reply to this comment and let me know in what sense the codes are not working so that I can look and can find a cause of the issue.

      1. Muruga Vel says:

        Thank you sir ur reply i was solved this error for sales invoice add new column
        This File saved in drop box in my name folder Murugavel

  19. RITESH CHOPRA says:

    [#Line: EI ColumnOne]
    Add:Field:Before:VCHItemTitle:VCHSRNOTITLE,ITEMCODETITLE
    Add:Right Field:AFTER:VCH QtyTitle:ACCEPTEDQTYTITLE
    Add:Right Field:AFTER:ACCEPTEDQTYTITLE:REJECTEDQTYTITLE
    Local:Field:VCHSRNOTITLE:INFO:$$LocaleString:SR.NO
    Local:Field:ITEMCODETITLE:INFO:$$LocaleString:ITEMCODE
    Local:Field:ITEMCODETITLE:Space Left:2
    Local:Field:ITEMCODETITLE:Space Right:4
    Local:Field:ACCEPTEDQTYTITLE:INFO:$$LocaleString:ACCEPTEDQTY
    Local:Field:REJECTEDQTYTITLE:INFO:$$LocaleString:REJECTEDQTY
    [Field:VCHSRNOTITLE]
    Use:TITLE FIELD
    Set as:”SR.NO”
    Set Always:Yes
    Skip:Yes
    Color:BLUE
    [Field:ITEMCODETITLE]
    Use:TITLE FIELD
    Set as:”ITEMCODE”
    Set Always:Yes
    Skip:Yes
    Color:RED
    [Field:ACCEPTEDQTYTITLE]
    Use:TITLE FIELD
    Set as:”ACCEPTEDQTY”
    Set Always:Yes
    Skip:Yes
    Color:BLUE
    [Field:REJECTEDQTYTITLE]
    Use:TITLE FIELD
    Set as:”REJECTEDQTY”
    Set Always:Yes
    Skip:Yes
    Color:RED

    [#Line: EI InvInfo]
    Add:Field:Before:VCH StockItem:VCHSRNO,ITEMCODES
    Add:Right Field:After:VCH Billed QTY:ACCEPTEDQUANTITY
    Add:Right Field:AFTER:ACCEPTEDQUANTITY:REJECTEDQUANTITY
    [Field:VCHSRNO]
    Use:NUMBER FIELD
    Set as:$$Line
    Skip:Yes

    [Field:ITEMCODES]
    Width : If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
    SubTitle : Yes

    Style : Small Bold
    Align : Left
    Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl
    Skip : No
    Fixed : Yes
    Color:RED

    Use:Name Field
    Storage:ITEMCODE

    [Field:ACCEPTEDQUANTITY]
    Width : If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
    SubTitle : Yes
    LOCAL:Field:QUANTITY FIELD:Setas : $$LocaleString:”ACCEPTEDQUANTITY”
    Style : Small Bold
    Align : Centre
    Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl
    Skip : No
    Fixed : Yes
    Color : BLUE
    Use : Qty Primary Field
    Width : @@VCHQtyWidth
    Set always : Yes
    Storage : ACCEPTEDQUANTITY
    Space Left:4

    [Field:REJECTEDQUANTITY]
    Width : If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
    SubTitle : Yes
    LOCAL:Field:QUANTITY FIELD:Setas : $$LocaleString:”REJECTEDQUANTITY”
    Style : Small Bold
    Align : Centre
    Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl
    Skip : No
    Fixed : Yes
    Color : BLUE
    Use : Qty Primary Field
    Width : @@VCHQtyWidth
    Set always : Yes
    Storage : REJECTEDQUANTITY
    Space Left:4

    [System:UDF]
    SR.NO:Number:1006
    ITEMCODE:String:1007
    ACCEPTEDQUANTITY:Quantity:1008
    REJECTEDQUANTITY:Quantity:1009

    SIR I HAVE MADE THIS CODE WHICH IS RUNNING SUCCESSFULLY.KINDLY CHECK & CONFIRM ME ON WHATS APP NUMBER 9517549770

  20. Mohammed Karjatwala says:

    Mahendrabhai,
    I have written the code for cstomised challan and all the titles are showing very well. However, In the fields where the input data is to be fed, on the first columns it is chowing and saving perfectly well. In the field Challan Qty and after that, the code is not working.

    I have saved the same in Dropbox with name “Challan Qty”. Kindly look into the same and let me know where I am going wrong, so I can rectify my code and do the same for all the other fields.

    Also why no space is showing inbetween the words like Challan Qty, Accepted Qty, etc.

Leave a Reply