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
|
|
Unit of Measure Enterprise-Manufacturing, what table is field in |
Author |
Message |
|
Posted : 2007-10-18 01:21:26 |
I saw a previous post with no resolution so I am posting again. I am on QB Enterprise - Manufacturing. Unit of measure is included, turned on and in use. I cannot find it in any of the tables. Where is it stored? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-18 07:56:39 |
QODBC Release 8.0 now supports QuickBooks 2008 (USA Edition), and the QuickBooks SDK version 7.0 and includes the following new features and fixes:
- New table AccountTaxLineInfo
- PaymentMethodType added to PaymentMethod table.
- New tables UnitOfMeasureSet, UnitOfMeasureSetRelatedUnit and UnitOfMeasureSetDefaultUnit.
- UnitOfMeasure in Invoice, and Item tables.
- ManufacturerPartNumber in item tables
But you must be using QuickBooks 2008 to use these features. |
|
|
|
Al |
|
Group | : Members |
Posts | : 4 |
Joined | : 2007-02-17 |
|
Profile |
|
Posted : 2008-08-01 00:43:33 |
Tom
Since invoice line contains unitofmeasure, should we be able to retrieve unitofmeasure from salesline? I'm not seeing it as an option?
Using QB Enterprise 2008... and qodbc v8 |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-01 08:04:31 |
Yes, Unit of Measure was added to Estimate, SalesOrder, CreditMemo, ReceivePayment, PurchaseOrder, Bill, ItemReceipt, VendorCredit, Check, CreditCardCharge, and CreditCardCredit, but you need to be using the latest version of QODBC, see: How can I get the latest version of QODBC? |
|
|
|
Al |
|
Group | : Members |
Posts | : 4 |
Joined | : 2007-02-17 |
|
Profile |
|
Posted : 2008-08-01 08:33:27 |
Tom
I have QODBC 8.00.00.242 and still don't see unit of measure in salesline. I do see unit of measure in invoiceline. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-01 09:56:46 |
Use the SalesOrderLine, InvoiceLine or CreditMemoLine tables, not the SalesLine table which is Custom QODBC table read-only view that includes invoice lines, credit memo lines and sales receipt line information. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-04 12:20:09 |
Unit of Measure has been added to the Sales and SalesLine views and set to work with all versions of QuickBooks from QODBC v9.00.00.249 onwards.
See: Release 9.0.0.249 Fixes |
|
|
|
|