Get Classic GL Balance
In order to extract a General Ledger balance when Classic GL is configured within SAP, the Get Classic GL Balance function is used.
| Parameter | Description |
|---|---|
| Year | A value, e.g. “2017” |
| Period | Period number e.g. “1” |
| Balance Type | YTD – summarizes the full year balance up to the period parameter input
PTD – summarizes the movement for the period parameter input QTD – summarizes the movement for the quarter based on the period parameter input CTD – summarizes the custom period criteria based on the period parameter input e.g. “2:4” |
| Ledger | Ledger ID e.g. “00” |
| Actual Flag | A = Actual; B = Budget |
| Version | If you have selected Budget values, enter the applicable Version. The wizard will automatically insert the correct version for Actuals. |
| Currency Type | The Currency Type as configured in SAP e.g. “10” = Company Code Currency; “30” = Group Currency |
| Company Code | The Company Code(s); It is important to note that all company codes selected for a single formula must have the same currency code for the currency type selected, share the same chart of accounts, as well as all belong to the same controlling area. |
| GL Account | A single value representing a child or group; a range of child values; a list of child or group values; child values to be excluded; or any combination of the preceding value inputs |
| Business Area | Optional |
| Alternative Account | Optional |
| Currency | Optional, unless Document Currency is chosen as Currency Type |
| Movement | “D” = Debit; “C” = Credit’ blank or “*” for both Debits and Credits |