Get Daily GL Balance
In order to extract a General Ledger balance for a specific date range, the Get Daily GL Balance function is used. Since this function retrieves from the GL Line Item table in SAP, there are additional parameters available within the balance function that support a more granular level of analysis, such as Document Type.
Parameter | Description |
---|---|
From Date | The beginning date, e.g. “Aug 20, 2017” |
To Date | The ending date, e.g. “Aug 27, 2017” |
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 |
Currency Type | The Currency Type as configured in SAP e.g. “10” = Company Code Currency; “30” = Group Currency |
Currency | Optional, unless Document Currency is chosen as Currency Type |
Document Type | Optional |
Posting Key | Optional |
Movement | “D” = Debit; “C” = Credit’ blank or “*” for both Debits and Credits |
Business Area | Optional |
Tax Code | Optional |
Internal Order | Optional |
Cost Center | Optional |
Trading Partner | Optional |
Project | Optional |
Profit Center | Optional |
Reference Key | Optional |
Transaction Type | Optional |