Hello there - Can you provide more details as to which sales numbers you are comparing and in which module or reports these numbers are coming from? The common question we receive regarding sales total not matching is when a user compares Sales Analysis reports to the sales amount located under the Sales Information tab for a customer within Customer Details. Please let me know if this is where you are seeing the dependencies if not please provide more details for your specific scenario.  

Regards,

Don

All "tabs" referred to here are within the Customer module. The total in the Sales Information tab (ie: May - this is the tab where you can see a graph and total dollar sales by month) does not match the total we manually get when we add up the invoices listed in the Sales Order History tab. However, funny enough, the Sales Analysis report DOES match what we get when we manually add up the invoices. (thanks for your very quick reply, by the way)

Thank-you for the clarification, the sales totals within the Sales Information tab are made up of invoices you enter through the Order Entry module, Point of Sales module (these invoices makes up the items under the Sales Order History tab and any reports you run for Sales Analysis) as well as any invoices, debit memos or credit memos you enter in Account Receivable. For example, if you enter an order for $100 in Order Entry, then post an invoice for the customer in AR for $50 and finally a credit memo for the same customer for $10. The sales total within the Sales Information tab will be $140. Now if you compare this to your Sales Analysis report or the your manual invoices, you would be off by $40 because only sales entered in Order Entry or Point of Sales will be part of Sales Analysis. For the particular customer that is out, check to determine if any invoices, debit or credit memos were posted to the account directly from Account Receivable. To avoid the discrepancies,  invoices and credits should always be entered in Order Entry or Point of Sales.

We never issue any manual invoices through the through A/R.  We do everything only through sales order.  I also double checked all the invoices issued in March and compared the Accounts receivable to the sales order history and they match exactly.  Confirms no manual invoices entered through Accounts Receivable.  All invoices were only issued from order entry. For the month of May, the difference in totals is $15,000 (total sales in Sales Information is $15,000 higher than Invoiced sales). That's quite a difference in one month when we base a lot of our decisions based on customer sales.

Let reorganize your customer file but before doing so make sure you have a good backup of your data and that everyone is out of the system. To reorganize, click File > Reorganize Files, select the Customer file and then in the right part of the window select to recalculate Sales Statistics and also to  recalculate Present Balances.

This process recalculate customer sales information base on the invoices entered via OE, POS and AR.

OK. Thanks. We'll try that during our Friday common lunch (we don't have time during the day where everyone is off BV). We'll let you know how it turns out.

We're reorg'ing tonite. We'll let you know if this fixes things.

Hi - we did the reorg as you suggested last night (File > Reorganize Files, select the Customer file and then in the right part of the window select to recalculate Sales Statistics and also to  recalculate Present Balances). That did not fix things at all. The exact same sales still show up. Any other suggestions?

Hello,

It looks like we will need to perform further investigation to narrow down the cause and as such it would be better to work on this offline. Can you please let us know if you are on a Business Care Plan so that a support analyst can contact you and assist further. Please email you account information to [email protected].

Thank-you.

We do not have a Business Care Plan. We do have a BV Business Partner, however.  I guess we have to go down that road, then, since this Sage BV forum doesn't have an answer.