Where can I go to get the prior quarters sales. I need it for the DSO (Days Sales Outstanding) calculation:
AR Current Balance/ (Prior quarters sales/90)
I have looked at RM00104, but have no real idea what the columns mean (or even if that's the right table)
*This post is locked for comments
Alright that got me what I wanted. Year and quarters. Now how do I figure out what quarter I'm in?
The interesting thing about periodid is that it is by month (or so it seems). so far there are values 1-7 in the rows.
Have a look on the below link.
dynamicsgpblogster.blogspot.in/.../smartlist-builder-sales-summary-by.html
Note: The above link may not provide exact solution for your requirement. But, I hope this will helps you to achieve the same.
Hope this helps!!!
You'll have to calculate that value. It would probably be easiest to create a view that summarizes the data in RM00104 into quarterly buckets. Have a look at ww.victoriayudin.com to see if she has any reports or views available that provide what you're looking for, or at least provide a starting point that you can build on.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
