fixed the issue. Will look into that further You need to join InventDim on InventDimId. In X++, properly formatted, it looks like:
while select WMSPickingLocation from inventItemLocation
join TableId from inventDim
join PhysicalInvent from inventSum
where inventSum.InventDimId == inventSum.InventDimId &&
inventSum.ItemId == inventItemLocation.ItemId
while select InventLocationId from inventDim
join sum(PhysicalInvent) from inventSum
where inventSum.InventDimId == inventSum.InventDimId
Inventory Management: On hand quantity (vb.net or C#)
hop of those help? The given sample VBA code should work very nearly the same in vb.net. You don’t have DAO, but in place I suggest using a datatable which is similar. So vb.net is VERY similar to that of VBA code, and I often cut + paste such code between the two environments.
How to update the items on hand quantity with QuickBooks Online Plus
Hope that helps The problem is with the "SyncToken". I believe when you try to update the new item, you should not increment the "SyncToken", you should keep it the same. QBO will update the "SyncToken" for you.