OpenSync

Home Forums OpenSync Idea for Comprehenisve Transaction File

Tagged: 

This topic contains 1 reply, has 1 voice, and was last updated by  morris.stemp 3 days, 20 hours ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #65313

    morris.stemp
    Participant

    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

    #65315

    morris.stemp
    Participant

    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?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.