I have a program that can adjust quickbooks item/product on hand quantity through making an inventoryAdjustment. Currently i can only adjust the inventory by matching the item name. is there any other attribute i can use (item serial#, item id) to query and update the item on hand quantity?
Refer to the QuickBooks OSR for reference on what fields can be queried:
You can query items by:
And when referring to items during an Inventory Adjustment, you can refer to them by either:
If you want to query by anything else, you need to query the entire item list and filter it down on your end with your own code.