Sage 100 Reports for QA Review
Quality Assurance – compare reports from Sage 100 to reports from Tableau based on data from DataSelf’s data warehouse.
See https://dataself.atlassian.net/wiki/spaces/DS/pages/2046230557 for more instructions on how to use this page.
| QA Benchmark Reports | |
Tableau Report | Compare to Sage 100 Report | Sage 100 Report Setup |
AP Aging | Accounts Payable Aging Report |
|
| Accounts Receivable Aged Invoice Report Sage ERP > Modules > Accounts Receivable > Reports > Accounts Receivable Aged Invoice
| |
| Accounts Receivable Invoice Hist Report Sage ERP > Modules > Accounts Receivable > Reports > Accounts Receivable Invoice Hist Report | |
AR Aging | Accounts Receivable Aging Report |
|
IN On Hand Today | Inventory Valuation Report |
|
IN On Hand History | Inventory Valuation Report |
|
IN Transaction | Inventory Detail Transactions |
|
GL Transaction | General Ledger Detail Transactions |
|
Financials | General Ledger Financial ReportsGL |
|
Purchase Order | Open Purchase Orders |
|
| Sales order and Quote History Report Sage ERP > Modules > Sales Order > Reports > Sales order and Quote History Report | |
Sales Invoice | Accounts Receivable Invoice History Report |
|
Open Sales Order Report | Open Sales Order Report Modules > Sales Order > Reports > |
For more instructions see https://dataself.atlassian.net/wiki/spaces/DS/pages/2046230557
Older List
DataSelf Dataset | Comparison in Sage 100 |
---|---|
AP Aging | Accounts Payable Aging Report |
AR Aging | Accounts Receivable Aging Report |
IN On Hand Today | Inventory Valuation Report |
IN On Hand History | Inventory Valuation Report |
IN Transaction | Inventory Detail Transactions |
GL Transaction | General Ledger Detail Transactions |
GL Financials | General Ledger Financial Reports |
Purchase Order | Open Purchase Orders |
Sales Invoice | Accounts Receivable Invoice History Report |
Sales Order | Open Sales Orders |