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 : Invoice Line Item RatePercent ColumnSearch Forum

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

 New Topic 
 
 Post Reply 
[1]  
 Invoice Line Item RatePercent Column 
 Author   Message 
  Keith 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-04-05 
 Profile
 Posted : 2007-11-10 04:46:05

I am successfully generating all different size invoices from ASP.NET. The issue I am experiencing is that the price level discount for a specified customer is not being applied to invoices generated from code. I have tried grabbing the percentage (lookup the client price level and pull the percent from the Pricelevel table) and inserting the adjusted InvoiceLineRate to the InvoiceLine table but it just takes the default rate for that item code.

This is the sql:

InvoiceLineSalesTaxCodeRefListID, FQSaveToCache) VALUES ('8F0000-979074821', ' - Network Service Hour(s)', 'October 2007', 0.5, 147.89775, 89.635, 82.5, '10000-1012335098', 1)

It produces the following line item:

Item Code            Description                                Quantity      Price Per       Amount      Tax

NET                        - Network Service Hour(s)             .25           165              41.25         Tax

Is there any way to send an adjusted rate to Quickbooks?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-11-10 11:48:17
The InvoiceLineRate in the insert will only be used. You need to look up the pricing discount for the customer and apply it to the InvoiceLineRate amount you use first. In How do I create Invoices? I use a different rate for the same item for each line. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to