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 |