Category: Reporting
Indicator to specify single page or multi page customer statements
Recently, I was assisting a forum user, who had requested an option to provide a visual indicator in the footer of the customer statement report, which indicates if the statement has a single page or multiple pages. After a little thought I had come up with this idea and replied back to the forum user [...]
Recent Updates to Payables HATB Script
Hi all I have posted an updated for the following scripts today. Please make use of these updated scripts for the historical aged trial balance in payables. AP Historical Aged Trial Balance – By GL Posting Date http://msdynamicstips.com/2010/10/09/payables-hatb-report-sql-query/ AP Historical Aged Trial Balance – By Document Date http://msdynamicstips.com/2010/10/08/payables-hatb-using-document-date/ Hope this update helps the community… Until [...]
Excel Pivot Table – Filling Blank Cells
Hi all Pivot table is most common reporting mechanism used by many users for generating analysis reports. When using Pivot Tables frequently you probably realized it is not very handy to copy the data out of the pivot table and then go line by line and fill all the gaps in the columns from Row [...]
Adding/Removing Reports to/from My Reports
Hi all Recently I was working with a community user on an issue where the user was facing an issue in adding reports to the My Reports section on the home page. So I decided to write up this article which throws some light on to how we can add/remove reports to/from the My Reports [...]
Loading ...