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 Month wise Net sale and Collection - on Pressing enter it will take to Sales register Party wise - Month wise - Sales and Collection with DSO Period - on pressing enter on party line it will take to Party Ledger voucher
Dear Niravji Thanks for sharing... I am not getting full year Sales Amount (Screenshot attached) And also taking time to load "Party/Month wise Sales and Collection" Please reply.
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......
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.
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.
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.
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
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.
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
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.
Code is already there.... shared by Nirav.............. Bipinbhai learned and made as per his own...........so can you. Feel free to innovate.
Yes Amitji I have not tried, but after your post I checked and It is working for ODD period also... Once again Thanks