Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from AmplesoftCorporation on Nov 25 at 2:56 PM I didn't really understand why you need to show the future sales values even when there are no sales transaction on the future dates. If the requirement is to do with Actuals and Plan sales data then the solutions is very easy on bex. In any case the solution really depends on what reporting tools you use. If you have bobj you can write a formula in the grid section to display all the days including non business days and remaining days based on the user date selection. Formula has to check the values exist on each day of the calmonth if not pre-populate the blank date with $0. It's not a very easy solution to implement in bex if it is just to do with actuals without any transactions posted for the future dates. If you have both plan and actuals then its very simple. Have plan done for the entire month and have a calday and Actuals and plan key figure in the report that way the Actuals also populate with "0" value for the days that doesn't
have any transactions but there is value in plan key figure. You could also hide the plan keyfigure if you really don't need to show and just have actuals displayed in the output of the report.
Hope that helps.
Regards,
Srikanth
www.amplesoft.com
| | | ---------------Original Message---------------
From: Omfiel
Sent: Tuesday, November 25, 2014 8:39 AM
Subject: How To Display ALL Month Dates And ALL Weekdays (Inc. Saturday) In Report?
Hello,
We need to display our sales qty actuals spread out for each day of the month, including non-working days (i.e. Saturday), while displaying the yet to come dates till month end. Problem is that we can only display those days with actuals, but report won't show future dates nor Saturdays.
Any idea how to do that?
Thanks,
OM |
| Reply to this email to post your response. __.____._ |   _.____.__ |
