cancel
Showing results for 
Search instead for 
Did you mean: 
kate111
Level 3

Quickbooks Desktop Serial number issue

We are using QuickBooks Enterprise Solutions:  Manufacturing and Wholesale 23.0.  We have serial numbers turned on and sometimes they work correctly.  Other times, I end up with both positive and a negative quantity on hand for each serial number I use.  None of this relates to the quantity of the item on hand, and happens when both a negative and positive number are in the same inventory location.  I don't even undersand how that's possible.  And I can't figure out why this is happening, or how to fix it.  (I've tried adjusting the work orders, adjusting inventory, adjusting inventory - but only the serial number.)  Nothing seems to work, other than removing the serial numbers from both the creation work order, as well as the consuming work order.  This is not what we're after. 

 

Anyone have any experience with this, or understand why it's happening?  It's been going on for years, since serial number capability came along.  

I've included a screenshot showing what it looks like when the serial number issuing doesn't work correctly.QB SN issue 2024-06-27_14-50-39.jpg

11 Comments 11
SirielJeaB
QuickBooks Team

Quickbooks Desktop Serial number issue

Hello there, kate111. Let's perform some troubleshooting steps to resolve the serial number issue.

 

The second payment receipt copy only shows the subtotal amount, as it doesn't incorporate any extra charges for transfers, fees, or taxes based on your screenshot.

 

Since you've verified that your customer also paid the total amount included with the sales tax,

 

Let's resolve your concern by verifying and rebuilding your data in QuickBooks Desktop (QBDT). The verify tool identifies the most common problems in a company file, and the rebuild tool fixes them.

 

Here's how to verify your company data:

 

  1. Go to Window, then click Close All.
  2. Navigate to File, then Utilities.
  3. Choose Verify Data.

 

Please follow the steps below to rebuild your company file data:

 

  1. Go to File, Utilities, then click Rebuild Data.
  2. Follow the on-screen instructions, then select OK.
  3. Choose a location for your backup, then click OK.
  4. Type in a new name in the File name. Click Save.

 

For further detailed steps, see this article: Verify and Rebuild Data in QuickBooks Desktop.

 

If the issue persists, I suggest contacting our Live Support Team. They have the tools to help you navigate your QBDT program by initiating a screen-sharing session and determining the underlying cause of your concern.

 

In addition, check out the following articles on managing reports within the program to track the financial status of your business:

 

 

Should you require further assistance managing sales receipts or other QuickBooks-related concerns, drop by again so we can get back to you promptly. Have a good one.

4Gal
Level 11

Quickbooks Desktop Serial number issue

@kate111 

Run the Verify/Rebuild Data utility. Did you encounter any error message?

kate111
Level 3

Quickbooks Desktop Serial number issue

I don’t know what question you think you are answering! The screen shot is quantity on hand by serial number. Please read my expressed concern thoroughly and advise.

4Gal
Level 11

Quickbooks Desktop Serial number issue

It's possible that your company file is damaged. That's why you should run the Verify/Rebuild Data utility to be sure.

kate111
Level 3

Quickbooks Desktop Serial number issue

No, our company file isn't damaged, this is not the answer.  Any other suggestions? 

 

Anyone out there with real helpful suggestions?

 

SIAB
Level 4

Quickbooks Desktop Serial number issue

@kate111 

If you did not encounter any error messages after running the Verify/Rebuild Data utility, you should run the Condense Data utility under any scenario as subsequent troubleshooting. If the tool fails to complete, there is negative inventory that must be corrected in your company file.

kate111
Level 3

Quickbooks Desktop Serial number issue

The number of serial numbers on hand does not have anything to do with the quantity of the material on hand.  For example, in the screen shot I shared, I have 1 piece on hand (and this is correct.)  Yet I have what I showed for quantity on hand by serial number.

 

Again, nothing is wrong with the quantity of material on hand.  The serial numbers are the only part that is incorrect.

SIAB
Level 4

Quickbooks Desktop Serial number issue

If you are sure your company file is fine, consider installing QB Desktop 2024 to isolate the problem.

kate111
Level 3

Quickbooks Desktop Serial number issue

I have considered updating, but this will not fix the issue.  It's been going on since serial number capability was added to QuickBooks.

 

Does anyone have any real advice for solutions?

VoltF
QuickBooks Team

Quickbooks Desktop Serial number issue

I recognize the importance of resolving this matter, Kate111. Let me share a summary of setting up the serial number tracking in QuickBooks Enterprise.

 

QuickBooks Desktop Enterprise comes with a built-in serial number tracking feature, which requires enabling Advanced Inventory to ensure system synchronization.

 

To Turn on Advanced Inventory, please follow the instructions below:

 

  1. Go to the Edit menu and select Preferences.
  2. On the left pane, choose Items & Inventory, then go to the Company Preferences tab.
  3. Check the Inventory and Purchase Orders are Active box.
  4. Click the Advanced Inventory Settings button, then select the Serial/Lot Numbers tab.
  5. Check the Activate serial or lot numbers box, then tick the Serial Numbers radio button.

 

If the Advanced Inventory Settings button appears grayed out, we can synchronize license data online to ensure QuickBooks recognizes it. Follow these steps to take care of this seamlessly. Here's how:

 

  1. In QuickBooks, go to the Help tab.
  2. Click Manage my License.
  3. Select Sync License Data Online.
  4. Check if the Advanced Inventory Settings button is no longer in a grayed-out state.
  5. Close and re-open the QuickBooks program.

 

Once done, you can now assign a serial number to your inventory. For a comprehensive understanding of the process, I recommend referring to this article: Use Serial or Lot Numbers and Expiration Date.

 

Furthermore, you may refer to this article for additional details on how to track inventory stored at different sites or locations: Set up Advanced Inventory.

 

If you have further questions regarding other advance inventory-related concerns in QuickBooks Enterprise, please feel free to reach out. I'm here to help. Have a productive day!

kate111
Level 3

Quickbooks Desktop Serial number issue

I appreciate your engagement, but you aren't sending me anything new.  I've been using serial numbers in QB for years, and have turned them on as advised in the lovely article links provided.  Sometimes they go in and out of inventory correctly, many times the do not.  It seems like there is a serious software bug here, but I can't yet identify when/why the serial numbers aren't working correctly.  Seems random to me.  I also can't seem to get any serious help with this. 

 

I have a paid annual subscription, is there any way for me to get some dedicated assistance?

Need to get in touch?

Contact us