Stock List

Why do the sales and transfers figures in the stock list not match the sales reports?

The sales figures in the stock list actually show the movement of the stock on hand, not the sales figures as shown on the sales reports. These two figures are not designed to match. The most common reasons for these differences are listed below. Usually, these differences are caused by two events happening over a the month boundary or a week boundary. However, there may be other functions (such as stock break) that cause the sales figures to change in the stock list but do not generate a sales invoice or stock transfer.

Generally the figures in the stock list are used for ordering purposes. In this case it is more useful to know the current stock on hand and sales figures, even though the invoice will not have been raised yet.

If you need accurate sales figures, you need to run the stock sales report.

When the checkout is used to reserve stock

  1. The customer's order is put in the checkout in one month (June).
  2. The customer's order is then invoiced some time in the following month (July).

The stock list will show the stock in the month it was placed in the checkout (June) and the sales reports will show the stock on the invoice date (July).

When the stock is booked out on a delivery note

  1. The customer's order takes a delivery note in one month (June).
  2. The invoice is raised in the following month (July).

The stock list will show the stock on the delivery note date (June) and the sales reports will show the stock on the invoice date (July).

When an order in the checkout is edited

  1. The customer's order is put in the checkout on the last day of the month (June).
  2. The order is edited, items are deleted or added in the following month (July).
  3. The invoice is then made (in July).

The stock list will show the stock on the delivery note date (June) and show the adjustments in the month following month (July). The sales reports will show all the stock on the invoice date (July).