I have a report with the following fields that is currently running through Sage BI from our Sage 300 system:
| REPORTNAME |
| [ACCTSETNAME] |
| [AUDTORG] |
| [CATEGORY] |
| [CATEGORYNAME] |
| [CONAME] |
| [CUSTGROUP] |
| [CUSTGROUPNAME] |
| [CUSTNAME] |
| [CUSTOMERCODE] |
| [DATA] |
| [DOCDATE] |
| [DOCNO] |
| [FISC_PERIOD] |
| [FISC_YEAR] |
| [IDACCTSET] |
| [ITEMCODE] |
| [ITEMNAME] |
| [ORDER_TYPE] |
| [QTY] |
| [QTY_BUDGET] |
| [QTY_BUDGET_YTD] |
| [QTY_PRIOR] |
| [QTY_YTD] |
| [QTY_YTD_PRIOR] |
| [S_BUDGET_AMT] |
| [S_BUDGET_AMT_YTD] |
| [SALES_AMT] |
| [SALES_AMT_PRIOR] |
| [SALES_AMT_w_DISC] |
| [SALES_AMT_w_DISC_PRIOR] |
| [SALES_AMT_w_DISC_YTD] |
| [SALES_AMT_w_DISC_YTD_PRIOR] |
| [SALES_AMT_YTD] |
| [SALES_AMT_YTD_PRIOR] |
| [SALES_COST] |
| [SALESPERCODE] |
| [SALESPERNAME] |
| [REPORT_GRP] |
| [UNIT_GRP] |
| [IDCUST_CUSTNAME] |
| [SPACER] |
| [SALES_COST_YTD] |
| [FISC_QUARTER] |
| [QTY_BUDGET_QTD] |
| [QTY_QTD] |
| [QTY_QTD_PRIOR] |
| [S_BUDGET_AMT_QTD] |
| [SALES_AMT_QTD] |
| [SALES_AMT_QTD_PRIOR] |
| [SALES_AMT_w_DISC_QTD] |
| [SALES_AMT_w_DISC_QTD_PRIOR] |
| [SALES_COST_QTD] |
Are these fields familiar to anyone? Any help or input on how to handle finding the direct tables to build this in PowerBI?
Any help would be greatly appreciated.
