Skip to Content
0
Dec 17, 2011 at 09:38 AM

Customer (or Vendor) Ageing Report Problem

103 Views

Dear Experts,

Firstly, Glad to be before you.

Here, we have developed tht ageing report for Customers and Vendors.In which the Partial payment line item (let us say A) against an Invoice (lets say X) is not being shown under the same age of Invoice Line Item.

For example:

Scenario 1)

Let me say that the Payment Terms 'Z001' under which the line Items fall due only after 30 days.

I have posted an invoice on 01.09.2011 with Rs. 20000

If we run the Ageing as on 16.12.2011, the output is projected as follows:

============================================Days in Arrears

-


0-20--


20-40
40-60
--


60-80

Line Item X (Invoice)----


20000

Total Balance agewise:--


0
0

0
--


20000

Here for Invoice NO PROBLEM is being raised, as the Invoice Posting Date is taken as the Baseline Date from which the Ageing will be calculated based on Payment terms assigned to Customer in the master data.

But the Proble is when we do partial payment:

Scenario 2)

Let me Take the same example:

Let me say that the Payment Terms 'Z001' under which the line Items fall due only after 30 days.

I have posted an invoice on 01.09.2011 with Rs. 20000 (Due by 77 days as on 16.12.2011)

We have received payment of 8000 against the invoice, on 22.09.2011 (due by 55 days as on 16.12.2011)

now the Ageing report is ran on same 16.12.2011, for which the output is as follows:

============================================Days in Arrears

-


0-20--


20-40
40-60
--


60-80

Line Item X (Invoice) -


20000

Line Item Y (Partial Pyment)----


(8000)

Total Balance agewise:--


0
0

(8000)
--


20000

As per Technical logic whats happenning is correct. Because the Base Line date of the partial payment line Item is being picked from the posting date of the same. BUT NOW, THE REQUIREMENT IS AS FOLLOW:

The wants to see the related Partial payment items also in the same AGE in the report. i.e., we should make the system pick the Baseline date of the partial payment line item(Y) from the posting date(01.09.2011) of the other line item(X) i.e., from the Invoice(X) which is being partial cleared. Can you please suggest me a logic?

Ramana.Gottipati