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 : How to show Invoice line item rate percent instead of rateSearch Forum

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

 New Topic 
 
 Post Reply 
[1]  
 How to show Invoice line item rate percent instead of rate 
 Author   Message 
  Mari 
  
 Group: Members 
 Posts: 13 
 Joined: 2007-07-02 
 Profile
 Posted : 2008-11-21 07:29:13
I am trying to set invoice line qty as 1, invoice line amount as 500 and invoice line rate percent as 20, but when I look what happens after I import from Access to QB it automatically calculates the invoice line rate as 100 and shows that instead of 20%.  Which fields I should set to get invoice line rate empty and invoice line percent showing 20 %.

Thank you,

Mari 

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

Sorry, but the invoice line maths must add up. 20% of 500 is 100.

Try looking at: How do I apply PriceLevel Profile to Invoice Line Items? 

 

  Top 
  Mari 
  
 Group: Members 
 Posts: 13 
 Joined: 2007-07-02 
 Profile
 Posted : 2008-11-22 04:43:39
Thank you for the response.  The link didn't help me much.  The issue is I want to be able to see rate percentage instead of rate for certain items when the invoice is imported for example show 20% instead of real rate.

The client has some old invoices that show up like this and when I look the underlying fields I see that in invoicelineitem table it shows the invoicelineqty, invoicelineratepercenatage and invoicelineamount.  But when I try to import values into these fields it automatically puts invoiceqty, invoielineitemrate and invoicelineamount fileds.  So it doesn't import what I want to see in invoicelineratepercentage field.

Thank you,

Mari 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to