Define Off Set Ac in FBL Reports

Offsetting Account Display in FBL
Reports
Applies to:
SAP Financial Accounting. For more information, visit the Enterprise Resource Planning homepage.
Summary
Offsetting account display in FBL reports for easy reconciliation purpose.
Author: Praveen.J
Company: Kaar Technologies India Pvt Ltd, Chennai
Created on: 22 October 2010
Author Bio
Praveen is working as SAP FICO Consultant in Kaar Technologies. He has completed his Master in
commerce.
SAP COMMUNITY NETWORK SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
© 2010 SAP AG 1
Offsetting Account Display in FBL Reports
Table of Contents
Overview ............................................................................................................................................................. 3
Define the Business Transaction ................................................................................................................................. 3
Define the function module for Business Transaction Event ........................................................................................ 5
Display offsetting entries in FBL* reports ..................................................................................................................... 7
Related Content ................................................................................................................................................ 10
Disclaimer and Liability Notice .......................................................................................................................... 11
© 2010 SAP AG 2
Overview
Every customers requirement is check the offsetting entry while displaying line items balance in FBL reports.
The below steps will show how to configure the offsetting entries in the standard report without any ABAP
requirements.
IMG  Financial Accounting  Financial Accounting Global Settings  Business Transaction Events
Define the Business Transaction

The user has to do the following settings in the Business Transaction, Execute the Business Transaction
Events.
© 2010 SAP AG 3
Go to Settings  Products …of a customer
Click
Product: ZFBLOFF (User Define field)

Text: Offsetting GL display in FBL* Reports (User Define field)
Activate: Check box
And Save
© 2010 SAP AG 4
Define the function module for Business Transaction Event
Go back
Select Settings  P/S Modules  …of a Customer
Click
© 2010 SAP AG 5
Event: 00001650
Product: ZFBLOFF (which has been created in the previous step)
Function Module: LINE_ITEMS_GET_GKNOT
And Save
Business Transaction Event has been saved.
© 2010 SAP AG 6
Display offsetting entries in FBL* reports
SAP Easy Access  Accounting  Financial Accounting  Accounts Payable  Account  FBL1N –
Display/Change Line items
Provide the necessary inputs for the report and execute.
Select Layout
© 2010 SAP AG 7
Now the user can find the Offsetting Acct no. and Offsett.account type,
Move those hidden fields into the line 1
© 2010 SAP AG 8
Now copy the fields to the display layout.
The user can see the Offsetting acct and the Offsetting acct type.
This field has some restriction that, a single document can have multiple offsetting accounts, but in this
report you can get only one account.
© 2010 SAP AG 9
Related Content
For more information, visit the Enterprise Resource Planning homepage
© 2010 SAP AG 10
Disclaimer and Liability Notice

This document may discuss sample coding or other information that does not include SAP official interfaces and therefore is not
supported by SAP. Changes made based on this information are not supported and can be overwritten during an upgrade.
SAP will not be held liable for any damages caused by using or misusing the information, code or methods suggested in this document,
and anyone using these methods does so at his/her own risk.
SAP offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this technical article or
code sample, including any liability resulting from incompatibility between the content within this document and the materials and
services offered by SAP. You agree that you will not hold, or seek to hold, SAP responsible or liable with respect to the content of this
document.
© 2010 SAP AG 11

Define Off Set Ac in FBL Reports

Uploaded by

Copyright:

Available Formats

Define Off Set Ac in FBL Reports

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Define Off Set Ac in FBL Reports

Uploaded by

Copyright:

Available Formats

Offsetting Account Display in FBL

Define the Business Transaction

Go to Settings  Products …of a customer

Product: ZFBLOFF (User Define field)

Define the function module for Business Transaction Event

Select Settings  P/S Modules  …of a Customer

Business Transaction Event has been saved.

Display offsetting entries in FBL* reports

Provide the necessary inputs for the report and execute.

Now copy the fields to the display layout.

Disclaimer and Liability Notice

You might also like