Can someone explain to me what goes on in the background when you generate an invoice in basic billing? Is there a flag set in the billing table? If so what field. Are other tables updated and with what data? How does TM know which bills are on which invoice?
I am trying to setup a report in Access that pulls data from TM to meet a particular clients billing requirements and am just trying to figure out what is already in TM and what Access will have to generate.
Edward S. McGlone | Edward McGlone Law Offices | 503-486-7048 | emcglonelaw.com | Governmentlitigaionblog.com
The invoice information (mostly) is located in txnhdr table and linked to the billing items by a transaction id. However, without knowing more about your requirment it is hard to know if you need to extract information from other tables within Billing Matters. Hope this helps.
Ardavan GurgPars Consulting Incorporated503.firstname.lastname@example.org
Ardavan GurgPars Consulting Incorporated206.email@example.com
Basically I'm trying to figure out how Time Matters knows what item in the billing table goes with what invoice so when I generate the report in Access I can limit the billing information to a specific invoice.
txn_id in the Billing table tells time matters which invoice the billing item belongs to.
Create a query using these TM tables - billing, billstg and txhdr. The billstg table is the linking table. Link billing.sysid<->billstg.memo and billstg.sysid<->txhrd.sysid. This will let see the billing items that appeared on the bill. Good Luck