All About Accounting Software

Account Balance in Dynamics GP When Past Years Are Not Closed Yet

Account Balance in Dynamics GP When Past Years Are Not Closed Yet

Account Balance in Dynamics GP When Past Years Are Not Closed Yet


Free Online Articles Directory




Why Submit Articles?
Top Authors
Top Articles
FAQ
ABAnswers

Publish Article

0 && $ .browser.msie ) {
var ie_version = parseInt($ .browser.version);
if(ie_version Login


Login via


Register
Hello
My Home
Sign Out

Email

Password


Remember me?
Lost Password?

Home Page > Computers > Software > Account Balance in Dynamics GP When Past Years Are Not Closed Yet

Account Balance in Dynamics GP When Past Years Are Not Closed Yet

Edit Article |

Posted: Dec 17, 2010 |Comments: 0
|



]]>

This is known Accounting system puzzle and dilemma, related to the Accounting theory – if you do not close the Year in your General Ledger, your P&L accounts balances are not folded into Retained Earnings and BS accounts do not get their current year beginning balances.  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 doesn’t 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.  Let’s 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 tables

2. 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 company

4. 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 commitments

5. 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 Logic

Retrieved from “http://www.articlesbase.com/software-articles/account-balance-in-dynamics-gp-when-past-years-are-not-closed-yet-3868322.html

(ArticlesBase SC #3868322)

Watch your traffic increase just by submitting articles with us, click here to get started.
Liked this article? Click here to publish it on your website or blog, it’s free and easy!

Andrew Karasev -
About the Author:

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP customers USA and Canada Nationwide: California, Minnesota, New York, Quebec, Ontario, Illinois, Texas, Georgia, Arizona, Nevada, Virginia, Florida, new Mexico, Iowa, Indiana, Alaska, Hawaii. Local service is available in Houston/Dallas: Richmond, Rosenberg, Katy, Galveston, Sugar Land; in Chicago: Naperville, Aurora, Plainfield, Romeoville, Batavia, Downers Grove, Schaumburg, Rockford, Elgin, Crystal Lake, Joliet, Hinsdale, Lisle, Montgomery, Oswego

]]>

Questions and Answers

Ask our experts your Software related questions here…

Ask

200 Characters left

Hi I am 24 years of age I have a 3 year old child and dont think childbirth is the cause for my hairloss.ive had alot of stress over the year but in the past year my hair has thinned out all over espe
Does it look bad to close a credit card account ?
I m trying to lose wieght frm my thighs, buttocks and hips from a very long time. i go to the gym 6 times a week from last 5-6 years and i am cautious about my diet.I eat a balance diet.can u suggest?

Rate this Article

1
2
3
4
5

vote(s)
0 vote(s)

Feedback
RSS
Print
Email
Re-Publish

Source:  http://www.articlesbase.com/software-articles/account-balance-in-dynamics-gp-when-past-years-are-not-closed-yet-3868322.html

Article Tags:
dynamics gp, posting to historical year

Related Videos

Related Articles

Latest Software Articles
More from Andrew Karasev


The Role Of Communication With Accountability

Gary Ryan Blair discusses New Year’s resolutions and how does communication play a role with accountability (00:51)


Why Your 401(k) Might Only Provide ,100 a Year

A new industry-backed study says people are happy with their 401(k) accounts. But the average retirement account holds only enough money to provide retirees with ,100 a year in income. That’s not enough. (02:03)


How to Change a Tax Return Filing Status from Year to Year

Learn how to change a tax return filing status from year to year in this video that will help you prepare for tax returns. (00:50)


How Recoding Websites as a 20-Year Old Advanced Career

In Chapter 12 of 16, Joe Stump shares two early career confidence building experiences. As a 20-year old, Stump is tasked with building out large scale websites and e-commerce architectures. This trust, aimed directly at someone others might deem too young for the responsibility, shapes Stumps perception for what is possible as well as his appreciation for being responsible and accountable with large projects. Over time, Stump builds upon these, ultimately landing a lead architect role at Digg. (01:08)


Introduction to Quicken Online

In this time of the “Great Recession” many of us are having difficulties with finances. It becomes hard to keep track of what you paid, what you have left, and how much you still owe. In these trying economic times a free product like Quicken Online can be a ray of sunshine. Quicken Online makes it easy to link your online bank accounts together, to create a monthly and annual household budget and to see at a glance how much money you have left each day, week, month and year. (01:18)

Microsoft Dynamics GP Partner Chicago: Great Plains Customizations

If you are deploying Microsoft Dynamics GP, formerly known as Great Plains Dynamics, Microsoft Great Plains (and their predecessor Great Plains Accounting for DOS, Windows and Macintosh), we would like to review Great Plains customization support options in Chicago, Northern Illinois, North Western Indiana, Southern Wisconsin. Special emphasis on Dynamics GP software development, integration, custom programming and modifications

By:
Andrew Karasevl

Computers>
Softwarel
Jan 23, 2010

Development for Microsoft Dynamics GP, formerly known as Great Plains: Dexterity, eConnect, eCommerce programming

Microsoft Dynamics Corporate ERP and CRM family of products includes Dynamics GP (formerly known as Great Plains Dynamics, eEnterprise, Great Plains Select on Pervasive SQL and Ctree), AX (formerly known as Axapta), NAV (known as Navision), SL (Solomon), Microsoft Dynamics CRM (this is CRM application, it might be part of Corporate ERP, but technically it is just CRM).

By:
Andrew Karasevl

Computers>
Programmingl
Dec 16, 2009

Dynamics GP Historical Journal Entry or Posting into the Closed Year

In Microsoft Dynamics GP in General Ledger you can only enable posting transactions into historical year, but only to the most recently closed one. Sometimes you may end up in the situation, when you have to redo multiple GL related transaction batches, one of the examples might be multicurrency revaluation routines.

By:
Andrew Karasevl

Computers>
Softwarel
Dec 16, 2010

Solving the Historical Journal Entry Problem in Dynamics GP

Microsoft Dynamics GP General Ledger allows transactions to be posted into the more recent closed Historical years but not to earlier ones. This restriction is acceptable for the many companies that only make Adjusting Entries into the prior year GL. However companies that are audited are sometimes required to make Adjusting Entries into multiple previous years.

By:
Hussain Zaidil

Computers>
Programmingl
Feb 02, 2011

Dynamics GP Data Migration from Your Legacy Accounting Application

When you are implementing new Corporate ERP application, the question of the data conversion and migration is often on the top of the list. Sometimes your Information Technology department folks may tell you, if Dynamics GP is MS SQL Server based application, they should be able to convert all the data from your legacy ERP into Great Plains tables via SQL insert statements.

By:
Andrew Karasevl

Computers>
Softwarel
Nov 07, 2010

Dynamics GP Partner Newsflash: Recovering Unsuccessful Great Plains Implementations

Microsoft Dynamics GP ERP application, formerly known as Great Plains Dynamics and eEnterprise is in our opinion good fit to the variety of business types: wholesale, retail, services, discrete manufacturing, healthcare, placement & recruiting, field services, pharmaceutical and research firms, shipping and receiving, logistics and warehouse management, and this list is not complete list, feel free to check your case study with us

By:
Andrew Karasevl

Computers>
Softwarel
Aug 28, 2009

Microsoft Dynamics GP Support – Typical Support Issues and Their Resolutions

First of all, thank you for appealing to the internet search engine to get your Great Plains Dynamics GP technical issue resolved. If you have active Dynamics GP annual enhancement plan with Microsoft Business Solutions (and have access to do-called Customer Source), the first step in getting technical help is logging to MBS Customer Source and searching knowledge base.

By:
Andrew Karasevl

Computers>
Softwarel
Oct 23, 2010

HAL.DLL Missing or Corrupt

General situation Recently a laptop was submitted to me for diagnosis and rectification of this error. What I assumed incorrectly to be a 5 minute job turned out to be a 10 hour job. The error reported was simple – laptop running Windows XP Media Center Edition refuses to start with HAL.DLL Corrupt or Missing error message.

By:
ccx529l

Computers>
Softwarel
Mar 03, 2011

Windows XP Setup – Missing HAL.DLL

Many people (including me) have (had) problems with the file hal.dll when installing on a fresh new hard disk. The proposed solutions do not
work in this case because there is a dynamic drive overlay (ddo) installed. The solution is quite simple: remove first the ddo (for
example with Seagate’s DiscWizard: and re-install windows xp.

By:
ccx529l

Computers>
Softwarel
Mar 03, 2011

How to perform dll repair

Earlier, when every MB of hard disk space meant money, there was a need for a technology that enabled developers to create applications that consumed less storage space on the system

By:
ccx529l

Computers>
Softwarel
Mar 03, 2011

What are DLL files used for?

A Dynamic Link Library (DLL) file comprises a program code that is used by Windows operating systems and applications installed on them to perform one or more functions. DLL files cannot be run manually by users. They need to be called on either by other DLL or executable files.

By:
ccx529l

Computers>
Softwarel
Mar 03, 2011

General steps to fix dll errors

While most DLL errors are unique there are some steps that you should attempt before attempting to search for and reinstall the DLL you need from the Internet. Not all websites are trustworthy and, as such, you run the very real risk of potentially installing a virus or spyware riddled DLL onto your system. In most cases you should be safe, but if you can avoid taking the risk then you will avoid the possibility altogether.

By:
ccx529l

Computers>
Softwarel
Mar 03, 2011

DLL hell error fix

In computing, DLL hell is a colloquial term for the complications that arise when working with dynamic link libraries (DLLs) used with Microsoft Windows operating systems, particularly legacy 16-bit editions which all run in a single memory space. Although the term is Windows-specific (the more general term is dependency hell) the rhyme is often used to depict a dependency hell case.

By:
ccx529l

Computers>
Softwarel
Mar 03, 2011

30 common dll errors

A lot of DLL errors are very specific to what you are doing when the error occurs. This is because a DLL can contain such a large number of different functions, of which you probably only require one or a small number at a time.

By:
ccx529l

Computers>
Softwarel
Mar 03, 2011

Best Registry Cleaner Software Reviews

If you are looking at cleaning your computer’s registry then you will want to get the best registry cleaner software. There are many things to consider when deciding which the best is. Find out about the Best Registry Cleaner Software here…

By:
Austin Porterl

Computers>
Softwarel
Mar 03, 2011

Dynamics GP Bank Reconciliation Trivia and Some Advices

Bank Reconciliation module in majority of the implementation is used for Matching Receipts and Payments against Bank statement. This procedure is pretty simple and doesn’t require the knowledge on how to originate transactions directly in BR.

By:
Andrew Karasevl

Computers>
Softwarel
Mar 01, 2011

Dynamics GP GL Advanced Topics: Matching, Multidimensional Analysis, Organization Structure

Sometimes we consider General Ledger module as the destination for the distributions from subsidiary ledgers, where all you need to do is verify batch totals, distribution and post the batches, originated in other modules. Microsoft Dynamics GP offers several powerful tools within GL itself, where you can go beyond the traditional routines

By:
Andrew Karasevl

Computers>
Softwarel
Feb 28, 2011

Dynamics GP Organization Structure or Implementing General Ledger in Large Corporation

In large organization it might be practical to establish policies, where AP, AR and Accounting personnel has restriction on the GL accounts accessibility.

By:
Andrew Karasevl

Computers>
Softwarel
Feb 27, 2011

Dynamics GP Transaction Matching in Simple Project Profitability Tracking Scenarios

Imagine simple situation, where you would like to sell to your customer in Sales Order Processing module, and then you incur simple expenses: Purchasing parts in Purchase Order Processing, allocating existing inventory items, etc. These modules are independent. They all post their transaction to General Ledger

By:
Andrew Karasevl

Computers>
Softwarel
Feb 26, 2011

Dynamics GP Customer or Vendor Master files recovery

There might be unpleasant situations, when you realized that you cleared master table cluster in production company, while being under impression that you are working with test environment. Plus, unfortunately your SQL Server Agent was not started and backup is not an option.

By:
Andrew Karasevl

Computers>
Softwarel
Feb 24, 2011

Dynamics GP Creating New Company and Loading it from Another DB Backup

When you are running multiple companies, in the environment, where you are serving as accounting outsourcer, it is possible to work out reasonably simple procedure to create new company without coming through numerous setup routines.

By:
Andrew Karasevl

Computers>
Softwarel
Feb 23, 2011

Dynamics GP Foundation Features or what is new in versions 2010, 10.0

Version 2010 was introduced in April, 2010 and was demonstrated on Convergence 2010 in Atlanta. It might be difficult to judge which feature is revolutionary and which is just small improvement. In our opinion in 2010/11.0 emailing for Sales and Purchasing transactions is very impressive.

By:
Andrew Karasevl

Computers>
Softwarel
Feb 22, 2011

Dynamics GP and Microsoft Word Templates Introduction Level Notes

We will base our example on version 2010, however Word Templates were available for earlier versions, such as 10.0 and we believe also in 9.0. Why would you be interested in Word Templates? There are several reasons.

By:
Andrew Karasevl

Computers>
Softwarel
Feb 21, 2011

Add new Comment

Your Name: *

Your Email:

Comment Body: *

 

Verification code:*

* Required fields

Submit

Your Articles Here
It’s Free and easy

Sign Up Today


Author Navigation

My Home
Publish Article
View/Edit Articles
View/Edit Q&A
Edit your Account
Manage Authors
Statistics Page
Personal RSS Builder
My Home
Edit your Account
Update Profile
View/Edit Q&A
Publish Article
Author Box


Andrew Karasev has 1018 articles online

Contact Author

Subscribe to RSS

Print article

Send to friend

Re-Publish article

Articles Categories
All Categories

Advertising
Arts & Entertainment
Automotive
Beauty
Business
Careers
Computers
Education
Finance
Food and Beverage
Health
Hobbies
Home and Family
Home Improvement
Internet
Law
Marketing
News and Society
Relationships
Self Improvement
Shopping
Spirituality
Sports and Fitness
Technology
Travel
Writing

Computers

Computer Forensics
Computer Games
Data Recovery
Databases
E-Learning
File Types
Hardware
Information Technology
Intra-net
Laptops
Networks
Operating Systems
Programming
Security
Software

]]>

Need Help?
Contact Us
FAQ
Submit Articles
Editorial Guidelines
Blog

Site Links
Recent Articles
Top Authors
Top Articles
Find Articles
Site Map
Mobile Version

Webmasters
RSS Builder
RSS
Link to Us

Business Info
Advertising

Use of this web site constitutes acceptance of the Terms Of Use and Privacy Policy | User published content is licensed under a Creative Commons License.
Copyright © 2005-2011 Free Articles by ArticlesBase.com, All rights reserved.

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP customers USA and Canada Nationwide: California, Minnesota, New York, Quebec, Ontario, Illinois, Texas, Georgia, Arizona, Nevada, Virginia, Florida, new Mexico, Iowa, Indiana, Alaska, Hawaii. Local service is available in Houston/Dallas: Richmond, Rosenberg, Katy, Galveston, Sugar Land; in Chicago: Naperville, Aurora, Plainfield, Romeoville, Batavia, Downers Grove, Schaumburg, Rockford, Elgin, Crystal Lake, Joliet, Hinsdale, Lisle, Montgomery, Oswego


Article from articlesbase.com

More General Ledger Articles


No comments