Party wise / Month wise Sales & Collection ( DSO report )

Discussion in 'Free Source Codes' started by NiravMerchant, Jun 19, 2021.

    
  1. NiravMerchant

    NiravMerchant Member


    Hi Every one,

    As per user Requirement we have created this report which is very useful for Most of the Organization
    Module Consist of 2 Reports

    1)report show Party wise / Month wise Sales & Collection report and Day Sales Outstanding (DSO) Period
    2)Month wise - Net sales and Collection

    Requirement
    1- as the first report is a Matrix Report requires 64Bit system with 8 GB ram for Good Performance

    attached is full code of the same

    any suggestion welcome

    Report Can be Found in Display Menu

    upload_2021-6-19_20-26-55.png upload_2021-6-19_20-27-15.png
    Month wise Net sale and Collection - on Pressing enter it will take to Sales register
    upload_2021-6-19_20-28-2.png

    Party wise - Month wise - Sales and Collection with DSO Period - on pressing enter on party line it will take to Party Ledger voucher

    upload_2021-6-19_20-35-25.png
    upload_2021-6-19_20-36-41.png
     

    Attached Files:

    Gagan Jyoti likes this.


  2. NiravMerchant

    NiravMerchant Member


    Just a Minor change in Code
    please use this Code
     

    Attached Files:

    Gagan Jyoti likes this.


  3. anish

    anish Member


    Thank you so much sir for the nice share !
     


  4. udaya

    udaya Active Member



  5. subash pal

    subash pal Member


    Super..............
     


  6. Bipin Damania

    Bipin Damania Active Member


    Dear Niravji

    Thanks for sharing...

    I am not getting full year Sales Amount (Screenshot attached)

    upload_2021-6-20_16-5-36.png

    And also taking time to load "Party/Month wise Sales and Collection"

    Please reply.
     
    panam likes this.


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    remove all "0" with 0 (without quotes)
     
    panam likes this.


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It is taking time, due to Collection structure. It needs to be fine tuned.
     
    panam likes this.


  9. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Why no use of Tally columnar reports ???.. they are fast :):)
     
    panam likes this.


  10. panam

    panam Member


    great tdl.
     
    Devendra_Rawat likes this.


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You need to have a dynamic "# of days" .... also all data should be as per the period.......DSO analysis can be daily, weekly, monthy etc......
     
    panam likes this.


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    for DSO analysis ... Sales in Cash is immaterial......... as Cash Sales implies immediate settlement and hence no relevance to DSO.
    So you need to exclude CASH SALES.

    Similarly your RECEIPTS includes non-Debtors/Sales receipts...... which you need to exclude.
     
    panam likes this.


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In monthly summary.......
    You monthly Sales figures are proper, but the bottom TOTAL does not match the figures above.

    for Receipt column.......... the TOTAL is matching.... as per monthly figures above..........BUT it still includes non-Debtor receipts.
     
    panam likes this.


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Also since receipt is immaterial in DSO....you can show the same in EXPLODE manner...this will make your report more compact.

    ABOVE ALL are suggestions, since you asked for it...... I have made a similar report.... but with StockItem and Sales forecast. Look up the same in this Forum.
     
    panam likes this.


  15. NiravMerchant

    NiravMerchant Member


    Hi Thanks Everyone

    I will surely work on suggestions
     


  16. Bipin Damania

    Bipin Damania Active Member


    MSRSUM.png MSRSUM.png DSO Anaysis Report.png MSRSUM.png DSO Anaysis Report.png

    Modified as per Amitji's suggestions
    1) Cash Sales Removed
    2) Other Receipts also not showing in the Receipt Summary
    3) Based on Period No. of Days for DSO calculation
    4) Option to Show & Hide Receipt in Same Column in DSO Analysis Report
    5) Column for Standard & AR method
     
    Amit Kamdar likes this.


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Wah Bipinbhai.........Congrats

    Now this is what is called a true 'analytical" report.... clear, concise and eye pleasing. Also calculations are correct and as per industry norms.
    My suggestion for 2 method calculations, was that it can be used by companies as per their business model.

    Well done and great efforts. keep it up.
     


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Monthly Sales/Receipt summary serves no "analysis" purpose. However I think you have understood and implemented the DSO analysis perfectly and so is your presentation. This is exactly what i had envisaged and you have executed it perfectly.

    On a personal note...... as a Consultant/Professional........... I always recommend to my clients on what "NEEDS to be" and not what they want. We can implement what they want but in a cultured, concise and logical manner.....

    Well done...once again
     


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    BTW........... Is it working for ODD periods ?????

    ....... e.g. 15-July to 14-Aug........... with proper balances and Opening Values also

    The "# of days" on the top right corner is a nifty idea........giving visual inspection to users.
     
    Bipin Damania likes this.


  20. subash pal

    subash pal Member



  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Code is already there.... shared by Nirav..............
    Bipinbhai learned and made as per his own...........so can you.

    Feel free to innovate.
     
    subash pal likes this.


  22. Bipin Damania

    Bipin Damania Active Member


    Yes Amitji
    I have not tried, but after your post I checked and It is working for ODD period also...
    Once again Thanks

    upload_2021-7-6_15-37-33.png
     
    Amit Kamdar likes this.


Share This Page