Get Daily Customer Balance
In order to extract a Customer balance for a specific date range, the Get Daily Customer Balance function is used. Since this function retrieves from the Customer 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. The usage of Customers firstly requires a change within the User Options.
Within User Options in the GL Wand ribbon, tick the “Use Customers” box. Then Save and click the Change Company Code button from the GL Wand ribbon to re-initiate the login process.
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. |
Customer | A single value; a range of values; a list of values; 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 |
Special GL Transaction Type | Optional |
Line Item Status | Optional |
Open At Key Date | Optional |
Line Item Type | Optional |
Authorization Objects
Authorization Object | Description |
---|---|
F_BKPF_KOA | Accounting Document: Authorization for Account Types |
F_BKPF_BED | Accounting Document: Account Authorization for Customers |
F_SKA1_BUK | G/L Account: Authorization for Company Codes |
K_REPO_CCA | CO-CCA: Reporting on Cost Centers/Cost Elements |
K_CCA | CO-CCA: Gen. Authorization Object for Cost Center Accounting |
K_PCA | EC-PCA: Responsibility Area, Profit Center |