[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 QODBCAn Example of Creating One ItemInventoryAssembly with Two LinesNote the FQSaveToCache field, set to True except on the last one. First Line INSERT INTO "ItemInventoryAssemblyLine" ("Name", "IsActive", "SalesDesc", "IncomeAccountRefListID", Second Line INSERT INTO "ItemInventoryAssemblyLine" ("Name", "IsActive", "SalesDesc", "IncomeAccountRefListID", Result in QuickBooks 2006 See also: Trying to update the ItemInventoryAssemblyLine table
Questions and AnswersQuestionThis 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) AnswerI don't think we can add items to an existing assembly. The workaround would be to create a new assembly with the additional items | |
|