I need to make a customized A/R aging report over 720 days in 30 day buckets. I have 3 other aging reports that are all under 365 days. I have coded the 720 day aging the same as the other 3. The 3 under 365 day reports, all buckets match, the reports are good. With the 720 report the buckets are off by maybe 2 or 3 buckets, and the problem can be verified by a number or 2 going to one buckets or the other as if the Microsoft is not paying attention to the 365 day rule. And it is usually the 30-60 and 60-90 day buckets that are off. Because this is happening in the early buckets that are visible on all reports, the 720 report is wrong. I have even gone as far as taking out the CALCDATE command and treating the buckets and dates as numbers, thinking if the calcdate was not used this problem would not exist, however that is not true either. Has anyone ever ran into this before? How do you handle this problem?
*This post is locked for comments
I have the same question (0)
