|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
|
| InvoiceLine Rates and Amounts using QuickBooks QBi 2009/10 |
| Author |
Message |
|
|
| Posted : 2009-06-25 09:17:05 |
I am inserting invoices into QBi 09/10 and the invoice line amounts come out as zero.
Here is my query.
INSERT INTO InvoiceLine (InvoiceLineItemRefListID,InvoiceLineDesc,InvoiceLineQuantity,InvoiceLineRate,InvoiceLineClassRefListID,InvLnSalesTaxCodeRefListID,
InvoiceLineTaxCodeRefListID,FQSaveToCache)
Values ('340000-1187761913','Sales summary from ClickPOS',1,2,'10000-1184303593','80000008-1243996041','80000008-1243996041',True)
INSERT INTO Invoice
(CustomerRefListID,TxnDate,RefNumber,IsPending,PONumber,DueDate,SalesRepRefListID,ShipDate,IsToBePrinted,ClassRefListID)
Values ('2420000-1190793490',{d'2009-06-23'},'55033752',False,'',{d'2009-06-23'},'1D0000-1228693548',{d'2009-06-23'},False,'10000-1184303593')
The same query was working perfectly before, and is now broken.
Thanks in advance. |
|
|
|
|
|
| Posted : 2009-06-25 13:06:42 |
Try adding a InvoiceLineAmount with a value of 2 in the statement like this:
INSERT INTO "InvoiceLine" ("CustomerRefListID", "TemplateRefListID","RefNumber",
"InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineAmount",
"InvoiceLineTaxCodeRefListID","FQSaveToCache")
VALUES ('300000-1081400329','A0000-1045701421','56',
'90000-1045537150', '4m Steel Ladder', 1.00000, 150.00, '90000-1045536338', 1) |
|
|
|
|
|
| Posted : 2009-06-25 13:47:53 |
No Luck. I've been playing around with different combinations of the Quantity, Rate and Amount, but the lines still come out with zero amounts and are therefore mark as paid.
Here's my amended query:
INSERT INTO InvoiceLine (InvoiceLineItemRefListID,InvoiceLineDesc,InvoiceLineQuantity,InvoiceLineRate,InvoiceLineAmount,InvoiceLineTaxCodeRefListID,FQSaveToCache) Values ('340000-1187761913','Sales summary from ClickPOS',1,2,2,'80000008-1243996041',True)
And it shows in QB as per below:
.bmp) |
|
|
|
|
|
| Posted : 2009-06-25 14:00:16 |
Are you using QODBC v9.0.0.259 (check the About tab of the QODBC Setup Screen)?
Also, are you using QuickBooks QBi 2009/10 multi-currency? |
|
|
|
|
|
| Posted : 2009-06-25 14:17:56 |
Yes I am using the latest version of QODBC:
QODBC Desktop Read Write 2009 OEM Version 9.00.00.259
I am unsure wether the version of QB has multi-currency support or not, is there a quick way of telling? |
|
|
|
|
|
| Posted : 2009-06-25 14:44:02 |
I've just confirmed that it the version of quickbooks has multi-currency support.
Which driver works with QBi 2009/10 with multi-currency support?
|
|
|
|
|
|
| Posted : 2009-06-25 17:34:55 |
When Quicken New Zealand originally released QuickBooks QBi 2008/09 it didn't support multi-currency. Multi-currency was installed as part of a service pack later on in New Zealand, but that service pack didn't make it to Australia before the Australian release of QuickBooks QBi 2009/10.
QODBC still works with QuickBooks QBi 2008/09 and QuickBooks QBi 2009/10, but without multi-currency support, meaning it can't read any of the multi-currency numbers or work with exchange rates, the rest of the information is fine.
It's the SDK installed and supplied by QuickBooks that's the problem here, not QODBC. I suspect the invoice lines are coming up here as zero because QuickBooks is using a Exchange Rate of 0 (zero) internally.
It's also worth using the TxnID and TxnLineID of the invoice line and trying to force the amount values after the insert like this:-
Update InvoiceLine set InvoiceLineQuantity= 1,InvoiceLineRate=2,InvoiceLineAmount=2
where TxnID = 'xxxxxx-xxxxxxxxxx' and TxnLineID= 'xxxxxx-xxxxxxxxxx' |
|
|
|
|
|
| Posted : 2009-06-26 08:24:53 |
The same result with the update. The amounts as zero. 
Please, let me know if there's a way to work around it.
Thanks for the help. |
|
|
|
|
|
| Posted : 2009-07-07 10:40:08 |
Can I request a notification or a reply to this post, when a fix or a resolution has been found for this issue?
I understand that it's not an issue with QODBC itself, but rather a problem with QuickBooks but can you let me know if any progress is made on this?
Thanks a lot. |
|
|
|
|
|
| Posted : 2009-07-07 12:06:30 |
| I haven't fogotten this issue, so far no Australian users have reported this problem. At this stage this might be limited to the New Zealand version of QuickBooks? |
|
|
|
|
|
| Posted : 2009-07-07 12:09:28 |
| The Problem occured on a client running the Australian Version of QuickBooks. Thanks |
|
|
|
|
|
| Posted : 2010-03-25 16:37:10 |
|
|
|
|
Copyright (c) 2006-2009
Data Access Worldwide,
Australia. This FREE self help forum website
was copied by FLEXquarters.com Limited, Hong Kong to: http://archive.qodbc.com
/forum50f5.html
without our
permission. |
The QDeveloper Forum is
dedicated to the FREE professional exchange of
information. QODBC and FlexODBC users can post support
queries, report product bugs, or simply search topics
for help. Data Access Worldwide - Asia Pacific normal office
business hours are 9am to 5pm
week
days
Australian EST with the exception of Public Holidays.
ABN: 86 544 223 459
PO Box 873,
Boronia VIC 3155 Australia
Tel: 03 9761 3644 Intl: +613 9761 3644 |
