The open sales orders reports do not always show the correct details.

Legacy KB ID: 1153

Question

Why don't the reports on Open Sales Orders By Customer, and Open Sales Orders By Item, show the information that I expect to see?

Answer

If I have an item with a Quantity On Hand of 4 and enter an Invoice for a Quantity of 10 when I save the invoice it will ask to create a Sales Order.
When the Sales Order is created it has two columns on it ‘Ordered’ and ‘Invoiced’. In the ordered column it shows the total quantity i.e. 10 and in invoiced column the 4 that were on hand.


When I do a report on Open Sales Orders the amounts and quantities are all related to the total quantity of 10 when they should just be showing the 6 that were ordered.


To ensure that the Open Sales Orders report display only what has been ordered;
1) Enter the invoice for the 4 that were on hand.
2) Then manually create a Sales Order for the 6 that the customer is waiting for.
3) When you do a report on the Sales Order it will correctly show the 6 items that have been ordered.

How did we do?

Error - Unable to open email message store, when sending an email from Reckon Accounts

Bank Online report does not show edited employee bank online payments.

Related Articles

Reports Not Calculating The Correct Dates.
Purchases by Supplier Detail Report not able to show Purchase Order No.
The BAS report does not always include transactions on the 29th February.
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)