Know Today's Sales

Discussion in 'Free Source Codes' started by sseema, Dec 31, 2019.

         
  1. sseema

    sseema Member


    upload_2019-12-31_15-53-51.png

    [#Line: EI PartyLimit]

    Add : Field : After : EI CurrentBalance : TotSales

    [Field : TotSales]

    Invisible : NOT ##CurBalanceFlag
    Field : Simple Prompt, Amount Field
    Local : Field : Simple Prompt : Info : $$LocaleString:"Today's Total Sales:"
    Local : Field : Simple Prompt : Width : 14
    Local : Field : Amount Field : Set as : @@TrsTotSales
    Local : Field : Amount Field : Format : "Symbol,DrCr"
    Local : Field : Amount Field : Set always : Yes
    Local : Field : Amount Field : Color : Black



    [System : Formula]

    TrsTotSales : $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupSales
    ;$$ToValue:$Date:$CreditTotals:Group:$$GroupSales
     


  2. PRAPTI

    PRAPTI Member


    We are getting the final amount exclusive of taxes..Can't we get the amount inclusive of taxes.
     


  3. sseema

    sseema Member


    we can get by formula
     
    panam and Karthick MS like this.


  4. PRAPTI

    PRAPTI Member


    Will you be kind enough to add that formula here??
     


  5. Mohamed Ajmalkhan

    Mohamed Ajmalkhan New Member


    Need Total Kgs
     


  6. panam

    panam Member


    dear friends,
    i have modified this code" Today's total sales " .
    Made few minor improvements
    This credit goes to the original developer. Also I am very much thankful to all members, developers,experts who supported me in learning the codes especially Amit sir.

    The updates are as follows:
    1. First this code was not working in pos voucher: Now it is working fine.(see the screenshot )
    2. secondly the total sales field was appearing in purchase voucher also: now ,it works only in sales voucher.

    I need further help from experts to enhance this code code to the next level.
    1. help needed to skip (i.e jump) the field "total sales" to name of stock item.
    now the problem is that the cursor will stay in the field "total sales".
    i tried to add this line in code for skipping
    [#field:Amount Field]
    skip :yes
    it works fine but the problem is that it also skips in ei value field.(because of declaring #field:Amount Field)

    2.we should get the amount inclusive of taxes.





    please help me.


    [#part :VCH Title2Left]
    Option: TotSales:mad:@isSales
    [!Part:TotSales]
    Add:line:AtEnd :Totsales
    [line : TotSales]

    Invisible : NOT ##CurBalanceFlag
    Field : Simple Prompt, Amount Field
    Local : Field : Simple Prompt : Info : $$LocaleString:"Total

    Sales:"
    Local : Field : Simple Prompt : Width :10
    Local : Field : Amount Field : Set as : @@TrsTotSales
    Local : Field : Amount Field : width :10
    Local : Field : Amount Field : color :Black
    Local : Field : Amount Field : style:Bold
    ;;[#field:Amount Field]
    ;;skip :yes


    [System : Formula]

    TrsTotSales : $$FromValue:$Date:$$ToValue:$Date:

    $CreditTotals:Group:$$GroupSales
    ;$$ToValue:$Date:$CreditTotals:Group:$$GroupSales
     

    Attached Files:

    Last edited: Oct 18, 2020


  7. Himanshu-2002

    Himanshu-2002 Active Member


    It sounds really good that You modified code on your own But Your Requirements are not very clear for me So, Can you explain me a bit more ? And My suggestions is to watch Tally Solutions videos on TDL To learn this Language Better
     
    panam likes this.


  8. panam

    panam Member


    The cursor stays on the created field " Total Sales".
    i want the cursor to skip to next line while we are passing the voucher entries in tally
    after every new vouchers, the cursor stands in this field " Total Sales".
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use like this........

    Local : Field : Amount Field : Skip : Yes
     
    panam likes this.


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    For rate Inclusive, there are inbuilt methods given in Default Tally. You need to set up your StockItems accordingly.

    Please learn How-to-Do videos from Tally's website on topical n subjective help.
     
    panam likes this.


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Local : Field : Simple Prompt : Skip : Yes
     
    panam likes this.


  12. panam

    panam Member


    dear Amit sir, Thank you very much for the help.
    i tried this code earlier but it was not working. i was always refreshing the tdl by refresh Tdl.
    after restarting tally ,it is working fine.
     


  13. panam

    panam Member


    Dear Amit sir, now the code is working fine.
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yeah...sometimes Tally behaves crankily......

    Now onwards you will have to refer to Developer, we will direct / point you.... bust such little and simple codes you should be able to do it on your own. R&D and search abilities is also equally important as learning TDL.
     
    panam likes this.


  15. panam

    panam Member


    dear sir, I want inclusive of tax rate calculation for this above code in udf Total sales.
    as per this code The total daily sales showing without taxes.

    I need the the sales amount with tax amount in the newly created Udf: Today's total sales not in stock item.
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Try finding the same in the Developer..........

    Who gave the Sales formula to you or from where did you get it ???

    HINT : Try --- ClosingBalance
     
    panam likes this.


  17. panam

    panam Member


    dear sir,
    how to add both group in :$$GroupSales and $$GroupDuties

    [System : Formula]

    TrsTotSales : $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupSales and $$GroupDuties
     


  18. panam

    panam Member


    dear experts,

    i am trying but result is not coming...

    [System : Formula]

    TrsTotSales : $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupSales AND $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group$$GroupDuties
     


  19. sandip kumar

    sandip kumar New Member


    instead of AND use +
     
    panam likes this.


  20. panam

    panam Member


    sir, i tried + also not working
     


  21. sandip kumar

    sandip kumar New Member


    TrsTotSales : $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupSales+$$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group$$GroupDuties
     
    panam likes this.


  22. panam

    panam Member


    thank u Sandeep ji for your valuable reply.
    now the code is working fine.
    i want to make extra bold in this UDF.
    i gave as Local : Field : Amount Field : style:Large Bold
    but Large Bold not working.
    please help me.
     


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    While dealing with in-built Tally codes ------- You have to find the Parent...the BAAP and their Baap and so on............

    Somewhere there will be a definition in Line / Part or FORM level....... "small size form / part /line" ...... and since this is defined at a HIGHER heirarchy, any changes in the field level will NOT overcome this definition.
     
    panam likes this.


  24. panam

    panam Member


    Thanks Amit sir for Your valuable guidance and reply.
    now, i am very happy after learning the codes from this forum.
    Earlier i taught that only software developers can do the tdl codes for tally.

    sir, i am tally user from 14 years, now only i tried to learn codes.
    i have zero knowledge in tdl.
    But now i have little confidence to do small tdl codes after joining this forum.
    further i will be learning the new things through this forum with your support of everybody.
     


Share This Page