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

[Adam Ashby]

I have an issue that I am trying to figure out. My client closed out year end like they always do for the last 5 years. They never seem to have an issue. However this year as they ran it on December 31, 2016 and let it process – they came back to work on January 4, 2017 and attempted to run a T/B for 2017. The main checking account doesn’t show on the report. I figured it was because they didn’t reconcile. They reconciled. Still got nothing to show up. The owner is freaking out because when the T/B is run there are no checking account figures to go with the Debits and Credits.

Can someone help me. Thanks!!

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————

[Leslie Vail]

Hi,
Am I understanding that the cash account tied to the checkbook is just flat missing from the T/B? If you look at the account using inquiry, do the balances show?
Leslie

——————————
Leslie Vail
Accounting Systems Consulting, Inc.
Dallas TX
——————————
——————————————-

[Adam Ashby]

If I look at check register there is the correct balance. If I print a Trial Balance for 2017 the beginning balances are 0.00 for all accounts (more importantly the checking account). However, if I print a Trial Balance for 12/31/2016, the report is correct. It just seems when year end closed, the beginning balances did not carry forward. I do not know why.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Sherry Silva]

Hi Adam – Did you verify the Retained Earnings account under Tools – Setup – Financial – General Ledger?

——————————
Sherry Silva
Chatham Financial
Kennett Square PA
——————————
——————————————-

[Pieter du Toit]

Is the GL account for the checking account still set up with a Posting Type of Balance Sheet?  It almost looks as if it got cleared to retained earnings instead of the balance being rolled forward.

——————————
Pieter du Toit

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

[Adam Ashby]

How do i check the posting type? Thank you to everyone that is responding to this thread and helping me out! I am still trying to learn and take over this mess.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Adam Ashby]

Sorry but I found it, it is balance sheet.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Adam Ashby]

Retained earnings for 2017 is zero. There is a negative period balance for all 12 periods.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Rob Klaproth]

Most likely their checkbook GL account posting type was set incorrectly. It needs to be set to a balance sheet account to roll over the balance otherwise it goes to retained earnings if it was set to p&l.  

Unfortunately since they are on GP2010 they do not have the undo year end close routine so you will have to work with Microsoft support to get the scripts and proper instructions to reopen the year and fix the account type or you can make an adjusting entry to the GL.  

Sent from my iPhone

——Original Message——

If I look at check register there is the correct balance. If I print a Trial Balance for 2017 the beginning balances are 0.00 for all accounts (more importantly the checking account). However, if I print a Trial Balance for 12/31/2016, the report is correct. It just seems when year end closed, the beginning balances did not carry forward. I do not know why.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————

[Adam Ashby]

Luckily it is set as balance sheet. The retained earnings do not have balances in them.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Joni Finnell]

Adam:

I would review the Year End Closing Report that has the Closing Entry JE. If no balance sheet accounts are on it then it would at least rule out that possibility. If you do have the wrong posting type check out KB864913.

Thanks

——————————
Joni Finnell
Project Accountant/GP Troubleshooter
Consumer Support Services, Inc.
Newark OH
——————————
——————————————-

[Shawn Dorward]

This is GP2010 so I am thinking this is an option in the report itself.  Just a thought.

1 – Check and make sure the year actually closed. – Look at the financial/inquiry/summary window – be sure you choose history and 2016 for the account.  If it closed, the account will be in history, not open.
If that looks good, then check Open/2017 for the same account – does it show the beginning balance?  Send us screen shots if you can.
2- Check and make sure the option in the report is set to the correct year!  Not just the correct date range, the correct year.  This might be the only real problem:  even if the date range says 2017 but the year says 2016, the report will not work.

——————————
Shawn Dorward
Twitter: @ShawnMDorward
Implementation Consultant
InterDyn Artis
——————————
——————————————-

[Windi Epperson]

Hi Adam,
After doing Shawn’s suggestions, I would rebuild the reports dictionary.  We’ve seen the TB get quirky like this before and a dictionary rebuild usually does it. 
Thanks
Windi

——————————
Windi Epperson
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 Ext 102
——————————
——————————————-

[Adam Ashby]

Wendy: wouldn’t the summary inquiry that Shawn is indicating show a Beginning Balance because I wouldn’t think that is driven by the report dictionary.

Shawn: attached are my summary inquiry as you suggested.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Adam Ashby]

This is the posting type.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Adam Ashby]

Just to note that this being the first time I am trying to take over a job like this, the environment is great and you guys are SO knowledgeable and helpful! While I still am looking for a resolution and hopefully one of you will be able to help me, THANK YOU FOR ALL RESPONDING! I look forward to a solution!

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Diana Doane]

In the screen shots of the Account Summary the names of the windows were cut off so couldn’t tell, was the inquiry for 2016 done in the History Summary or just the Summary inquiry?   In GP2010, if you can see 2016 in the Summary Inquiry but not the History Summary Inquiry, the year isn’t actually closed and moved to history which is why the balances aren’t rolling forward for the TB.

When you say, the year was closed, was the Routine – Year End Closing actually run in the Financial module or were the Fiscal Periods marked as closed?  Running the Year End Closing Routine is what provides the year end report Joni pointed to for review and rolls the P&L balances to retained earnings and balance sheet accounts forward.

——————————
Diana Doane
Ascend Learning, LLC
Leawood KS
——————————
——————————————-

[Bert Green]

Take a look at that screen it will say what the last closing date was.

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

[Amber Bell]

I had a client that had a Year-End Close fail. If they left it running and it failed in the middle of the close (and they were not there and then clicked past any errors or warnings), the close could have completed part of the close tasks and failed on the rest.

I worked with a partner I can recommend that was able to troubleshoot and fix using SQL. This is tricky and can be expensive.

I always have clients spot check a few accounts to make sure they closed properly…and I make sure they print and save a text file of the GL closing report.

Lastly, I have a workbook that covers all the big tasks and checks related to year-end close. Let me know if you have questions or want info.

——————————
Amber Bell
Owner
Training Dynamo LLC
Derby CT
——————————
——————————————-

[Adam Ashby]

Bert is that the screen for:

ROUTINES – FINANCIAL – YEAR-END CLOSING

because it will not let me access that screen as it says someone is posting.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Adam Ashby]

Sorry it was ACCOUNT Summary.

The process that was done was the standard ROUTINE – FINANCIALS – YEAR END
They are not marked closed fully because they like to edit the years prior if need be apparently

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Adam Ashby]

They showed me for the last 5 years this is how they did things:
EXCEPT they didn’t backup or close the fiscal periods. They say they never do that.

https://support.microsoft.com/en-us/help/888003/year-end-closing-procedures-for-general-ledger-in-microsoft-dynamics-gp

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Rob Klaproth]

You do not have to close the fiscal periods, but it is recommend to prevent users from posting transactions to the historical periods.   A backup is not required, but if you do not do a backup, you will not be able to recover, especially since you are on GP2010 and do not have the undo fiscal close option.

If the balances aren’t rolling over, then the year was not closed, or something happened during the year end close process.  The balances always roll over when the account is set to “Balance Sheet” as shown in the screen shot you sent.  

In your year end close window (tools – routines – financial – year end close) does it show the last closed year as 2016?

If so, and the balances did not roll over, you definitely have an issue, or there was no balance to roll over at the end of 2016.  What was the closing balance of that GL account on 12/31/2016?  You can run a trial balance detail (reports – financial – trial balance, select detail from the window.  In the options for the year, if 2016 is closed, select historical and 2016, and then in the date range enter 12/01/2016 to 12/31/2016 and click insert and run the report, locate the account in question and review the balance as of 12/31.

If your last closed year shows 2016, and there was in fact an ending balance as of 12/31/2016 on the trial balance, then something went wrong with your year end close.  You would either need to restore from a backup or contact your partner’s support line, or Microsoft Support to have you fix this.  If there is in deed a severe problem with this, then I don’t think you’ll be able to resolve it via emails in a support forum, you’re going to want to have someone do a desktop share with you and review your SQL tables and some reports in your system to try and figure out what’s going on.

Rob Klaproth

Sr. Consultant II – Dynamics GP

rob.klaproth@amllp.com

 

Armanino^LLP

11512 El Camino Real Suite 311 | San Diego, CA 92130

858 794 9401 main |  858 207 5137 direct | 619 243 4939  mobile

LinkedIn | amllp.com

——Original Message——

They showed me for the last 5 years this is how they did things:
EXCEPT they didn’t backup or close the fiscal periods. They say they never do that.

https://support.microsoft.com/en-us/help/888003/year-end-closing-procedures-for-general-ledger-in-microsoft-dynamics-gp

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————

[Adam Ashby]

Hi Rob thank you for answering in depth. If i go to ROUTINES – FINANCIALS and YEAR END it will not let me pass. It says that as user is posting.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Rob Klaproth]

Yes, all users have to be logged out of GP to into that window.

——Original Message——

Hi Rob thank you for answering in depth. If i go to ROUTINES – FINANCIALS and YEAR END it will not let me pass. It says that as user is posting.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————

[Adam Ashby]

OK standby I am going to log everyone out. I appreciate this. Hopefully this is the issue that its not closed out.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Adam Ashby]

OK this is what I have. Last Closing Date says 2015. The CFO said he ran everything but I am guessing this is not the truth.

I am also guessing this is YEAR END and NOT FISCAL YEAR CLOSE.

Problem is I think I remember seeing him run CLOSE YEAR and didn’t do anything but I guess we can have them run thru it again.

Let me know. Thanks so much!

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Rob Klaproth]

Hi Adam,

If the CFO is expecting to see beginning balances for 2017, the 2016 year needs to be closed in the year end close window so that it says last closed year 2016.  I would proceed with closing the year.   He may have ran the close year in another module, I.e. Payables or receivables.     Since you have the opportunity, I would take a backup before running the close.

Rob

——Original Message——

OK this is what I have. Last Closing Date says 2015. The CFO said he ran everything but I am guessing this is not the truth.

I am also guessing this is YEAR END and NOT FISCAL YEAR CLOSE.

Problem is I think I remember seeing him run CLOSE YEAR and didn’t do anything but I guess we can have them run thru it again.

Let me know. Thanks so much!

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————

[Adam Ashby]

Final thing (and once again thank you for the proper direction):
If the CFO had actually run one part (say inventory), if Year-End is run again will that adversely affect what was already run.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Adam Ashby]

Final thing (and once again thank you for the proper direction):
If the CFO had actually run one part (say inventory), if Year-End is run again will that adversely affect what was already run.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-

[Rob Klaproth]

No, you are supposed to close the other modules first before closing the GL, so it shouldn’t affect those modules.

——Original Message——

Final thing (and once again thank you for the proper direction):
If the CFO had actually run one part (say inventory), if Year-End is run again will that adversely affect what was already run.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————

[Adam Ashby]

Update: the COO ran Year End again per the instructions I found on the internet. It worked. So thank you so much for all the painstaking effort ! I couldn’t have done it without you!

BTW: Do you know how to get a partnersource or customersource account? Apparenly I might be dealing with them a little longer. I need to find a way to get Professional Tools for them updated.

——————————
Adam Ashby
LYFE NETWORKS LLC
Valencia CA
——————————
——————————————-