Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Total Sales YTD and SO...
Microsoft Dynamics GP (Archived)

Total Sales YTD and SOP Sales Transaction History Report

(0) ShareShare
ReportReport
Posted on by Hayaty 730

Hello,

We realized a discrepancy between Customer Summary and SOP Sales transaction history report.
When I set up the same criteria, such as from Jan 1st, 2010 to May 24th, 2010, both reports shows the same amount of Sales YTD. However, when I use the default set-up, means chose "Amounts Since Last Close" as Summary View on Customer Summary Window, the window shows the different amount as the Sales YTD amount with the SOP Sales Transaction History Report with Jan 1st, 2010 to May 24th, 2010 as document date, because our fiscal year is Jan to Dec, and we closed the last year at the beginning of April, 2010. These should show the same Sales YTD amount. Does anyone how to fix this problem? Please help!

*This post is locked for comments

  • Sagi88 Profile Picture
    Sagi88 2,250 on at
    Re: Re: Re: Total Sales YTD and SOP Sales Transaction History Report

    Hi Hayato.

    Typically sales are closed at period end but AP is closed a few days later to allow for invoices to come in and financials a bit later once bank reconcilitaions and asset depreciations are done.

    Dynamics GP allows for this flexibility but you can enforce your own requirements by closing periods for all modules at the same time with the Company's fiscal period windows.

    Also, you can control not posting to a closed year with t he General setup window.

    Hope this helps

  • Hayaty Profile Picture
    Hayaty 730 on at
    Re: Re: Total Sales YTD and SOP Sales Transaction History Report

    Frank,

    Thank you for your reply. I understood why the differences between SOP report and Smart List. However, I'm not clear why the financial module can be opened after the end of the fiscal year? I would appreciated it if you can explain it. I thought all module should be closed at the same time. Thanks!

    Hayato

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,319 Super User 2025 Season 1 on at
    Re: Total Sales YTD and SOP Sales Transaction History Report

    The problem is being caused by your having not closed the Sales year until April.  In order to maintain the Summary amounts in SOP or POP, the closing of those modules must be done on the last day of the fiscal year, or at least prior to any posting of transactions in the new fiscal year.  Closing of any module except financial is date-sensitive and closing them after the end of the FY will cause any new transactions to be included in the previous year's summary.

    You can correct this by updating the amounts in the Customer Summary card or via SQL script by updating the RM00103 and RM00104 tables.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,329 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans