14.11.2017, 23:12 | #1 |
Участник
|
stoneridgesoftware: Management Reporter – Reporting Amounts by Each Day of the Month for an Accounting Period
Источник: https://stoneridgesoftware.com/manag...unting-period/
============== I had a report request in Management Reporter, to show revenue by each day of the month at the row level. I had to think about how to design it, so I could make this automatically pick up the correct days of the accounting period without going into the row or column definition and changing the dates every month. Below is how I designed the report to deliver the customer’s request without modifying the report each month. Column Definition: I created this for one week, but can easily expand it to a full month. Key things to point out
Row Definition: Because the customer did not want the Revenue going across in columns, I had to use the ‘CAL’ (calculation) Format Code to get the amounts to show in each row.
Report view to verify amounts: Before changing Print Control to ‘NP’ Report view of Customer’s request: After changing Print Control to ‘NP’ Источник: https://stoneridgesoftware.com/manag...unting-period/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору. |
|
|
|