Customer Ageing - by posting period

205 Views

Hi All / Expert,

I'm facing the customer ageing which I want to display by posting date (parameter in selection criteria) but the total not accruate. The total ageing already reconciled with payment (amount minus payment = remaining balance).

Scenario

1. Display ageing for as at 31.3.2008

Ageing date :31.03.2008

Posting date :1.1.2008 to 31.3.2008

Total ageing :RM 100,000.00

2. Payment on 5.4.2008 is RM 50,000.00

3. 1. Display ageing for as at 14.3.2008

Ageing date :31.03.2008

Posting date :1.1.2008 to 31.3.2008

Total ageing :RM 50,000.00 *

In accounting normal practise it should be display

RM 100,000.00 not RM 50,000.

I dont know what programming or system logic how this customer ageing work.I guess the default by system date not by posting date.

Anyone can tell me how customer ageing calculate the total ageing? Please help me, my client always blame me for this issue. I'm very appreaciated your help.

Thanks in advance.

uddin