Topic Options
#42135 - 06/27/14 07:47 AM Sales Analysis Reporting
Karen Offline
Karen

Registered: 11/17/04
Posts: 167
Loc: Pine Brook, NJ
Question

Should the inquiry for a MTD sales figure from Sales Analysis (if configured properly) be the same as the income "MTD" in the P&L? If not, can someone let me know why the dollar amounts would be different?

Thanks in advance,
Karen

Top
#42136 - 06/27/14 07:56 AM Re: Sales Analysis Reporting [Re: Karen]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Off the top of my head, the dollar amounts may be different because
  • The general ledger is fiscal period based, and SalesAnalysis is using the calendar month.
  • SalesAnalysis is including taxes and/or miscellaneous charges in the amounts it is reporting.
  • Someone has edited and changed the amounts in the SA database.
  • Someone has purged transactions in the SA database.
  • There are still transactions waiting to be retrieved into Ledger or SalesAnalysis.
_________________________
Andrew Bates

Top
#42152 - 06/27/14 04:36 PM Re: Sales Analysis Reporting [Re: Retired_Guy]
Karen Offline
Karen

Registered: 11/17/04
Posts: 167
Loc: Pine Brook, NJ
Thank you Andrew. I exported data from both to analyze and compare. I had our business advisor in the office and it was frustrating not being able to give him what should have been a simple answer. What made it worse was I couldn't answer "why".

I appreciate your response.

Top
#42154 - 06/27/14 06:34 PM Re: Sales Analysis Reporting [Re: Karen]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3612
Loc: Toronto ON, Canada
Karen:

Also:
  • Someone has made a General Journal posting to the Revenue account(s)
  • Billing Item(s) in Invoices is/are defined to credit an account other than a Revenue account
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (1 invisible), 52 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30