Idea for Comprehenisve Transaction File

[morris.stempParticipant]

I can’t locate a single table that has every transaction in the system along with all the related detail. Can you suggest the best way to get all details including account number and amount for every transaction?

Right now, I am linking the Transaction table with txnexpenselinedetail and bills, credit card charges and credit card debits and journal entry debits and journal entry credits. There has to be an easier way of getting all transactions in a single table.

Thanks for your help.

Morris Stemp
morris.stemp@slingshothealth.com

[morris.stempParticipant]

The Transaction table is a list of all transactions but it does not contain the key information for the transaction. For example, it has every BILL type transaction with the Accounts Payable side (credit side) of the entry. But if I want to see all the distributions of that bill (all the expenses/debits) related to that BILL, I need to join another table.

I am looking for a single table that has every entry. Does that exist?

[Author]

Posts