Hello everybody.

I am totally unaware of finance module & posting this thread onbehalf of my accounts department.

Our accounts department generates an aging analysis report thru session tfacp2420m000 & get the report in a no of formats.

There are always some receipts not posted to finance & accounts wants a againg analysis report which should also include unposted receipts.

i.e. Is there any standard report which include aging analysis by supplier (with posted transactions & unposted transactions)

This may be one of the absurd thread but please suggest something. Infact I don't know anything regarding finance module.

Thanks

I'm not sure what you mean by receipts not posted to finance yet. The aging analysis report only prints data which is in the open entries table in finance. Basically this is any invoices or cash in the open entries.

There are some purchase orders for which receipts are made but purchase invoices not printed. Also thse transactions are yet to be posted in finance.

These purchase orders are having status as print purchase invoices.

In other words our management analysis of suppliers based on receipt date.

There is a report tfacp1432m000 which shows orders which have been received but have not had invoices entered in Finance.

Invoices for purchase are entered manually though finance and are not posted through integration. As far as I know there is no way to age receipts which have no invoices.

Maria is right, there is no possibility to see the receipts in the aging analysis because there is no booking on liability account for it.

regards, Juli

first of all i need some clarifications

1. Do you want to see the outstanding of suppliers or customers?

2. If it is in case of suppliers, there will be no receipt from suppliers?

3. what do meant by posting or unposting? is this finalised or unfinalised transactions?

1. I want to see outstanding of suppliers with aging.

2. Receipt if made against a purchase order generated against a supplier (Vendor)

3. I want to include those purchase receipts having purchase order status as

1. Maintain receipt - Yes

2. Maintain approval - Yes or No

3. Maintain CENVAT Receipts - Yes or No

4. Print Purchase invoice - Yes or No.

More clearly I want to include purchase order having status as any of above.

Also there is one field matched as tdpur045.matc in tdpur045. I want to include the receipts having status as no.

Thanks for extending me an helping hand. Our management wants to have an debtors included in aging as soon the material is received in factory premises rather then the party's bill is booked in finance.

1. When you make a Receipt against a PO, there is no financial document generated ( only inventory entry is passed, inventory dr & PBR Cr).
2. In supplier aging only those docoument comes which are passed in finance module. (when purchase is match and approved, payment to supplier etc.)

So as per your requirement this is not feasible to see all the documents.


You can customise your own report.

as per your query regarding that your management wants that creditors updated as soon as material comes in side the premises

this is already happening, might be you have not studied the entries of receipt

when any receipt is made the entries are generated like this


Material Debit


Purchase bill to be received credit