Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Table SchemaSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v9 Forum

 New Topic 
 
 Post Reply 
[1]  
 Table Schema 
 Author   Message 
  tmar 
  
 Group: Members 
 Posts: 1 
 Joined: 2008-11-22 
 Profile
 Posted : 2008-11-22 05:37:22

I've read through the table schema and can't seem to figure out how I can get the data that I'd need.

I want to write a commission report which would include the invoice line information but also the cost that was put on the quote and the cost of the line items that were on the PO for each line.

Can anyone help with the tables I'd need to link to get the invoice line data through the PO/Receipt cost on the line item.  Or, better yet is there a view or SP out there that has line cost/price information? 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-11-22 08:34:18

Sorry, but QuickBooks doesn't store the cost of each invoice line. QuickBooks doesn't track unit costs unless you create a new job for every purchase and invoice or you can use a custom field to link and track the purchase line (BillItemLine) with the invoice line (InvoiceLine) to do real costing!!!! 

The only other way to do it is to store the average cost of the item at the time of the invoice into a custom field when the invoice line is written (INSERTed). This would then allow you to extract the sales value and true cost for every invoiced item. Try also looking at:

Differentiate between a payment and a discount to pay commissions 
How can I see the cost of a stock item and compare it to what I invoiced it for? 

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to