Total: ₹0.00
Total: ₹0.00

Discount Project | Customising Invoice

You cannot view this unit as you're not logged in yet.
Prev post Default Definition | The easiest way to find a default definition in no time!
Next post Create a Report in Tally to fetch Data through Collection

49 thoughts on “Discount Project | Customising Invoice”

  2. dashrathprajapat2 says:

    Dear sir
    I have completed Discount module project but i have one problem with that is
    i cound not get third discount as NOS. so do the needful i am pull the code and screenshot in the dropbox already.

    1. I didn’t understand your logic for the calculation.

      you need to set up the discount in Nos at the stock item master and then fetch the same by using the formula
      $udfname:StockItem:$StockItemName

      At this moment, instead of trying to do complex thing, I suggest stick to the simple things and make your basic strong.

  3. Nct Solutions Nct Solutions says:

    sir i m not able to understand some discount amount calculation coding…i have put my code in my dropbox folder..u plz check and explain me…thanks

    1. Hello Chanchal,
      You need to tell me what things you didn’t understand so that I can explain it. Just by reading the code, I can’t get the idea what things you didn’t understood. I will check your code. But I always suggest when the code doens’t work, we need to review code our code very carefully and always have to compare with the course chapters.

      The reason is that no matter how experience we are, there is always chances of mistakes like typing ; instead of : or definition name or anything.
      Please organise your files properly so that I can review your files.

  4. Nct Solutions Nct Solutions says:

    sir i have not get the code for formula for calculating discount amount and invoice value after adjusting discount.
    when i run my code in tally discount amount is not calculating.
    i will arrange my files accordingly

    1. Palak,
      The formulae is simple
      Fieldvalue1*Fieldvalue2

      Say your disc rate is 5per pcs and your bileld qty is 100
      then the feidlvalue for the billedqty is $vchbiledqty something like

      Now the discstorage name for the disc field is mydisc1
      So here the formulae will be
      $vchbilledqty*$disc1

      if the udf formulae doens’t work then you can simply do the same thing by fetching the fieldname
      #vchfeidlname1*#vchFieldname2

    2. Hi,
      You didn’t add the UDF definition for your storage in the item name. You need to define the UDF for every storage unit you are creating

      [Field: STKI CusDiscFld]
      Use: number field
      Format:”No zero, no percentage”
      Color: red
      Storage: StockDiscountVal
      Skip: No

      Here you are creating an udf/Storage name StockDiscountVal so you need to define the same in the UDF by this way:
      [System : UDF]
      StockDiscountVal : number field : 121.

      Please do this way in all your codes. Only after that it will store the data.
      Also

    3. Hi Chanchal,
      I will create a case study for your codes by tonight or tomorrow. I am sure that will give you a clear idea of the entire project.

  5. Giridharan Varadharajan says:

    Giridharan Varadharajan.
    sir,
    In this project in your demo at the last part you have modified
    [#field:VCHInvoice Value]
    skip on:@@IsSales
    setas:$Rate*$BilledQty-$VCHDiscFirstAmt
    and etc.
    But the Default field in TDL is VCH Value( The last Column wherein we arrive at the final Amount after deducting the discount).
    The field you have modified is not defined.
    But when I use the Default fieldVCH Value the out put is wrong and not working.
    I have shared the codes and output in my folder dated 18.01.2017.
    Tell me where I went wrong.

    1. Vchvalue is the default but when the Invoice is issued in the invoice mode then the field vchinvoicevalue is activated.
      If you see the right side bar of the voucher entry section in sales invoice you will find the options like as voucher, as invoice as item invoice etc.

      So, upon the user choice the related fields are being activated.

      Which invoice mode in your Tally you are using? solution depends on the same.

  6. Giridharan Varadharajan says:

    Giridharan Varadharajan
    sir,
    Waiting for your solution

    1. Please arrange your files properly. If the files are related to a discount project then put them in the related project.
      Create one main file and then include all your project related file to that one file. I have shown that last time. I think so.

      Right Now, I can’t know which of your files are related to Discount project. Also take care for the proper name of the file so that I can know if a file is related to printing or the voucher entry coding without opening that file.

  7. Giridharan Varadharajan says:

    Giridharan Varadharajan
    Sir,
    I got your point.
    In your demo you coded skip on:@@Is sales (My understanding is to skip if it is sales.
    again you have coded Skip: No after setas : $Billed qty *$Rate-$ VCH Disc First Amt.
    Here we are preparing sales Voucher, then Why you have coded Skip on:@@ is sales.
    Kindly clarify

    1. We are skipping the field if the voucher type is Sales. Cause we don’t want to allow users to manually edit and change the result else they can manipulate the same. In a Sales invoice we can allow users only to input the qty and rate by allowing them through Set as : $$Value. The vch value should calculate automatically. so we are skipping the vch value automatically. we aren’t skipping the Voucher itself. We are skipping a particular field only.

  8. Giridharan Varadharajan says:

    Giridharan Varadharajan
    Sir,
    I have grouped the files as under in my folder
    Main file = CMP Discount Main.txt
    Included Files- CMP Discount Enable.txt, CMP Item Master.txt, CMP Discount Vch Entry.txt.
    Output png file is- Discount Voucher entry.png.
    please verify .

    1. Hi,
      Please create a new sub folder with the name DiscProject and move your discount project related files to that folder. Also move the screenshot to that folder only.

  9. Rajesh Upadhyay says:

    Sir,

    I have shared my code and screenshot in drop box please check .

    1. I have checked them

      and also you need to mention clearly if your codes are working fine and or you are facing any issue.

      For F11 settings you have mistake in your codes, you need to check the course project again carefully or watch the case study.

      I suggest try your best level to sort out the issue for the F11, if you go each and every line carefully almost 5-10 times you will be able to solve the issues on your own. Else you will always have to depend on me or on someone else to sort our the issue.

      Study course of Chanchal Verma or Mr. Giridharan or other students who have completed that project.

      if you want to become an expert you must try hard to solve the problem on your own.
      I can fix your problem only in one minute but the issue is that I wont be available at to rescue you always and so you must develop the ability of the problem solving on your own.

      When All your efforts fail, I am always there to sort out the issue.

  10. suhasmasaye says:

    hello,,

    i have put the code in my dropbox, as you said i had wriiten the formula but it is not calculating the correct amount.

    Please check

    1. Hello suhasmasaye,
      When we need help for coding related stuff or our codes doesn’t work, we need to provide clear details of the exact problems.
      If you can’t explain a problem properly then you can’t be become a good developer.
      Merely mentioning that the amount is not calculating is not a right way to get support.
      You need to be specific exactly which amount is not calculating correctly?
      First discount amount, Second Discount amount or the Invoice amount?
      Did you tried by disabling the second discount field.
      When the code doesn’t work, break them
      Enable only the first discount and try to solve the problem.

      Did you referred the project again carefully and tried to solve the problem?
      So, please follow all these steps and come back again to me with the exact issue and I will be happy to solve your issue.

    2. And I observed that you are modifying the Wrong Field for the amount Field.
      The correct field name is VchInvoiceVal while you are modifying the VchValue field so change the field name and test it.

    3. And I observed that you are modifying the Wrong Field for the amount Field.
      The correct field name is VchInvoiceVal while you are modifying the VchValue field so change the field name and test it.
      Have you done it?

      I didn’t find the updated codes in your dropbox file it is still showing the old codes only.
      As I said please put full details exactly which amount is not working

  11. suhasmasaye says:

    hello sir,,,

    Thanx.
    there is issue in the Invoice Amount Calculation.
    as u said,,, i tried it but then also Invoice amount calculation is wrong.

    Please guide

  12. Manoj kumar Jangid says:

    Dear sir
    i coding the conf invoicing

    codes are

    [#Part:EI column]
    Height:2.5

    [#Line:EI columnOne]
    Add: Right Field: After: VCH rate title: VCHfirstDiscrateTitle,VCHfirstDiscAmtTitle,VCHAddDiscrateTitle,VCHAddDiscAmtTitle

    [Field:VCHfirstDiscrateTitle]
    Use: Name Field
    Set as:”Discount Rate(%)”
    Width:15
    Skip:Yes

    [Field:VCHfirstDiscAmtTitle]
    Use: Name Field
    Set as: “Discount Amount”
    Width:15
    Skip:Yes

    [Field:VCHAddDiscrateTitle]

    Use: Name Field
    Set as:”Extra Discount Rate(%)”
    Width:15
    Skip:Yes

    [Field:VCHAddDiscAmtTitle]

    Use: Name Field
    Set as: “Extra Discount Amount”
    Width:15
    Skip:Yes ;; end of coding for Column One

    ;; now fields for Invoice Information

    [#Line: EI Invinfo]
    Add:Right Field: After: VCHrate:VCHfirstDiscrate,VCHfirstDiscAmt,VCHAddDiscrate,VCHAddDiscAmt

    [Field:VCHfirstDiscrate]
    Use: number field

    Set as: $stockdiscountval:stockitem:$stockitemname

    Storage:VCHdiscfirstrate

    Width:15
    Format:”no zero, percentage”
    Skip:Yes

    [Field:VCHfirstDiscAmt]
    Use: Amount field

    Set as: ($billedQty*$Rate)*$VCHdiscfirstrate%

    Storage:VCHdiscfirstAmt

    Width:15
    Align: Center
    Format: “no zero”
    Color:red
    Background:yellow

    [Field:VCHAddDiscrate]
    Use: number field

    Set as: $stockextradiscountrate:stockitem:$stockitemname

    Storage:VCHdiscextrarate

    Width:15
    Format:”no zero, percentage”
    Skip:Yes

    [Field:VCHAddDiscAmt]
    Use: Amount field

    Set as: ($billedQty*$Rate)*$VCHdiscextrarate%

    Storage:VCHdiscaddAmt

    Width:15
    Align: Center
    Format: “no zero”

    [#Field:VCH InvoiceVal]

    ;Set as:{($billedQty*$Rate)-$VCHdiscfirstAmt ;+$VCHdiscfirstAmt)}
    ;Storage:VCHAmt

    Skip on:@@issales
    Set as:($rate*$billedqty);-$VCHdiscfirstAmt-$VCHdiscaddAmt
    Skip:No
    Read Only:No
    Set Always:Yes
    Background:red

    [System:UDF]

    VCHdiscfirstrate:Number:41
    VCHdiscfirstAmt:Amount:42
    VCHdiscextrarate:Number:43
    VCHdiscaddAmt:Amount:44

    but after execute , there are No Amount of Discount show in voucher PLZ check

    1. you need to review your code and compare them with the course chapter
      also there is a case study at the end of the chapters in the same modules
      But I suggest you, please read and review your code 4-5 times again and again and compare each and every line with the chapters.
      You need to do your best to solve the solutions on your own else you will always depend on someone else to solve issues if you don’t develop the habit of solving issues.

      Mostly there are small spelling issues or some other minor mistakes which we can solve if we review our codes again and again.

  13. Santosh Shrestha says:

    Dear sir,
    The Title field i had added on EI ColumnTwo is not appear if Actual and billed qty is not enabled? Suggest in this area.

    1. Hello Santosh,

      In the discount project you become familiar with the default basic codes which affect the column title now you if you read that file you will come to know about actual billing qty, you need to find out the related line and then modify that line and add your codes.
      If you want to explore more and more things then you have to read the default source code files and There is one chapter where I have shown how to read folders and files under the default definitions modules/chapters.

  14. BrajeshKumar Verma says:

    This is the code. Please Provide the corrected code.
    [#Part: STKI TaxDetails]
    ;Background:RED

    Add:Line:STKI dis,SKTI extdis
    [Line:STKI dis]
    Field:Medium Prompt,STKI dis_field

    Local:Field:Medium Prompt:Set As:”DISCOUNT(NEW)”

    Local: Field: medium prompt: Inactive: Not $IsDiscountModuleEnabled:Company:##SVCurrentCompany
    Local: Field: STKI dis_field: Inactive: Not $IsDiscountModuleEnabled:Company:##SVCurrentCompany

    [Field: STKI dis_field]
    Use:number field
    Format:”No Zero, no Percentge”
    Color:red
    Storage:STKI dis
    Skip:No

    [Line:SKTI extdis]
    Field:Medium Prompt,SKTI extdis_field

    Local: Field:Medium Prompt :Set as:”Extra Disc”
    Local: Field: medium prompt: Inactive: not $IsDiscountModuleEnabled:Company:##SVCurrentCompany
    Local: Field: SKTI extdis_field: Inactive: not $IsDiscountModuleEnabled:Company:##SVCurrentCompany

    [Field: SKTI extdis_field]
    Use:number field
    Format:”No Zero, no Percentge”
    Color:red
    Storage:SKTI extdis
    Skip:No

    [System:UDF]

    STKI dis:Number:172
    SKTI extdis:Number:173

    1. Brajesh,

      I have asked you to upload your codes to Dropbox and also you didn’t uploaded full code. you have uploaded only stock item master codes
      And I also asked you to compare your codes with the course projects if you codes are matching with the course project then it will work 100%

      so, please upload your full codes to Dropbox and also study the course project once again and compare each and every line again
      once you do that then revert back to me for the solutions if you still can’t figure out.

  17. seema kasliwal says:

    dear sir
    Set as: ($BilledQty*$Rate)*$VCHDiscFirstRate/100 ; it is working displaying value
    Set as: $BilledQty*$VCHDiscFirstRate ;it is not working not displying value

  18. seema kasliwal says:

    dear sir
    i want discount on qty for that i have to use second statement

    1. I am not getting you

      in the project we already have 2 discounts.
      are you talking about the discount in Amount per qty?
      For that purpose you will need to change the field type to number type

      and apply the formula if it doesn’t’ work then you will need to use variable
      so, right now you can move and once you study the variable chapters you can come back to this project
      assign variables to your project and then it will work

    1. I will create a case study and will add a new project for that once I get free.
      Right now I am busy with my projects.
      Or you can move to the variable chapters study that and come back to this chapter and apply variables to your codes
      May be it will work

      If not then I will have to prepare a case study which I can do only once I get from my current projects.

  20. FARRAKH HAYAT says:

    Hi,
    I have upload a excel file to my drop box folder.
    I have tried to do calculation first in excel for under standing. If this calculation is good, then it is easy form me to write correct calculation in tally code.
    Kindly review my excel file and guide me.
    Thanks.

  21. akash sharma says:

    Hello Sir I have Finished Coding and have shared the codes in my Dropbox Folder, Also I have made a triple Discount Code and have shared it in Drop Box along with screenshots.
    Waiting for your review .

  22. Muruga Vel says:

    Hello sir
    I Have Grouped the files as under in my folder main file=CMP Discount Main.txt Included files and output screen png file also, First Discount Rate Not Automatically taking
    Please verify

  23. Good Evening Sir,
    I tried the Discount Module, but I am facing the error T0029, and I tried lost of things to resolve this error, but it was not resolved, request you to please check my code, it was uploaded in the dropbox folder,

    Thanks

  24. Mohammed Karjatwala says:

    Successfully completed Custom Invoice discount TDL. Screen shot uploaded on Dropbox by name Custom Invoice discount

  25. Mohammed Karjatwala says:

    I have also completed successfully the extra disount nos discount column. However the discount is not multiplying with the quantity. There is no error showing. We can look into this when you are free.

Leave a Reply