Account,Balance,Dynamics,When, computer Account Balance in Dynamics GP When Past Years Are Not Close
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
As side effect, your Balance Sheet report (either in Great Plains Advanced Financials, or in FRX or even in Microsoft Management Reporter actual for newer version Dynamics GP 2010/11.0) is not showing opening balances for the account of Balance Sheet origin and the report doesnt obviously produce correct results. Please, add to the problem the fact, that you do not really want to close the year on the January first, as customer checks are still coming and you need to verify P&L and Balance Sheet report for the last year in order to compile your tax return for the company (where you need the options to be able to compile and post General Ledger correction transactions, just in case of accounting errors). We recommend you the solution -0 deploying Alba Spectrum Balances Brought Forward add-on. Lets review the details:1. Virtual Year Close, versus real closing, where the year going into history final transactions go into custom tables in General Ledger. This is obviously the imitation, but it allows you to show correct Account Summary Inquiry results for BS accounts for the current year (even if the past year is still open in Great Plains). This module is programmed in Dynamics GP Dexterity, it requires custom tables creation, and simple Dexterity chunk file integration (and of course you need to purchase it from Alba Spectrum to get registration key). What the module really does it closes the year based on the calendar or fiscal year date, posting closing year transaction to the custom tables2. Where you could see the opening balances? In GL Account Summary Inquiry and plus in GL Trial Balance Summary and Detail Reports (you will need to open security for the users for these reports accordingly)3. What would be the work around if you do not want to implement BBF module? Well, procedural way is not too difficult, you can simply make a backup of your production company and restore into the newly created company (in Dynamics GP Utilities) and close the calendar or fiscal year there somewhere in the beginning of January. If you do so you can remap FRx Balance Sheet report to this historical company. The funny things, however, when you need FRx Balance Sheet for the new year, you would need to repeat the process again, as you have probably accumulated more revenue and expenses associated transactions in your real production company4. Versions supported. The version, compatible with Dynamics GP 2010/11.0 is just released in December 2010. Also, several historical versions are supported: Dynamics GP 10.0, 9.0, 8.0, 7.5, 7.0. For earlier versions Dexterity chunk should work, but there is some variety in the database platforms: Microsoft SQL Server 2000/7.0, 6.5, Pervasive SQL Server 2000/Btrieve, Ctree. In this publication we recommend you to call us and not to make over promising commitments5. What happens when I close the historical year in Great Plains Dynamics GP? Well, BBF module will recognize this fact and it will go back to the general Great Plains General Ledger Business Logic6. For the additional information on Alba Spectrum Historical Journal Entry module or Balanced Brought Forward, please feel free to call us 1-866-528-0577 or email us [email protected] We serve you USA/Canada nationwide via remote support (web sessions and phone/skype conferences). Local service is available in Western Michigan, Chicagoland, Southern California (LA, Orange County, San Diego), Houston area of the state of Texas
Account,Balance,Dynamics,When,