S_ALR_87012050 does not tie to G/L

[former_member857785]

Hello Guru's.,

I am struggling with this puzzle. I have 2 line items appearing in G/L (same asset) but only 1 is appearing on S_ALR_87012050 report.

I searched here in the network and saw that where someone else was having the same issue but was resolved by looking at S-ALR_87011990. It did not appear there either.

What could be the cause or reason as to why we are not seeing the asset in reports but are found in the G/L? They were entered together and the only difference I see is that item that is not found in the report has a quantity of 8- and the other has no quantity defined under the transaction.

It was quoted in the network that the 2050 report does not include transfers, disposals or brought forward balances and that the 1990 report would show it. It does not.

Please help!

[zeeshan_xt · Accepted solution]

I had the same problem where report S_ALR_87012050 wasn't tying to FAGLB03 (GL report). All I had to do was include ALL transaction types when i run report S_ALR_87012050. That resolved the issue and the report now matches.

[Former Member]

Can you see the posting in the acquisition GL account and tell what is the asset transaction type for both the transactions? You can alternatively give this information from the asset explorer screen.

regards,

Vishal.

[former_member857785]

170 for the transaction type not on the report

120 for the transaction type on the report

both are on G/L

170 is a transfer however I do not see it on the Historical report either (S_ALR_87011990)

Where would I see these transactions?

Thanks!

[Former Member]

I have encountered such issues with other asset reports. I overcame those, by specifying i.e. including or excluding certain transaction types in the selection screen. Try doing that. It may fix the issue for the time being.

regards,

vishal.

[former_member857785]

Is there documentation that shows what reports include what transaction types?

I am afraid we were not given this knowledge by our partner during implementation.

Thanks!

Still can't find a report that includes transaction type 170 (transfer). Any help would be greatly appreciated.

[Former Member]

Hello AMS,

Please use transaction code: S_ALR_87012039 ( Asset Transaction). Once you execute this report, click on "Change Layout" and then click on Position you will see the transaction type listed over there which you can use. There is even Transaction Type on the main selection screen if you click on All Selections which is the 4th tab counting from the "Execute Button" from left to right.

Regards,

Elias

Edited by: Elias Akorli on Mar 22, 2010 12:57 PM

Edited by: Elias Akorli on Mar 22, 2010 1:00 PM

[Former Member]

AMS,

I have not come across any documentation which gives the Transaction type inclusion/exclusion information. Almost all asset reports are ABAP queries and they are made using logical database 'ADA' in asset accounting. As such, you cannot modify the default transaction type selections, if you are thinking to do so.

I would recommend you to read 'Reporting for SAP Asset Accounting' authored by Thomas Michael published by SAP Press. It will give you good overall understanding about Asset reporting.

regards,

Vishal.