I would like to create a field in Dynamics RW on the RM Aged TB w/Options that calculates the days between the current system date and the document due date. I've been puttering around for a while and just can't seem to come up with the right function set.
Does anyone know if this is possible?
*This post is locked for comments
You nailed it Leslie! Thanks!
Hi,
I think I've got it. You want a number for each invoice that says how many days past due the document is. You need a calculated field that subtracts the document due date from the current user date. you'll need to be sure to age your receivables. Here's a screenshot of my calculated field:
The user date is a global field rather than a field included in any of the report tables.
Is this what you needed?
Kind regards,
Leslie
Thanks for the quick reply Leslie - we are already using that. What we are requiring is an integer with the specific number of days to include on the report that is aging by due date.
You can change the Aging to Due date from Document date in the Receivables Setup window. You'll have to run an aging in Receivables Routines and I think it will tell you what you need to know. Instead of showing how many days from the document date, it will show you how many days since the due date.
Is that what you want
Kind regards,
Leslie
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
