I use a webconnector plugin (MyWorks) to manage my inventory feed with a WooCommerce site. In addition to my direct to customer business, I also work B2B and book out future orders based on my on hand inventory. ex: I'll take an order, create a sales order for a ship date in 2 months. This order is based on inventory I have now and I need to secure this inventory for this customer to ship in 2 months. Since the order has not shipped and it has not been converted into an invoice, how can I have my inventory feed to my website reflect the Net available (On hand minus Sales order) so I do not sell something 2x?
Hi there, @fosterlohr.
Thank you for posting here in the Community. I'm here to share some details about how the inventory works in QuickBooks Desktop.
Currently, QuickBooks only affects an item stock and reducing the on-hand value when creating an invoice. For non-posting transactions like a sales order, the ability to minus the On hand amount is unavailable.
For now, there is no preference yet to allow hard allocation of stock. As a workaround, I recommend searching for an inventory management app you can use for QuickBooks.
Though we can't suggest which one to use, you can visit our Intuit Apps Center. You can check for third-party applications you can integrate with the program.
Please visit this link: https://desktop.apps.com/home.
For additional reference, I've attached a link you can use to learn more about QuickBooks handles inventory assets, average cost, and Cost of Goods Sold (COGS): Understand inventory assets and cost of goods sold tracking.
Drop me a comment below if you have any other questions regarding your inventory in QuickBooks. I'll be happy to help you some more.
Thanks for the quick reply. Your answer was what I was afraid to hear. These are some of the basics in quickbooks that really need to be addressed as businesses grow in different directions.
I second this! Having the same issue and QB's really needs to get this resolved. I don't want to have multiple apps installed for workarounds on something QB's should address. This is a common business practice and there needs to be a built in solution.