cancel
Showing results for 
Search instead for 
Did you mean: 
fosterlohr
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?

 

 

7 Comments 7
AlcaeusF
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.

fosterlohr
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.

Fiat Lux - ASIA
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.

DandB7
Level 3

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

I'm having the exact same issue!  QuickBooks really needs to find a solution for this.  I don't want to have multiple apps to do workarounds for a common business practice.  

DandB7
Level 3

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

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.

DandB7
Level 3

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

QuickBooks needs to resolve this and find a built in solution.  This is a common business practice and I'm having the same issue.

Robyn32541
Level 1

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

I created a seperate inventory site and labeled it "pre-orders" to book these type of sales in.

It's not ideal but it works

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us