GP #LifeHacks 101: Use dimensions WITHOUT Analytical Accounting! MDA to the rescue!

AA (Analytical Accounting) provides the ability to add additional details to transactions without adding new segments to your chart of accounts.  It does a lot of other 'fun' stuff, but before you dive into the deep end... consider an alternative... consider Multidimensional Analysis (MDA for the acronym fans out there). Once thought to be removed … Continue reading GP #LifeHacks 101: Use dimensions WITHOUT Analytical Accounting! MDA to the rescue!

GP #LifeHacks 110: Post Financial Transactions to History

Does this sound familiar?  "I can't close my fiscal year yet... the audit is not finished." Closing a fiscal year in Dynamics GP does a few things, but in particular, it closes the Profit and Loss account balances out to the retained earnings account. Many customers fear closing their fiscal year because their previous years … Continue reading GP #LifeHacks 110: Post Financial Transactions to History

GP #LifeHacks 108: Batch Recovery – Tip to manage this like a pro using Startup folder!

Microsoft Dynamics GP has a great feature that captures posting processes that have issues or get interrupted.  This is EXTREMELY helpful and helps protect GP users against many different reasons a batch would fail to post. Normally we go into Batch Recover (Microsoft Dynamics GP>Tools>Routines>Batch Recovery) for two reasons:  We either receive an error when … Continue reading GP #LifeHacks 108: Batch Recovery – Tip to manage this like a pro using Startup folder!

GP #LifeHacks 112: SQL View turned Excel Report for Fiscal Period Closing data

I have been using Mass Close for a few years now.  Not many Microsoft Dynamics GP users use it (in my experience).  I like to use it because it is origin specific closing, versus Series specific closing - the later is used by most everyone. The 'trouble' with Series closing is that there are times … Continue reading GP #LifeHacks 112: SQL View turned Excel Report for Fiscal Period Closing data

SQL View turned Excel Report for Fiscal Period Closing data

I have been using Mass Close for a few years now.  Not many Microsoft Dynamics GP users use it (in my experience).  I like to use it because it is origin specific closing, versus Series specific closing - the later is used by most everyone. The 'trouble' with Series closing is that there are times … Continue reading SQL View turned Excel Report for Fiscal Period Closing data

GP #LifeHacks 109: Don’t waste paper, turn off those wasteful reports!

As an accountant myself, I completely understand the desire to have a paper audit trail. After all, you will be the hero at audit time when you get asked for the posting journal for that one entry.  Much like green bar paper, printed versions of most reports just simply aren’t needed anymore.  Isn’t technology great?  … Continue reading GP #LifeHacks 109: Don’t waste paper, turn off those wasteful reports!