Asset Open Item aganist Vendor

[Former Member]

Dear Experts,

Please let me know if there is any report where we can see payables for asset only. I mean open item only for asset for which payment needs to Vendor.

I have tried S_ALR_87012103. I have given offsetting account type as "A". But, it is giving the output same as FBL1N report.

Please suggest the appropriate report.

Best Regards,

Thauseef Moyenddin

[former_member200703 · Accepted solution]

Hi

You may check the below doc. which describe the steps needed to add the offset account

Regards

Mahmoud

[Former Member · Accepted solution]

Dear Mahmoud,

Thank you for the document. I would refer to it.

Best Regards,

Thauseef Moyenddin

[former_member198650]

Hi Thauseef,

Have you checked the report S_ALR_87012058?

Regards,

Mukthar

[Former Member]

Dear Mukthar,

Thank you for your inputs.

I have seen this report. This report includes many intracompany asset transfer transactions and also payables for assets. There is huge data. There is no option to change layout so that I can select based on transaction type. Is there any way to segregate only payables for assets in this report.

Best Regards,

Thauseef Moyenddin

[former_member198650]

Hi Thauseef,

Unfortunately there is no filter option inside of the report. So select the transaction type 100/120 and execute it.

Regards,

Mukthar

[ajaycwa1981]

Hello

You can use FBL1N report with Offsetting account. Wherever you find the asset recon account in the offsetting account, that will be your data

You can use BTE 1650 or something to get the desired offsetting account

Ajay M

[Former Member]

Hello Ajay,

Thank you for your reply.

I have already tried in FBL1N. It is not giving any output in offsetting account type and offsetting account.

For example, accounting entry is

31        Vendor          274,500.00-

70        Asset             274,500.00

In this case, vendor line item need to capture offsetting account  for assets in the report FBL1N. But, it is not appearing. Is there any configuration for this or I am missing something.

Best Regards,

Thauseef Moyenddin

[ajaycwa1981]

Hi

You need to implement BTE 1150 to get the offsetting account

Ajay M

[ajaycwa1981]

Refer Note 112312 (BTE 1150) and Note 1504612 (BADI FI_ITEMS_CH_DATA )

[Former Member]

Dear Ajay,

Thank you for the reply. I will check this note.

Best Regards,

Thauseef Moyenddin