I am trying to build a query. I would like to get from an A/P check back to a matter billing record. Can anyone recite the tables in the chain and the fields that match between these tables?
Something like TableTXHDR.sysid to ownerid in TableTXGL etc.
I need the path to get to the unique record in the Billing Table.
Any help would be appreciated.
TM7e Billing Matters Plus
Jeff WyattAbilene TX
Jeff,
I'm not sure you can do what you're trying to do. Yes, invoices (txhdr) have details (txdtl), with some details linked back to billing items (billing). Payments are applied to invoice balances as opposed to specific invoice details.
Are you trying to calculate partial payments for tax accounting?
Steve StockstillData Equity LLC www.DataEquity.com, www.PracticeBetter.comThe Time Matters add-on developers...MobileTM, SharpShooter, GuestOffice, GoogleConnect 4TM and OfficeManager 4TM
Thanks for replying. No I am not interested in the link to client payments (which is a step farther down the path). I only want the link from the payment to the vendor (A/P) to the creation of the corresponding billing item for a matter. My goal is to have a query that can show payments we made on behalf of clients to file suits with the District Court and the corresponding billing items where those "advances" have been billed to the clients.
I had been convinced that we had a bullet proof recovery system for payments on behalf of clients but one came to light that did not make it to a billing item. If it happened once, I want to be sure it hasn't happened more often nor happens again.
Each Billing Item has a couple of fields that are "ID's". Surely, I can connect the proper ID to an interim table or two and work my way back to the A/P source that created that billing item. That is the goal at least.
Jeff