Get Offsetting Account
In order to extract the Offsetting Account for an Accounting Document, the Get Offsetting Account function is used. This function is best leveraged by inserting a column in a GL Line Item drilldown template, then building the formula.
| Parameter | Description |
|---|---|
| Company Code | Company Code |
| Document Number | The SAP Accounting Document Number |
| Line Item | The SAP Accounting Document Line Item |
| Year | The Posting Year |
| Return Type | Returns either the Account or the Account Type into the specified cell |
| Offsetting Account Determination | The Offsetting Account can be determined by any of three different sets of logic (the recommended default is #3):
1 = Display offsetting account if clearly specified 2 = Always display offsetting account with the highest amount 3 = Same as logic #2, but including line items generated automatically |