Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Amber Bell]

Hello Everyone,

I had someone reach out to me named . Alex met me at a GPUG Event.

Alex found this blog: https://www.opalbiz.com/dynamics-gp/13th-period-and-reporting/

It shows the option to have an “Adjustment Transaction” checkbox on the GL Transaction Entry screen. Has anyone ever seen this checkbox? How is it enabled? The blog post references a field on the GL30000 table called “Adjustment Transaction”. I looked and that field is in my GP Test Company…i just don’t know how to populate it.

??

——————————
Amber Bell
Training Dynamo LLC
Email: amber@trainingdynamo.com
Website: http://www.trainingdynamo.com
Twitter: @trainingdynamo
——————————

[Kerry Hataley]

Hi Amber,

You need to have the 13th period setup in the company – it is the Adjustment Period… Not a fan personally…

I found this article on how to set it up..

https://community.dynamics.com/gp/b/erpsoftwareblog/archive/2013/01/28/how-to-set-up-a-13th-period-in-dynamics-gp

——————————
Kerry Hataley
CEO & President
Nanook Software, Inc
——————————
——————————————-

[Jo deRuiter]

I saw ‘s response on the 13th Period

Be careful when setting up or using 13th Periods if the client is using Fixed Assets.??

——————————
Jo deRuiter, MCP, DCP
“That GP Red Head”
AISLING DYNAMICS CONSULTING, LLC
WEBSITE: https://aislingdynamics.com/
BLOG: https://community.dynamics.com/gp/b/gplife
770-906-4504 (Cell)

——————————
——————————————-

[Kerry Hataley]

Yup and more with project Accounting – Again not a fan… I know auditors like this, but lets just use Dec 31 or March 31 if gov of Canada….

——————————
Kerry Hataley
CEO & President
Nanook Software, Inc
——————————
——————————————-

[Amber Bell]

Hi

I added a 13th period in the Fiscal Period Setup window. I still don’t see that checkbox. (I entered a transaction to my ?13th period). I closed and reopened GP and still no checkbox.

The article you referenced doesn’t mention that checkbox…any steps I am missing?

(Thanks for the heads up  about Fixed Assets).?

——————————
Amber Bell
Training Dynamo LLC
Email: amber@trainingdynamo.com
Website: http://www.trainingdynamo.com
Twitter: @trainingdynamo
——————————
——————————————-

[Kerry Hataley]

OK, this was bothering me, so I looked back into the source…

The checkbox is there BUT there is no code attached to it..
So I think it is NO Longer functional – Need to fire up 2013 or 2010 to look back…

I do see some notes and comments that starting around 2013, you needed to make period 13 NOT overlap another period, thus period 13 is 12/31/2019 for example…
Had to do with eConnect…

That said, what do you do with legitimate 12/31/2019 entries? 
(So the blog is out of date and not valid any longer I would say.

I hope this helps…

——————————
Kerry Hataley
CEO & President
Nanook Software, Inc
——————————
——————————————-

[David Musgrave]

Hi and

I checked the source code and while there is no code on the checkbox itself, there is code referencing the checkbox. This checkbox becomes visible when the code that checks if the current period has an adjustment period associated with it returns true. This check is made on window open on the starting transaction date and when the transaction date field is changed.

The check calls the glAdjustingPeriod stored procedure in the company database. From what I can tell the adjustment period is an additional period at the end of the period list with the same date as the year end date.

Regards

David

??

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-

[Kerry Hataley]

Thank You David… I missed that – I apologize Amber…

So diving into the code and the stored proc here is what I have found to make this work…

To make it appear, you need to have the following setup and configured:

1. Period 13 setup with a date equal to or greater then the period 12 (Or the last period in a normal setup – Qty 5th period instead of 4 etc)
2. Utilizing the MASS Close button, close all
3. Open the Financial Series for the Adjustment Period (13 in my case)
4. Don’t have any other periods open

Once you do this is works.
But why? What is it doing…

The way it works now, I think is useless… You need to manage open periods to be able to post to this adjustment period, so why have it?

I have submitted an idea to Microsoft… Please Vote!!!
(https://experience.dynamics.com/ideas/idea/?ideaid=2171d021-8d54-e911-b047-0003ff689cd8)

The Adjustment Period (13) for most needs to work so it is functionally useful.
The following is how I would like this to work – I believe the core code is there to work and just needs some tweaking…

1. To Create an Adjustment Period, the Start Date of the period (Last one listed) needs to be the Last Date of the Year;

2. On Financial Transactions and more advanced within the Project Accounting ML Module, the check box Adjustment Transaction, should be visible when this adjustment period date is selected (Last day of the year) but default is NOT checked;

3. When the Adjustment Transaction is not selected and the transaction is posted, then use the period before the adjustment period;

4. When the Adjustment Transaction checkbox is selected and the transaction is posted, then use the adjustment period

A more advance solution would be to have the ability to just have a checkbox when creating or calculating a Fiscal Period and having it as a yes/no so it creates this period automatically – this then solves the adjust the dates when doing this (Which is a pain)… It would also allow for the correct PERDENDT in the SY40100 table – for the pre-adjustment and adjustment periods

——————————
Kerry Hataley
CEO & President
Nanook Software, Inc
——————————
——————————————-

[Kerry Hataley]

Ops forgot image …

——————————
Kerry Hataley
CEO & President
Nanook Software, Inc
——————————
——————————————-

[Amber Bell]

Thank you and ????

I will vote for your suggestion. I had never seen that before. Thanks for all the behind the scenes sleuthing!!

——————————
Amber Bell
Training Dynamo LLC
Email: amber@trainingdynamo.com
Website: http://www.trainingdynamo.com
Twitter: @trainingdynamo
——————————
——————————————-

[Jen Kuntz]

I was about to post something similar to Kerry when I saw it’s all buttoned up now. I used to see it regularly at customers who did have a 13th period. I haven’t seen anyone bother to use it (tick the box) though.

——————————
Jen Kuntz, CPA, CGA, Microsoft MVP (Business Applications), GPUG All-Star
Manager, Business Solutions
Energy+ Inc.
Cambridge, ON, Canada
——————————
——————————————-