Due Date in Customer Ageing Report

[Former Member]

Hi,

Running V8.8 and I want to show the Due date in the printed Customer Ageing Detail Report. System Information shows it should be Variable 50 but this does not work in the Layout Designer. Can anyone please suggest the corerct variable or formula to get this value to appear in the report.

Thanks.

[Former Member]

Thanks Gordon,

I have dug further into some of the other simple reports provided with the package and found that the Due date is System Variable 184. I put this in my report and it worked. However, the format is different to the Document date - it appears as 20111215 rather than 15.12.2011. Very frustrating! Any ideas how to show it correctly?

[Former Member]

System variable in PLD has fixed format. I have not found out any solution yet to change it.

[former_member218051]

Hi Robert,

Can you try one workaround ?

take three formula fields

insert day(date) , month(date) and year(date) functions.

Make use of your system variable for this function.

Hide that system variable.

Place the formula fields next to each other in place of a system variable.

I guess it will work.

Thanking you

Malhaar

[Former Member]

Hi,

Welcome you post on the forum.

PLD is a simple reporting tool. Customer Aging Report is one of hard coded report. You don't have option to add a field to the report. A customized report is in need such as by Crystal Report.

Thanks,

Gordon