cancel
Showing results for 
Search instead for 
Did you mean: 
williambbrown
Level 1

QB:POS Suggested Purchase Order gives bad suggestions. Any idea how to fix?

The Basics: We are running QB:POS 18 Multistore Level.

We have two stores. Store 1 (HQ) and Store 2.

 

Store 1 has no actual inventory or sales; it is only for running the financial side of things.

 

Store 2 has the inventory and is where the sales happen.

 

The issue: When I have Point of Sale create a suggested PO, it comes back with order suggestions on some items that make no sense.

 

So here is the process: We have reorder points set for Store 2 (no reorder points for Store 1 or for the Company). I go into the suggest PO and A) set "Reorder point for which location?" to Store 2 and B) select the single vendor to reorder items from, and C) select "Bring item quantities back up to their reorder points plus 0.

 

Then the system suggests the PO. For most items the ordering is fine, but it will generate several order that make no sense:

 

Item A: Store 2 on hand QTY = 0; Store 2 reorder point = 2, POS orders 14

Item B: S2 O/H QTY = 0; S2 r/o point = 4, POS orders 7

Item C: S2 O/H QTY = 0; S2 r/o point = 1, POS orders 5

Item D: S2 O/H QTY = 1; S2 r/o point = 2, POS orders 4

Item E: S2 O/H QTY = 0; S2 r/o point = 2, POS orders 12

 

I first figured that Store 2 must have an open sales order or work order that was affecting the inventory. However, I've had the business partner check and double check that the Store 2 POS shows no open Work Orders or Sales orders.

 

When I look at the details for the individual items, they show nothing indicating any negative availability.

 

Although I don't know for sure, this seems to have started after we updated to 18 (and also updated our Quickbooks to Desktop Pro 2020). While we were in extremely slow mode during Covid shut down, the number of problematic suggestions was simple enough to catch. However, as things are starting to pick up, the problematic suggestions could cause some issues if they were to slip through to our vendor.

 

Any ideas on how to solve this issue?

Thanks.

 

Solved
Best answer March 15, 2021

Best Answers
AileneA
QuickBooks Team

QB:POS Suggested Purchase Order gives bad suggestions. Any idea how to fix?

Hello, williambbrown. 

 

Thank you for the detailed information. There are some reasons why this occurs, which may cause damage to data, lists, or SQL table structure in your company file and we can fix this by performing the Verify data and Rebuild utility tools in QuickBooks. 

 

  1. Make the Debug mode accessible.
    1. From the Point of Sale Help menu, select About QuickBooks Point of Sale.
    2. With the Point of Sale information window open, simultaneously press Ctrl+Alt+D+B on your keyboard.
    3. Select OK to close the information window.
  2. Run the Verify utility.
    1. From the Help menu, select Debug, then Verify Data.
    2. After it completes, check the validation window to verify any issues.

You can also contact our Support Team, they can pull up your account securely and further investigate this. For the support's contact information, you can check it here: QuickBooks Desktop Point of Sale

 

I've also added this article for more troubleshooting steps: Error: POS got stuck when using QuickBooks Point of Sale

 

Let me know if you've got the chance to try these steps above. I'm always here if you need more help. Stay safe!

View solution in original post

2 Comments 2
AileneA
QuickBooks Team

QB:POS Suggested Purchase Order gives bad suggestions. Any idea how to fix?

Hello, williambbrown. 

 

Thank you for the detailed information. There are some reasons why this occurs, which may cause damage to data, lists, or SQL table structure in your company file and we can fix this by performing the Verify data and Rebuild utility tools in QuickBooks. 

 

  1. Make the Debug mode accessible.
    1. From the Point of Sale Help menu, select About QuickBooks Point of Sale.
    2. With the Point of Sale information window open, simultaneously press Ctrl+Alt+D+B on your keyboard.
    3. Select OK to close the information window.
  2. Run the Verify utility.
    1. From the Help menu, select Debug, then Verify Data.
    2. After it completes, check the validation window to verify any issues.

You can also contact our Support Team, they can pull up your account securely and further investigate this. For the support's contact information, you can check it here: QuickBooks Desktop Point of Sale

 

I've also added this article for more troubleshooting steps: Error: POS got stuck when using QuickBooks Point of Sale

 

Let me know if you've got the chance to try these steps above. I'm always here if you need more help. Stay safe!

williambbrown
Level 1

QB:POS Suggested Purchase Order gives bad suggestions. Any idea how to fix?

The debug seems to have solved the issue. I will keep my fingers crossed that the purchase orders continue to give logical numbers.

 

Thanks!!

Need to get in touch?

Contact us