Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

How to reserve inventory for future sales orders and have the onhand file account for the future inventory

Hello,

 

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?

 

 

3 Comments
Moderator

How to reserve inventory for future sales orders and have the onhand file account for the future inventory

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.

Level 1

How to reserve inventory for future sales orders and have the onhand file account for the future inventory

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.

Level 15

How to reserve inventory for future sales orders and have the onhand file account for the future inventory

@fosterlohr 

You may need a 3rd party inventory management app to integrate with your QB Desktop.

Need to get in touch?

Contact us