I'm looking to pull a report of Customer Receipts in the current period using an ODBC connection to Power Bi.
Could anyone advise of the data table required to pull this transaction data please?
Which Data Table Holds Customer Receipt Transactions
- brucedenney
- Site Admin
- Posts: 4632
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Which Data Table Holds Customer Receipt Transactions
it is the AUDIT_HEADER table, look for transactions of Type SA or SR
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 1 guest