Link to home
Start Free TrialLog in
Avatar of scotthoovercpa
scotthoovercpa

asked on

Great Plains Sales by Customer

Is there an easy way to generate a report showing sales by customer for the year in GP?  I would like the report to tie to the sales total on the general ledger.
Avatar of scotthoovercpa
scotthoovercpa

ASKER

Looking for an easy way to generate a sales by customer report in Microsoft Dynamics GP 10.0.  I need the report to tie to sales shown on the general ledger.
Avatar of Victoria Yudin
The only way to ensure that your report ties to the GL is to report on it from the GL.  If you are posting to the GL in detail, then each GL transaction will track an 'originating master number' - for sales transactions this will be the Customer ID.  You can get this in SmartList under Account Transactions - add the Originating Master Number column and filter on your date range and account number(s). If this is not what you're looking for, please write back with some more details.
"To tie with your GL" If everything goes in the right way, the report total will tie to your GL. So, I think you better take this report from Sales Module and if doesn't match the GL, do the required reconciliation. Don't expect the missmatch and accept it, because missmatch means lossing the subledger or GL features.
Sales transactions are posted in batches.  If you go to the GL account, select the batch, and click on journal entry you can see the transactions that are in the batch.  However, that detail does not seem to be showing up on SmartList.  So we are left with trying to figure out how to get sales by customer reports to tie to the GL.  We do have Frx if that helps.

Thanks,
Scott
ASKER CERTIFIED SOLUTION
Avatar of Victoria Yudin
Victoria Yudin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial