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 |