Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Sales Journal Report
Microsoft Dynamics SL (Archived)

Sales Journal Report

(0) ShareShare
ReportReport
Posted on by Cynthia Audain 1,270

Hi

A client reported that their sales journal and is putting transactions in the correct period.  Let me step back a bit to explain the scenario.

In OM setup they have the option "Post to current OM period" unchecked.  They are presently in their first fiscal period of 01.2018.   They are still reconciling so they have not closed their period to 02;2018 yet.

However, they are presently entering sales orders with November dates.  They noticed that on printing their sales journal instead of the period showing as 02.2018 it is still showing as 01:2018.

Now in the previous version, the sales journals would post to the period reflected in the date of the sales orders but in version 2015, that does not seem to be happening.

Has anyone experienced this issue?  If so or not, are there any suggestions on how to resolve or correct this issue?  

Any suggestions will be greatly appreciated.

Regards

*This post is locked for comments

  • Verified answer
    Cynthia Audain Profile Picture
    Cynthia Audain 1,270 on at
    RE: Sales Journal Report

    Carolyn

    Thanks for the response. Even though this issue existed a while back your input is of value.

    When I realized that the sales journal was not printing in the correct period even though the right option was chosen l submitted the same to support. Unfortunately they did not provide a cause for the issue and suggested that the user put the period before printing the report. However this was already implemented as a temporary measure and was not a feasible solution to the client since this process was being managed by  the Application Server module.

    Funny enough after much investigations, I reviewed the GL setup where they specified not posting to previous periods with the exception of the GL. I removed that option, saved it then put back the same option and saved.  I then ran the sales journal and I noticed it was now printing in the period of the invoice.

    As strange as that probably sound that fixed the issue so I narrowed that down to 'an undocumented feature ' or bug which has not yet been confirmed by Microsoft.

    Thought I post this to assist anyone with a similar issue.

    Regards

  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Sales Journal Report

    Lisa,

    Thank you for posting your question to the forum. I am sorry your post is just getting answered now.

    Per this options details: (I only want to include for future searches on this topic)

    Post Invoices to Current OM Period indicates that invoices should always be posted to the current Order Management period to post, regardless of the date of the invoice.

    This option is applied when a specific period to post is not entered on the Other Information tab of Shippers (40.110.00) or on the Sales Journal (40.690.00) report ROI screen or on the Consolidated Invoice (40.682.00) ROI screen.

    Post Invoices to Current OM Period overrides the standard logic, which assigns the period to post based on the date of the invoice.

    In your post, it was noted "In OM setup they have the option "Post to current OM period" unchecked. " So, per the details above you would expect the date to determine the posting period. I would verify what is in GL setup and look at the dates set for the periods.

    The OM Invoice date will default to the system data, but can be manually updated to a future date. They can also manually update the period on the Other Information tab to force the period.

    I hope this helps.

    Carolyn

    MSDSL Support Engineer

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans