...
The following is an example for ARTran using the Upsert feature.
...
Data Models
The following is an example of Data Models gather and transform raw data into fast and ready-to-be-reported information. They work as the single version of the truth defined in the DataSelf Server-side components (ETL+, data warehouse, Power BI models, and/or Tableau data sources). All reports, dashboards, and KPIs derive information from their data models. Changing the data model will automatically reflect the new rule across all reports and dashboards. For instance, a simple change to the Gross Profit data model calculation to absorb freight, and next time, reports and dashboards will automatically show GP with freight absorbed.
The following exemplifies how Acumatica _AR_Aging_Today tables are linked in DataSelf’s out-of-the-box templates. This linking applies to Tableau data sources, Power BI data sets, Excel, and other reporting tools.
...
The following is part of the Cash Flow Projection data model using a T-SQL expression in ETL+. It gathers and transforms cash on hand today, plus expected inbound cash (such as from AR and SO), minus expected outbound cash (such as from AP, PO, and payroll) forecasted into the future.
...
Key Words: Generic Inquiries, Generic Inquiry, GIs
...