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

[Margaret Knight]

In setting up a unit account there is an option “clear balance during year end close”. I would like to clarify that if checked, it would keep the monthly history, but just not roll the balances forward to the new year.

Thank you.

——————————
Margaret Knight-Dominguez
Director of Finance
Construction Labor Contractors LLC
Richfield OH
——————————

[Bert Green]

Margaret,

Your thinking is correct on this. That box will make it so the balance does not roll forward to the next year. All of your history will still be there.

I was quite happy when that was added to GP as otherwise I had to make sure all of the year-end reports were run and then do a JE to close out the unit accounts and then close the year.

——————————
Bert Green
GP Developer/GP Administrator
Berger Transfer & Storage, Inc.
Saint Paul MN
GP2015/MR CU11
————————————————————————-

[Margaret Knight]

Thank you very much!

——————————
Margaret Knight-Dominguez
Director of Finance
Construction Labor Contractors LLC
Richfield OH
————————————————————————-

[Anthony Guanci]

Nice tip…thank you very much.

——————————
Anthony Guanci
Sr. Manager, Accounting
MorphoTrust USA
Billerica MA
————————————————————————-

[Brad Johnson]

You are correct. it will keep the monthly data, but zero our the Period 0 at the beginning of the following year.

——————————
Brad Johnson
Financial Analyst
Samtec Inc.
New Albany IN
————————————————————————-

[Peggy Link]

Wonderful to hear about this!  Was not previously made aware of it.  Does anyone know if there is a way to update all unit accts at once with this feature?

——————————
Peggy Link
Assistant Controller
National Business Furniture, LLC
Milwaukee WI
————————————————————————-

[Bert Green]

Peggy,

We didn’t have too many so I did it manually. If you have a lot you could go the SQL route. The field that this item is stored in is the Clear Balance field in the GL00100 table.

——————————
Bert Green
GP Developer/GP Administrator
Berger Transfer & Storage, Inc.
Saint Paul MN
GP2015/MR CU11
————————————————————————-