Knowledgebase
[QODBC-Desktop] How to Create an Item Inventory Assembly using QODBC
Posted by brad waddell on 12 March 2009 05:21 PM

How to Create an Item Inventory Assembly using QODBC

An Example of Creating One ItemInventoryAssembly with Two Lines

Note the FQSaveToCache field, set to True except on the last one.

First Line

INSERT INTO "ItemInventoryAssemblyLine" ("Name", "IsActive", "SalesDesc", "IncomeAccountRefListID",
"COGSAccountRefListID", "AssetAccountRefListID",
"ItemInventoryAssemblyLnItemInventoryRefListID", "ItemInventoryAssemblyLnQuantity",
"FQSaveToCache")
VALUES ('NewAssembly1', 1, 'QODBC New Assembly1', '1B0000-933270542', '1E0000-933270542',
'60000-933270541', '5A0000-1197758364', 2.0, 1)

Second Line

INSERT INTO "ItemInventoryAssemblyLine" ("Name", "IsActive", "SalesDesc", "IncomeAccountRefListID",
"COGSAccountRefListID", "AssetAccountRefListID",
"ItemInventoryAssemblyLnItemInventoryRefListID", "ItemInventoryAssemblyLnQuantity",
"FQSaveToCache")
VALUES ('NewAssembly1', 1, 'QODBC New Assembly1', '1B0000-933270542', '1E0000-933270542',
'60000-933270541', '5B0000-1197761433', 1.0, 0)

Result in QuickBooks 2006

See also: Trying to update ItemInventoryAssemblyLine table

 

Questions and Answers

Question

     This seems to work for adding multiple items (ItemInventoryAssemblyLine records) to an assembly when the assembly is first created.

     However, I am having trouble adding new ItemInventoryAssemblyLine records to an existing assembly. When I try to repeat an INSERT with FQSaveToCache set to 0, then I get an error

QODBC Error 3100 - The name "NewAssembly1" of the list element is already in use (#10053)

Answer

   I don't think we can add items to an existing assembly. The workaround would be to create a new assembly with the additional items

(116 vote(s))
Helpful
Not helpful

Comments (1)
Monika
20 September 2012 03:16 PM
Note that the cost field of an assembly (not the avregae cost) is NOT updated when you build the assembly. So if you have an assembly as a component of another, then the listed total bill of materials cost value you see for the higher level assembly is probably not up to date. purchasing can update a cost field, but building does not, and so (if you have multiple level BOM's) that cost info gets more and more out of date as time goes on, unless you manuall update it or use a third party tool to update it.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).