cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Debbie Polden
Level 1

Stock

Hello,

I have had a situation occur that I wonder if it can be resolved and why this happens in the first place.

We sell skincare products and have 2 employees that can process orders on 2 computers.

Yesterday they were both creating new invoices for 2 different customers at the same time.

On both invoices the customers ordered 2 x Redcurrant Moisturisers, both inventory counts on the invoices showed there were 2 in stock, so both invoices were saved and then when we went to pick the orders we realised we were over sold by 2 as we only had 2 in stock not 4!!! 

My question is -

Is this preventable and also why is this a situation that can occur in the first place?

1 REPLY 1
BettyJaneB
QuickBooks Team

Stock

Hello there, @Debbie Polden.

 

You've got me here to share some insights about managing inventories in QuickBooks Online.

 

QuickBooks allows you to set low products alert to identify if you have low stock or out-of-stock items. This is a good way to prevent items from being oversold.

 

You can check that out by following this steps:

  1. Go to Sales.
  2. Refer to the Products and Services.
  3. At the top, you’ll quickly see if you have low stock or out of stock items. Select Low stock or Out of stock to see those products.
  4. If you have low stock or out of stock alerts, here's how to reorder stock with QuickBooks.

On the other hand, a situation like this can happen if the invoices are created at the same time. It's possible that the system wasn't able to recognise the inventory changes yet, while the other invoice has been generated.

 

To verify this matter, you can check the Audit Log section of your account. This way, you'll be able to see which transaction causes the item to be oversold.

 

Here's how:

  1. Go to Gear icon.
  2. Select Audit Log.
  3. Click on Filter.
  4. Use the fields on the Filter panel to choose the appropriate UserDate, or Events filter to narrow the results.
  5. Select Apply.

For more details about utilizing the audit log, please see this link: Learn what the audit log can do and how to use it to keep an audit trail.

 

Moreover, you can delete one of the invoices made to cope with the items that you had in stock. If you want to let the transaction as it is, then you can adjust the inventory or edit the item on the invoice.

 

I'm also adding these resources below that can help you monitor your inventory status in QBO:

I'm always ready to help if you need more assistance with inventory or with QuickBooks, Debbie. Have a nice day!

Need to get in touch?

Contact us