Setup periodic journal

This article describes how to setup and use periodic journal in Dynamics AX 2012.  Periodic journals are sometimes called recurring journals because the amount, text, and other information are repeated each time that the journal is posted. When you create the journal, you can specify the period interval for the recurrence, such as days or months.

PeriodicJournalGL001

1/ Prerequisites

You need to create a new journal name to use the periodic journal functionality.

Access: GL > Setup > Journals > Journal name

PeriodicJournalGL005

2/ Setup periodic journal

To setup a periodic journal, there are several options : create periodic journal from the general journal form or from the periodic journal form.

Option A: General journal form

Access: GL > Journals > General journals

  • Create a new journal
  • Go to the line form an enter all your data (date, accounts, amounts, description, …)

PeriodicJournalGL002

  • Click on Period journal > Save Journal

PeriodicJournalGL003

  • Select a periodic journal
  • Enter a name.
  • Click on “OK”

PeriodicJournalGL004

  • Go to Periodic > Journals > Periodic journals to update data

PeriodicJournalGL009

  • Click on Lines
  • Enter (if needed) a unit and a number of unit : for example, if the journal must be posted every months, enter unit = month and number of unit = 1.

PeriodicJournalGL010

Option B: Periodic journal form

This option is better if you need to setup period interval recurrence.

Access: GL > Periodic > Journals > Periodic journals

  • Click on New
  • Select a periodic journal name
  • Enter a description

PeriodicJournalGL006

  • Go to the lines form
  • Enter a date (firs date)
  • Enter regular data : account, offset account, amount, description, …
  • Select a unit and a number of unit : for example, if the journal must be posted every months, enter unit = month and number of unit = 1.
  • The “Last date” field will be updated automatically by the system.

PeriodicJournalGL007

3/ Use a periodic journal

Access: GL > Journals > General journal

  • Create a general journal
  • Go to the Lines form
  • Click on Period journal > Retrieve journal

PeriodicJournalGL008

  • Enter a “To date”
  • If the line in the periodic journal does not have a transaction date, you can select one in the Empty date field. If you do not select a date in this field, the date in the To date field becomes the transaction date.
  • Select a periodic journal
  • Select an option: Copy or Move. (choose Move only if you do not need to use again the periodic journal)

PeriodicJournalGL011

  • Journal lines are created. In this example, the to date is 3 months later than the today date, that why the system creates 3 lines, one per month.
  • Check the journal and post it.

PeriodicJournalGL012

Remark : When a journal is created, the periodic journal is automatically updated : the date become the next date and the Last date is updated with the journal date. 

PeriodicJournalGL013

4/ Use a periodic journal with option Move

Access: GL > Journals > General journal

  • Create a general journal
  • Go to the Lines form
  • Click on Period journal > Retrieve journal
  • Enter a “To date”
  • Select a periodic journal
  • Select “Move”

PeriodicJournalGL014

  • Journal line is created.

PeriodicJournalGL016

  • Periodic journal line is deleted

PeriodicJournalGL015

Advertisements

One thought on “Setup periodic journal

  1. Pingback: General journals with template | My Financial Dynamics AX

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s