web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Recurring journals - codes for the "recurring frequency" column...

(0) ShareShare
ReportReport
Posted on by 390

Hello All,

Does anyone know where to find the various "recurring frequency" codes for the second column in the recurring journal?  I am trying to set up a reversing entry for an specific date in the future.  

Thank you very much!

  • Suggested answer
    Soren Groes-Petersen Profile Picture
    Microsoft Employee on at

    Hi ait-2017 - It is a so-called date formula field, which means that you must manually enter any of the allowed formulas to indicate a period, such as 1W.

    For more information, see the "Using Date Formulas" section in this topic: https://docs.microsoft.com/en-us/dynamics365/financials/ui-enter-data

    Soren

  • Petronila Profile Picture
    390 on at

    Hi Soren -- thank you for the link, very much appreciated!  

    Somehow I am having trouble making the frequency codes work.  No matter what frequency code I use, the system is reversing the transaction the next day after it posts the entry.   Below is a quick summary of how I setting up the entry:

    Under recurring method -- I have selected "reversing variable"

    Under recurring frequency  -- I selected - CM+180D

    Not sure why it doesn't work...

    Thanks again for your help!

  • Suggested answer
    Soren Groes-Petersen Profile Picture
    Microsoft Employee on at

    Hi ait-2017 - I have added more documentation for Recurring Journals, which may help you understand why your setup doesn't work (will be live and context-sensitive soon): 

    https://review.docs.microsoft.com/en-us/dynamics365/financials/ui-work-general-journals?branch=master

    Soren 

  • Verified answer
    BrianNielsen Profile Picture
    335 on at

    You can use recurring journals - see Søren's link to the help on this feature - but the reversing entry will always happen the next day.

    I think when the feature was added to the product we mainly thought of reversing sceanrios like period-end cost/revenue allocation and correcponding reversals (like for subsciption-like contracts where you would post the journal on last day of month and reverse first day of next month). So reversing basically only makes sense when you do it on the last day of the month (or accounting period if you're using that).

    I've created a backlog entry for us to improve the feature.

    Best regards,

    Brian

  • Petronila Profile Picture
    390 on at

    Hi Soren -- I couldn't open the link, it looks like I do not have the right credentials....  below is the message that I get..

    We are sorry, the page is forbidden.

    You do not have permission with this credential, please sign out to try with others and go back again.

    Sign Out

     


    Thanks!!

  • Petronila Profile Picture
    390 on at

    Hi Brian -- yes, that's what is happening...

    Yes, I do use this feature for end of the month adjustments that need to reverse the  beginning of the following month.

    I will check back with you in few months....

    Thanks!!

  • Suggested answer
    Soren Groes-Petersen Profile Picture
    Microsoft Employee on at

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans