Sage 50 Accounts OData feed for Power BI
This article describes the BITransSplits table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI. The table is a flattened combnation of the Sage 50 Accounts ODBC tables AUDIT_HEADER and TRANS_SPLITS.
This table provides all of the transaction splits of of all of your posted Sage 50 Accounts transactions going back over the last c. 800 days. Excluded are any deleted transactions.
This table is essential if you want to analyse any of the following Sage 50 Accounts data:
- Accounts payable
- Accounts receivable
- Nominal transactions
- Purchase Invoices
- Departmental Profit & Loss
- Imported Sales transactions (via CSV)*
- Sales transactions created via the Batch Input screens in Sage 50 Accounts*
*Sales transactions that are imported into Sage 50 Accounts via CSV file, or created through the Batch Invoices screen go straight to the Transactions audit log and do not appear in the Sage 50 Accounts Invoices list.