0
0 Comments

Hi Erik,
I have been asked to make a small adjustment to report 106 – Customer Detailed Aging.
The current report shows the overdue time in months. We would like to see it in days.

I am trying to add a calculated field to report 106 with the Simple Object Designer, but am encountering a problem.

I manage to create a Calculated Fields record for:
Report No. 106
Report: Customer Detailed Aging
Data Item: Cust. Ledger Entry
Name: AboutDueDays
Type: Date

If I use the “Edit Expression” and then enter the “Cust. Ledger Entry.”Due Date” field via the “Cheat sheet”, the “verify Expression” does not work.

When I use the expression “CalcDate(‘<5D>’,Cust. Ledger Entry.”Due Date”)” the “Verify Expression” gives an error.
“You cannot base a date calculation on an undefined date.

Date: 0D
Formula: 5D.”

It seems that the database fields are not accepted. What I actually want to achieve is calculate the difference between today() and Cust. Ledger Entry.”Due Date”
Can you help me?

Thanks,
Paul


								


								
Question is closed for new answers.
Paul Wouterse Selected answer as best August 22, 2024