Is there a report like FBL1N where I can display all the transactions and the offsetting G/Ls?

[im12watisthis]

I use FBL1N to export all my documents in a given period to Excel so that I can convert all the data into a table that can be easily filtered and searched. I use this data to easily look up and research invoices for AP work. I'd like to be able to view all the general ledgers that I offset each document within its own column without having to individually double-click on each one--the main impetus for this would be so that I could quickly ascertain if I posted something to the wrong G/L. If not, is there a better transaction code for what I'm trying to do?

For example, this document above is an invoice for legal services. I'd like to quickly ascertain if I posted it to my legal services general ledger and not something like janitorial services. 

[sanilbhandari]

Hi @im12watisthis 

You could potentially look at FAGLL03, especially if you have S/4HANA. Your IT Colleague with Finance background can configure the system to display the offsetting entry. However, there might be challenges for those AP Invoices, where there are more than two line items (Most cases would have that way):

There are three ways to set it:

1) No Offsetting display

2) Display Offsetting account if clearly specified

3) Always display offsetting account with the highest amount

4) Always display offsetting account ( Highest amount of all lines)

Alternatively you could work with the IT Colleague to develop your own report with your business rules to display the information, the way you want to see it.

Thanks & Regards

Sanil Bhandari

[im12watisthis]

Thank you Sanil. I'll take a look at the t-code. My global IT will never do the configuration just for one user's request, so I'm probably out of luck.