SageForum for UK versions of Sage 50- Help and support.

Help and support for Sage50 users, covering all subjects including report writing, installation problems, accounting issues, data errors, integrating with other desktop systems and web services..
https://forum.makingithappen.co.uk/

Which Data Table Holds Customer Receipt Transactions

https://forum.makingithappen.co.uk/viewtopic.php?t=4397

Page 1 of 1

Which Data Table Holds Customer Receipt Transactions

Posted: 13 Feb 2024, 15:38
by AshleyR
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?

Re: Which Data Table Holds Customer Receipt Transactions

Posted: 13 Mar 2024, 11:09
by brucedenney
it is the AUDIT_HEADER table, look for transactions of Type SA or SR
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited