Cash Sales Report

Discussion in 'Free Source Codes' started by vaibhav jindal, Mar 21, 2019.

    

  1. Code:
    [#Menu: Gateway Of Tally]
    
    Add : Item :Cash Sales Report : Display : Cash Sales Report
    
    
    [Report: Cash Sales Report]
    Form : CashsalesReport
    ;Object : Company
    
    [Form: CashsalesReport]
    Part : CashsalesReportTitle, CashsalesReportDt1
    height : 100% Screen
    Width: 100% Screen
    [Part:CashsalesReportTitle]
        Line: CashsalesReportTitle
        [Line:CashsalesReportTitle]
            Field:CashsalesReportTitle
            [Field:CashsalesReportTitle]
                Use: name field
                Set as: "Cash Sale Report"
                Full Width:Yes
                Style:  Small Bold
                Align:Center
               
    [Part:CashsalesReportDt1]
        Line: cashsalestitleline,CashsalesDtLine
        Repeat:CashsalesDtLine:Cashsalescoll
        Common Border:Yes
        Scroll:Vertical
        Border : Thin Left Right
        [Collection:cashsalescoll]
            Type: vouchers:vouchertype
            Child Of:$$VchTypeSales
            Belongs To: Yes
            Fetch: date, vouchernumber, basicbuyername, amount
            Filter:onlycashEntries
           
    [System:Formulas]
        onlycashEntries: $$IsLedOfGrp:$partyledgername:$$GroupCash
    [Line:cashsalestitleline]
        Field: cs sno, cs billdate, cs billno, cs partyname, cs totalbillamt
        Local:Field: cs sno:Set as: "S.no"
        Local:Field:cs billdate:Set as: "bill Date"
        Local:Field:cs billno:Set as: "Bill No."   
        Local:Field:cspartyname:Set as: "Party Name"
        Local:Field:cs totalbillamt:Set as: "Total Bill Amount"
        Border : Thin Left Right  bottom
       
    [Line:CashsalesDtLine]
        Field: cs sno, cs billdate, cs billno, cs partyname, cs totalbillamt
        [Field: cs sno]
            Use:number Field
            Set as: $$Line
        Border : Thin Left Right  bottom
       
    [Field: cs billdate]
        Use: uni Date Field
        Set as: $date
        Border : Thin Left Right  bottom
        [Field:cs billno]
            Use:name Field
            Set as:$vouchernumber
            Border : Thin Left Right  bottom
    [Field: cs partyname]
       
        Use:name field
        Set as:$basicbuyername
       
    Border : Thin Left Right  bottom
    [Field: cs totalbillamt]
        Use:amount Field
        Set as: $amount
        Border : Thin Left Right  bottom

    credit goes to Orignal Devolper
    Orvolo
     


  2. Jay kumar tailor

    Jay kumar tailor Well-Known Member



  3. ONKAR

    ONKAR Active Member



  4. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Also try this one & Enjoy........
    And try to learn with this code.also try to modify fields and try to make something different from this. No matter that you are beginner or started later. Practice Works Always. Happy to Help.
     

    Attached Files:



  5. ONKAR

    ONKAR Active Member


    thank your jay sir, good to see your reply and a kind word, makes me happy. :):)
     


  6. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    With Cash Customer Address, Contect Numbers
    Ledger name/ Buyername /Address

    upload_2019-3-28_9-24-56.png
     
    Last edited: Mar 28, 2019
    Murari Bajaj and sandeep76out like this.


  7. rajiv jain

    rajiv jain Member


    nice where is the code
    share it
     


  8. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Already posted
    Just Try to modify
     


  9. MZMS

    MZMS New Member


    Sir Please Add GST Details for Cash Sales
     


  10. G Vijay

    G Vijay Member


    Hi Sir,
    How to get the second line in this report?, (Like received cash from party A-500, Party B,-1500, total 2000, accounted in single entry.)

    Thanks in Advance
     


  11. indra kumar

    indra kumar New Member


    how use filter in cash sales report
     


  12. sanjaykpt

    sanjaykpt New Member


    Not worked in Tallly Prime
     


  13. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Learn and Change According to Prime.

    Like Part,Lines Changed in Prime by Tally
     


Share This Page