8/29/2023 0 Comments Xl checkbook ledger![]() The Financial Balances dataset includes summaries and additional transaction information at a summarized level. The transactions within the Transaction Line object are extracted from Accounting and are then aggregated within Analytics to create the balance equivalent.Īs well as the standard fields available in the Reporting Balances object, the Financial Balances dataset includes other values which have been generated based on the transactions you have posted. The Financial Balances dataset is not a copy of the Reporting Balances object. ![]() The dataset includes fields from the Reporting Balances object such as Reporting Balance Type as well as additional fields that relate to a transaction. The Financial Balances dataset is equivalent to the Reporting Balances object in Accounting. Create your own expressions in dashboards.įor more information, contact your implementation consultant.You can add your own fields to a dataset in the following ways: Not all field names remain the same, however. Additionally, all components are labeled to make it easy for you to recognize the content. The naming convention remains as close as possible to the terminology that you are familiar with, for example, Trial Balance 1, General Ledger Account, Bank Account Name, Company Name. The dataset includes information from various objects which have been combined into one view. Similar to Salesforce reports and other reporting tools, you do not need to know the object model of the dataset. You can perform calculations on the data in Measure type fields. Measure: quantitative values such as revenue and exchange rates.You can group and filter the data in Dimension type fields. Dimension: qualitative values such as regions, product names, and model numbers. ![]() You can group, filter, and perform calculations on the data in Date type fields. Date: values such as days, months, years, and times.When creating a dataset, Analytics applies one of the following types to each field: Each dataset contains information from Accounting, Fixed Asset Management, or Planning that has been normalized and stored in Analytics. The Financial Statements app include five datasets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |