How to create a periodic Journal Entry

  • By Semra Tuzin
  • 23 Nov, 2017

1.     General ledger  > Periodic  > Journals  > Periodic journals .

2.     Click on New.

3.     In the dropdown under Name click GLRECURRIN journal type.

4.     In the top ribbon click Lines.

5.     Click New.

6.     In the date field select the date.

7.     Click on the dropdown arrow on Account Type and select the type of Account.

8.     In the Description field add a description for the journal.

9.     Enter the Amount you would like to debit or credit in the journal.

***if your journal amount has taxes this is the amount INCLUDING taxes***

10. Click on the Units dropdown and select the unit of measure for the period.

   a. Would you like to post in days or months?

11. In the Number or Units field select how often you would like the journal posted.

   a. For example: If you would like to post the journal once a month the unit would be months and the Number of units would be 1.

   b. If you would like to generate quarterly postings Units would be months and the Number of Units would be 3.

Follow step 12-14 if the journal has Sales tax. Keep in mind the amount is INCLUDING taxes.

12. Click General

13. Under Sales Tax in the Sales tax group field select the group and in the Item Sales Tax group select ALL

14. To see how much taxes are allocated select Sales Tax on the ribbon on top.

15. Click File then save.

We have generated a period journal. Now we have to post them.

How to post Periodic Journals.

16. General ledger  > Journals  > General journal

17. Click New.

18. Click Lines.

19. Click on Period Journal.

20. Click on Retrieve Journal.

21.  On the To Date: Select the date of the Journal you would like to post. Be very weary of what date you select. If you open a journal you have to post it because the ones you do not post will get deleted.

   a. For example: If I had Journals for January, February, March and I put the dates so I can view January and February but decided only to post January. I would have to redo a journal for February because the next journal available to post will be March.

22. In the Periodic Journal Number Drop down you can select your periodic journal.

23.  In the Copy or move journal Select Copy if you would just like to copy the periodic journal to the voucher. Select Move, if you would like to move the journal to after it has been posted.

24. Click Ok and the details of the journal will appear in the Journal Voucher form. Here you can edit the Journal lines.

25. Click Post >Post

By Simon Bradford 14 Dec, 2017

Inventory planners have a tough job, they need to make decisions on inventory based on incomplete data, for multiple items and warehousing locations. AX Forecasting is designed to help remedy some of the guess work by allowing customers to inform you of their expected needs, avoiding supply headaches and surcharges for late deliveries.

By Remington Hall 12 Dec, 2017

Convenience:  We give you an opportunity to learn from the comfort of your home, office, or client location. If you have an internet connection you are ready to learn!


Clarification:  Opportunity to ask questions with interactive, hands on answers.


Affordability:  We hold our webinars at no cost, saving you time, and money while avoiding travel.


Recorded:  We try to record every webinar, giving you the ability to share content with co-workers. Also allowing you to watch the webinar if you signed up but were unable to attend.


Knowledge: Gaining knowledge on something you weren’t familiar with before can always be beneficial whether it be applicable in the present or the future: Knowledge is power!


Learn from the Pros: Since webinars are time saving, companies are able to get their most knowledgeable employees to participate/ present these online presentations.


Just the beginning:  After attending a webinar, you are able to see if the topic is suitable for you. If so, we are able to simply schedule a more in-depth call or webinar with you individually.


Relevant Topics: You are able to know exactly what we will be discussing in the webinar before attending, if you see that you are not suitable for the webinar it is much easier exiting a tab than driving back to the office.

By Semra Tuzin 07 Dec, 2017

Role Centers is a dashboard that can have transactional data, alerts, links, common tasks, reports and more. It contains Web parts which are located in zones. Web parts display data and allow the user to customize what data they would like to see. Web parts can be arranged into different web part zones on a page (Would you like this information to show on the right side, left side, Infolog, header, footer and etc.?). You can customize to show only information you are interested in. There are two types of views: personal and shared. Personal means that you are customizing the role center so only you can see the customized view. Shared is when everyone can view the customizations.

By Sarah Breuls 05 Dec, 2017

When it comes to taxes in Sage 300 ERP, there are 4 main steps that need to be done

1. Tax Authorities – This is where you create the individual tax code with a configuration that will define whether the tax amount is to be added to the cost or has to be expensed out with it comes to purchasing. We also assign the liability account that will be used for transactions

2. Tax Classes – This is where you define the classes for each individual authority which is setup in step 1. Typically, it will have two classes one will be “taxable” and the other “non-taxable” this will be setup for Sales/Purchases, Customers/Items and Vendors/Items

3. Tax Rates – This is where you will define the rate of which the authority will calculate at for both Sales and Purchases

4. Tax Groups – This is where we can assign multiple tax authorities together as some transactions may need to have multiple tax codes calculate at once. This will also need setup for both Sales and Purchases

By Semra Tuzin 30 Nov, 2017

This report can be used to view the Gross Margin per Customer. It can also be used to view Sales for a particular day or date range. You can filter the report to show all customers, specific customer, Sales Order or even Item.

By Aleks Azarchankau 28 Nov, 2017
In this blog, we will be discussing how to create and post trade agreements in Microsoft Dynamics AX via X++ code. This will be done via the PricePriceDiscJournalService , which is an AIF service.
By Semra Tuzin 23 Nov, 2017

1.     General ledger  > Periodic  > Journals  > Periodic journals .

2.     Click on New.

3.     In the dropdown under Name click GLRECURRIN journal type.

4.     In the top ribbon click Lines.

5.     Click New.

By Jennifer Holman 21 Nov, 2017

We often find ourselves needing to find more information on customers, transactions, balances, projects, and expenses. We want this information quickly and easily visible. Microsoft AX 2012 and Dynamics 365 visual grids exports to excel using a simple keyboard:

command, Ctrl T.

Take Customer Transactions as an example:

Navigate to the ALL Customers – Highlight the customer account to review the Transactions. And Select the Transaction Button

By Jennifer Holman 16 Nov, 2017

When Implementing a new solution like Sage 300 or Microsoft Dynamics look at funding options for your business in Canada.

A funding program we partner with is the Canada Job Grant (CJG),  it helps cover training costs during an implementation based on the number of employees on staff and involved in the ERP Software training.  

By Semra Tuzin 14 Nov, 2017

1.       Accounts Receivable > Common > Customers > All Customers

2.       Double click the “Child” Customer. In this example the child is ABC Company 2 and the parent is ABC Company.

3.       Click Customer > Edit

4.       Scroll to the bottom and select the Invoice and Delivery tab

5.       Click on the dropdown menu and select the “Parent” Company

More Posts
Share by: