Showing results for 
Search instead for 
Did you mean: 

Accountant tools: Troubleshoot stock


Note: The following information applies only to QuickBooks Accountant and QuickBooks Enterprise Solutions.

The Troubleshoot Stock tool contains several views of potential stock problems. By changing which items are shown and the stock criteria, you can see the items in the way that best suits the client's company. After the stock list is shown, you can Quick Zoom to an stock item and correct any errors. The status column between the End Qty and Neg Qty? column indicates any irregularities in the stock, such as negative quantities or items that are out of balance.

Symbol Description
The green circle indicates that there is no negative stock for this item.
The yellow warning triangle indicates that there is negative stock for this item.

Set the display dates

The default value for the To and From dates is the review period. You can change the dates as needed. After changing the To date, use the tab key or click anywhere else on the screen to refresh the display. These dates only apply to the beginning quantity, bought, sold, adjustment, ending quantity, and negative quantity columns.

Note: If the entered From date is later than the To date, CDR automatically makes the earlier date the From date and the later date the To date.

Change the displayed items

There are several views of stock available. After changing the view, select Refresh to display the stock list with the new criteria. The Type, Cost, Avg Cost, Sales Price, and % Markup columns have a different background colour for readability. The different background colour does not have a special meaning.

The Show Items dropdown box has three options. All displays all stock items, All Active displays only the active stock items, and Filtered By display stock items that meet the criteria below this box. If you choose All or All Active, all the criteria items are greyed out and are you cannot choose them. It does not matter if the greyed out items are selected or not. The default choice is Filtered By.

If the Show Items box is set to Filtered By, you can use any or all of the criteria to determine which stock items are displayed; the list is filtered by the selected items. The five criteria are as follows:

  • Qty Bought/Build=0 An item is displayed, if the quantity bought or built is zero.
  • Qty Sold/Used=0 An item is displayed, if the quantity sold or used is zero.
  • Negative Quantity An item is displayed, if the quantity is negative. There are two radio buttons under the table that specify how to handle displaying negative stock. If you select the first button labelled as of "to" date and select the Negative Quantity box, an item is displayed if it has a negative quantity at the end of the review period. If you select the second button labelled any time in date range and select the Negative Quantity box, an item is displayed if it had a negative quantity any time during the review period, even if it has a positive quantity on the last day in the period.
  • Inactive with Qty on Hand An item is displayed, if it is inactive and shows a quantity on hand.
  • % markup less than ...% An item is displayed, if the markup is less than the amount entered. The default amount is 10%. If you clear the % Markup box or change the Show Items option to All or All Active, the percentage is still visible, but it is greyed out. It is not used when it is greyed out, but it is retained, so you will not have to enter it again, if you select the % Markup box or change the Show Items option.

If the list is too large to work on, add or change the criteria to limit it.

How to fix stock

There are four ways to diagnose and fix stock problems, as follows:

  • The cursor changes to a Quick Zoom cursor when the cursor is over the Name. You can double click a Quick Zoom cursor to open the Edit Item screen for this item and make adjustments. The list will refresh after editing an item.
  • You can double click the End Qty or Neg Qty? column to see the Stock Valuation Detail Report for that item for the period.
  • You can select any number of stock items by clicking the checkbox in the first column for each stock item. To make the selected items inactive, select Make Selected Items Inactive. The list will refresh automatically after making items inactive. To activate an inactive item, double click it to open the Edit Item window and clear the Item is Inactive box.
  • You can adjust the quantities for all displayed stock items by clicking Adjust Stock Quantity/Value on Hand at the bottom of window. In the new window, enter a new quantity or the quantity difference for any of the items. If you enter one of these items, the other is calculated automatically. You must select the Adjustment Account and you can add a reference number, job, and class information at the top of the list.When done, select Save & Close to process your changes, or Save & New to process your changes and keep the window open. Select Cancel to close the window without making any changes.After saving, you may receive warnings about the age of transactions. If you did not enter a required Adjustment Account, you will receive a warning message and the changes are not processed.

Was this helpful?

You must sign in to vote, reply, or post