Unit of Measure |
Author |
Message |
Mike |
|
Group | : Members |
Posts | : 3 |
Joined | : 2006-08-29 |
|
Profile |
|
Posted : 2006-09-22 04:00:14 |
I am trying to return unit of measure information for an inventory item query but cannot find this field listed in any of the tables. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-22 08:37:23 |
My understanding is that the standard editions of QuickBooks cannot perform calculations or conversions based on units of measure, but you can add an extra column so you can enter units of measure on the estimate, sales order and invoice forms using one of the two "Other" columns using a name like "UOM" or "Units" for the new column.
In QODBC the Other columns are found in these tables:
EstimateLine CustomFieldEstimateLineOther1 CustomFieldEstimateLineOther2
SalesOrderLine CustomFieldSalesOrderLineOther1 CustomFieldSalesOrderLineOther2
InvoiceLine CustomFieldInvoiceLineOther1 CustomFieldInvoiceLineOther2 |
|
|
|
Mike |
|
Group | : Members |
Posts | : 3 |
Joined | : 2006-08-29 |
|
Profile |
|
Posted : 2006-09-23 01:39:28 |
I have units of measure already set up for all of my inventory items in Quickbooks. This is not entered in a custom field but is defined when I set up an item in Quickbboks. I am using the Premier-Manufacturing and wholesale addition. My problem is that I cannot locate where the unit of measure information is stored in the quickbooks database so that i can use this information in my custom application. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-25 00:06:37 |
Try running in VB Demo:
sp_columns ItemInventory
and see what other or custom fields you have. |
|
|
|
Mike |
|
Group | : Members |
Posts | : 3 |
Joined | : 2006-08-29 |
|
Profile |
|
Posted : 2006-09-26 06:55:45 |
I did not create any custom fields for unit of measure information in QB. There is an option in quickbooks to activate units of measure which I have done and I have entered unit of measure information for each of my inventory items.
I just need to know the table/field that the unit of measure is stored in the quickbooks database. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-26 09:23:00 |
The Unit of Measure is not yet supported by the Intuit qbXML SDK. If a QuickBooks file contains Unit of Measure information, a SDK query on transactions or items by QODBC might return unpredictable results. For example, if QuickBooks uses Inventory Units to calculate an inventory change, an SDK query by QODBC on that data could return confusing data, because the SDK cannot yet retrieve information about the units of inventory that QuickBooks is using. The same situation will occur if you try an inventory adjustment.
As of September 19, 2006, full support for Units of Measure is a high priority for the next QBSDK release by Intuit which by the sounds of things might be as far away as SDK v7 for QuickBooks 2008.
|
|
|
|