Customer ageing report

[ficoconsultant99]

Dear All,

I checked in SCN and did not find answer for my query so posting here.

This is with reference to customer ageing report,

we are developing z report for customer ageing since we could not get customer specific report either through standard transaction or FDI4/FDI0 level.

So, we are developing Z report for customer ageing.

My doubt is, case where Customer is also a vendor

in BSID table we can get customer open item balances. which means  due and not due balances. This is clear.

but how to bring Net off  balances (customer open items - vendor open items)  into ageing report like (0-30, 31-60, 61-90, 91-120 & >120).

Kindly share the ideas to get net off balances into ageing.

also let me know how would I confirm that my zreport showing the correct values.

Thanks in advance.

Regards,

Ganesh

[ficoconsultant99 · Accepted solution]

I have a doubt on customer ageing standard report balances Vs BSID table balances.

Details:

I am running this report for only one company code

customer ageing report - S_ALR_87012168 showing balances as below.

Due - 8,179,683.54

Not due - 763,705.90

Total balance - 8,943,389.44

when I go to BSID table: i have given same company code which i have given for standard report above also.

but total local currency value is showing value  130,093,609

Now which one is correct since both are SAP standard.

How can I cross check with report S_ALR_87012168 values and with BSID table values.

Please share your ideas on this query.

Regards,

Ganesh

[Former Member · Accepted solution]

Hi Ganesh,

When you view the total value in the Table BSID. Check that the debit and credit value are shown with positive value.

So, in the time of Z report get the formula for Local currency amount.

If Field : SHKZG = "H" then value will be negative.

With regards,

Uttam Maity

[ficoconsultant99 · Accepted solution]

we did that logic too.

we are bringing values considering debit and credit. Means is that, if the balance is negative we are bringing or positive we are brining.

please tell me how to match S_ALR_87012168 report values with BSID table?

[Former Member · Accepted solution]

The report S_ALR_87012168 will be executed by giving analysis date.  Based on that date all open items system will analyze payment terms and update the customer balances to the respective aging bucket.  

BSID table will give you all the open item list.  We can't directly validate due and not due items from BSID tables.  Alternatively, you can use FBL5N transaction with report for validation of open items.

Thanks

Srilaxmi. 

[ficoconsultant99 · Accepted solution]

Hi Laxmi,

My z report is matching with standard report - S_ALR_87012178. So, I understood that Z report is giving correct values (these values does not include the scenario where customer is also a vendor).

I am still not sure how can we match BSID table balances with S_ALR_87012168 report balances????

where customer is also a vendor, i am not still clear on this how to bring values into report.

please reply with more details

[ficoconsultant99 · Accepted solution]

Hi All,

logic to bring vendor line items into Customer ageing in order to get the net off balances.

Take company code, customer number and vendor number from KNA1 table.

Pass above fields into BSIK table and get vendor line items

Check for the vendor line items due date (current date - payment term days=net due date)

ageing days: current date - net due date

fill the 0-30, 31-60, 61-90, 91-120, 121-9999 based on the net due date calculated in previous step.

so, ageing report will have customer line items as well vendor line items but when we see the totals, it is net off balances.

my query is resolved now. we are able to get values into report properly.

Thanks all.

[ficoconsultant99 · Accepted solution]

small correction on this:

(current date - payment term days=net due date)

base line date + no days (payment term days) = net due date.

[ficoconsultant99]

Hi All,

I tested one scenario like where customer is also a vendor and posted invoices through F-22 & F-43.

When I check the BSID - table only customer open items alone are there and same way when I check BSIK table only vendor open items alone are there.

I understand that, net off balances can't be bring into customer ageing report whether it is standard report or z report.

we can only see the balances either in FBL5N or FBL1N by selecting vendor/customer to see open item net off balances.

Please correct me if I am wrong.

[Former Member]

Hi Ganesh, We can get net-off of customer vs vendor balances if you can follow as below. 1. From the customer master given in the selection parameter, the program has to check for vendor number. 2. Extract the open items of that vendor from BSIK table. 3. Extract the open items of customer from BSID table. 4. using formula in the report , based on baseline date and payment terms of the customer and vendor master....values can be set-off and updated to the respective age wise bucket. Thanks Srilaxmi

[ficoconsultant99]

Thank you Laxmi.

we will try that possibility and check.

Meanwhile can you check my another query here and help me if with your idea, please.

[Lakshmipathi]

Already couple of following standard tcodes are there

• S_ALR_87012168      Due date analysis for open items
• S_ALR_87012178      Customer open items analysis by balance of overdue items
• S_ALR_87012174      List of customer open items

and I am not sure, whether you have come across with these tcodes.  Go with standard as much as possible instead of reinventing the wheel.

G. Lakshmipathi

[ficoconsultant99]

Thank you Lakshmipathi but these t.codes we tried and did not suit with customer requirement therefore developing z report.

Looking forward to get the ideas on the same query .....