SHORT DynamicAccounting.net Outages

The website will down for very short periods of time for the next day or two (about 5-10 minutes). The new server is ready, the content is migrated but I’m having trouble getting DNN to come up properly and I need the real URL for testing. Apologies.

Advertisements

Open Source ERP

I’ve been thinking a little about open source ERP systems. Compiere seems to be leader. It’s free, but they nickel and dime you on documentation, support, etc.

The biggest problem with Compiere is that it uses an Oracle (or now Sybase) database. What’s that all about? It may be cheaper to buy SQL Serve and Great Plains than to buy Oracle and get Compiere for free. Not mention the pain of running Oracle in a small to medium shop.

I think there is room for an MS based open source ERP system. I think it would push the leaders. Great Plains is great because of it’s community, backend and solidness. However, GP is behind in “run anywhere” functionality and Dexterity feels creaky. M. ore likely, I expect to see an open source Linux/MySQL (or Postgre) offering.

Lets face it, ERP systems are complex. They cover a lot of ground and they can function very differently. Solomon, GP and Oracle all process payables, and they all do it differently. I wonder whether the benefits of an open source ERP will hurt comanies? Will a bootstrapping company install it and force it to work with dire consequence? Is the growth from a small business package, like Quickbooks, into a midsize package important?

I guess we’ll have to wait and see.

Oracle buying Siebel

I have to comment on this. Oracle is buying Siebel. I used Oracle financials and played with Siebel in some training classes. What do you get when you merge two hard to use programs? …what do you think?

Siebel’s been a mess for a while. It’s more of a pain than SAP in my opinion, it’s just not as spectacular when an implementation fails. Microsoft Business Solutions finally abanonded a partnership with Siebel after severals years of trying and failing to integrate it with Great Plains. Good luck Oracle, you’re going to need it.

Weekly Review: Extreme Makeover, JE edition

Each week I’d like to cover a feature in GP. Some of them are new, others just underutilized. Ideally, I’d like to do this more than weekly but hey, I have a job.

Extreme Makeover, JE Edition

In version 8.0 Microsoft introduced Journal Entry corrections and copies. This is feature I’d been asking for for some time. I even came close to writing my own version several times. You now have the ability to undo a journal entry, easily, and with a complete audit trail.

In Transactions->Financial->General, select Correct. You now have an option to back out a Journal Entry or Back out a JE and create a correcting entry.

You will also need the JE number (you can look it up) and year of the entry you want to correct.

What happens behind the scenes when you backout an entry is that GP creates a duplicate, opposite JE with a new JE number to offset the one you want to correct. If all you need to do is undo an entry, simply post your correction and you’re done.

If you also select a correcting entry, the first entry created is the backout entry. When you post or save the backout entry, a second entry is created. This second entry is your original entry as a new, unposted JE that you can make changes to.

Both the backout and the correction are normal JE’s that can be save to a batch, changed, posted, made reversing, etc.

Some obvious uses:

  • That batch of month end accruals was accidentally posted in next month. Simply pull up the JE, do a correction to back it out of next month, and change the date on the correcting entry to the correct month. Post it all an you are in business.
  • The 150 line JE keyed incorrectly by an intern. Hopefully this was reviewed before posting, but if not, use this tool to backout the incorrect entry and make the intern fix the correcting entry (or re-key it, depending on how mad you are ;).

A related feature is to Copy a JE. Same process, just click copy instead of correct. This is great when you need to create a JE just like the one you did last month!
By default, Correction only works for transactions that originated in the General Ledger. However, the administrator can change this behavior.
Tools>Setup>Financial>General Ledger now has new check boxes to control this functionality. Check “Voiding/Correcting of Subsidiary Transactions” and “Back Out of Inter-company Transactions” to allow for corrections of transactions originating in a sub-ledger.
This a great feature, a critical feature, that the competition has had for a while. Now we’ve got it and I love it. But you have to be on v8.0 or better. This was one of the compelling features that pushed us to upgrade to 8.0. Detailed specifics can be found in GP Help. Happy Fixing!

Why are there so few Great Plains books?

Why are there so few GP books out there? An Amazon search turned up only a few old (pre-MS acquisition) or books not yet published. Many of the available offerings are weak too, spiral bound or college texts. Where is MS Press? Why no Great Plains for Dummies? How about a Great Plains Administrator’s guide?

I really don’t want to have to write one myself. That’s too much like work!

Search Amazon for “Great Plains” Accounting and see for yourself.

Search Now:
Amazon Logo

You Have to Start Somewhere

This is the start of my new Microsoft Dynamics GP (known aliases Great Plains Dynamics, eEnterprise, Microsoft Great Plains Standard and Pro) blog. I have some GP stuff on my website currently and I’m still figuring out how I’m going to incorporate that into the blog.

Currently, I’m the Controller for Transit Televsion Network, LLC. We used MS Great Plains 8.0 standard and are on the edge of needing the professional version. Prior to this role I was a consultant with epartners and Stanley Stuart Yoffee and Hendrix, two Great Plains resellers, for a total of about 4 years. I held all the basic GP certifications, Distribution, Financials, Integration Manager, etc. Prior to that I used Great Plains at Darden Restaurants.

I’ve been using GP since version 5.0 and have blogged about GP in my personal blog, but I wanted to separate my personal ramblings from my Great Plains halucinations.

Just to be clear, I don’t care about Axapta, Navision or Solomon. I have had a little exposure to Solomon and it’s nice, just different. But I don’t care, I use and know GP so that’s what I’ll focus on.

I hope you enjoy!

Terms

Terms of Use

AGREEMENT BETWEEN USER AND DynamicAccounting.net

The DynamicAccounting.net Web Site is comprised of various Web pages operated by DynamicAccounting.net.

The DynamicAccounting.net Web Site is offered to you conditioned on your acceptance without modification of the terms, conditions, and notices contained herein. Your use of the DynamicAccounting.net Web Site constitutes your agreement to all such terms, conditions, and notices.

MODIFICATION OF THESE TERMS OF USE

DynamicAccounting.net reserves the right to change the terms, conditions, and notices under which the DynamicAccounting.net Web Site is offered, including but not limited to the charges associated with the use of the DynamicAccounting.net Web Site.

LINKS TO THIRD PARTY SITES

The DynamicAccounting.net Web Site may contain links to other Web Sites (“Linked Sites”). The Linked Sites are not under the control of DynamicAccounting.net and DynamicAccounting.net is not responsible for the contents of any Linked Site, including without limitation any link contained in a Linked Site, or any changes or updates to a Linked Site. DynamicAccounting.net is not responsible for webcasting or any other form of transmission received from any Linked Site. DynamicAccounting.net is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement by DynamicAccounting.net of the site or any association with its operators.

NO UNLAWFUL OR PROHIBITED USE

As a condition of your use of the DynamicAccounting.net Web Site, you warrant to DynamicAccounting.net that you will not use the DynamicAccounting.net Web Site for any purpose that is unlawful or prohibited by these terms, conditions, and notices. You may not use the DynamicAccounting.net Web Site in any manner which could damage, disable, overburden, or impair the DynamicAccounting.net Web Site or interfere with any other party’s use and enjoyment of the DynamicAccounting.net Web Site. You may not obtain or attempt to obtain any materials or information through any means not intentionally made available or provided for through the DynamicAccounting.net Web Sites.

USE OF COMMUNICATION SERVICES

The DynamicAccounting.net Web Site may contain bulletin board services, chat areas, news groups, forums, communities, personal web pages, calendars, and/or other message or communication facilities designed to enable you to communicate with the public at large or with a group (collectively, “Communication Services”), you agree to use the Communication Services only to post, send and receive messages and material that are proper and related to the particular Communication Service. By way of example, and not as a limitation, you agree that when using a Communication Service, you will not:

* Defame, abuse, harass, stalk, threaten or otherwise violate the legal rights (such as rights of privacy and publicity) of others.

* Publish, post, upload, distribute or disseminate any inappropriate, profane, defamatory, infringing, obscene, indecent or unlawful topic, name, material or information.

* Upload files that contain software or other material protected by intellectual property laws (or by rights of privacy of publicity) unless you own or control the rights thereto or have received all necessary consents.

* Upload files that contain viruses, corrupted files, or any other similar software or programs that may damage the operation of another’s computer.

* Advertise or offer to sell or buy any goods or services for any business purpose, unless such Communication Service specifically allows such messages.

* Conduct or forward surveys, contests, pyramid schemes or chain letters.

* Download any file posted by another user of a Communication Service that you know, or reasonably should know, cannot be legally distributed in such manner.

* Falsify or delete any author attributions, legal or other proper notices or proprietary designations or labels of the origin or source of software or other material contained in a file that is uploaded.

* Restrict or inhibit any other user from using and enjoying the Communication Services.

* Violate any code of conduct or other guidelines which may be applicable for any particular Communication Service.

* Harvest or otherwise collect information about others, including e-mail addresses, without their consent.

* Violate any applicable laws or regulations.

DynamicAccounting.net has no obligation to monitor the Communication Services. However, DynamicAccounting.net reserves the right to review materials posted to a Communication Service and to remove any materials in its sole discretion. DynamicAccounting.net reserves the right to terminate your access to any or all of the Communication Services at any time without notice for any reason whatsoever.

DynamicAccounting.net reserves the right at all times to disclose any information as necessary to satisfy any applicable law, regulation, legal process or governmental request, or to edit, refuse to post or to remove any information or materials, in whole or in part, in DynamicAccounting.net’s sole discretion.

Always use caution when giving out any personally identifying information about yourself or your children in any Communication Service. DynamicAccounting.net does not control or endorse the content, messages or information found in any Communication Service and, therefore, DynamicAccounting.net specifically disclaims any liability with regard to the Communication Services and any actions resulting from your participation in any Communication Service. Managers and hosts are not authorized DynamicAccounting.net spokespersons, and their views do not necessarily reflect those of DynamicAccounting.net.

Materials uploaded to a Communication Service may be subject to posted limitations on usage, reproduction and/or dissemination. You are responsible for adhering to such limitations if you download the materials.

MATERIALS PROVIDED TO DynamicAccounting.net OR POSTED AT ANY DynamicAccounting.net WEB SITE

DynamicAccounting.net does not claim ownership of the materials you provide to DynamicAccounting.net (including feedback and suggestions) or post, upload, input or submit to any DynamicAccounting.net Web Site or its associated services (collectively “Submissions”). However, by posting, uploading, inputting, providing or submitting your Submission you are granting DynamicAccounting.net, its affiliated companies and necessary sublicensees permission to use your Submission in connection with the operation of their Internet businesses including, without limitation, the rights to: copy, distribute, transmit, publicly display, publicly perform, reproduce, edit, translate and reformat your Submission; and to publish your name in connection with your Submission.

No compensation will be paid with respect to the use of your Submission, as provided herein. DynamicAccounting.net is under no obligation to post or use any Submission you may provide and may remove any Submission at any time in DynamicAccounting.net’s sole discretion.

By posting, uploading, inputting, providing or submitting your Submission you warrant and represent that you own or otherwise control all of the rights to your Submission as described in this section including, without limitation, all the rights necessary for you to provide, post, upload, input or submit the Submissions.

LIABILITY DISCLAIMER

THE INFORMATION, SOFTWARE, PRODUCTS, AND SERVICES INCLUDED IN OR AVAILABLE THROUGH THE DynamicAccounting.net WEB SITE MAY INCLUDE INACCURACIES OR TYPOGRAPHICAL ERRORS. CHANGES ARE PERIODICALLY ADDED TO THE INFORMATION HEREIN. DynamicAccounting.net AND/OR ITS SUPPLIERS MAY MAKE IMPROVEMENTS AND/OR CHANGES IN THE DynamicAccounting.net WEB SITE AT ANY TIME. ADVICE RECEIVED VIA THE DynamicAccounting.net WEB SITE SHOULD NOT BE RELIED UPON FOR PERSONAL, MEDICAL, LEGAL OR FINANCIAL DECISIONS AND YOU SHOULD CONSULT AN APPROPRIATE PROFESSIONAL FOR SPECIFIC ADVICE TAILORED TO YOUR SITUATION.

DynamicAccounting.net AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY, RELIABILITY, AVAILABILITY, TIMELINESS, AND ACCURACY OF THE INFORMATION, SOFTWARE, PRODUCTS, SERVICES AND RELATED GRAPHICS CONTAINED ON THE DynamicAccounting.net WEB SITE FOR ANY PURPOSE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, ALL SUCH INFORMATION, SOFTWARE, PRODUCTS, SERVICES AND RELATED GRAPHICS ARE PROVIDED “AS IS” WITHOUT WARRANTY OR CONDITION OF ANY KIND. DynamicAccounting.net AND/OR ITS SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION, SOFTWARE, PRODUCTS, SERVICES AND RELATED GRAPHICS, INCLUDING ALL IMPLIED WARRANTIES OR CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT.

TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, IN NO EVENT SHALL DynamicAccounting.net AND/OR ITS SUPPLIERS BE LIABLE FOR ANY DIRECT, INDIRECT, PUNITIVE, INCIDENTAL, SPECIAL, CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF USE, DATA OR PROFITS, ARISING OUT OF OR IN ANY WAY CONNECTED WITH THE USE OR PERFORMANCE OF THE DynamicAccounting.net WEB SITE, WITH THE DELAY OR INABILITY TO USE THE DynamicAccounting.net WEB SITE OR RELATED SERVICES, THE PROVISION OF OR FAILURE TO PROVIDE SERVICES, OR FOR ANY INFORMATION, SOFTWARE, PRODUCTS, SERVICES AND RELATED GRAPHICS OBTAINED THROUGH THE DynamicAccounting.net WEB SITE, OR OTHERWISE ARISING OUT OF THE USE OF THE DynamicAccounting.net WEB SITE, WHETHER BASED ON CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY OR OTHERWISE, EVEN IF DynamicAccounting.net OR ANY OF ITS SUPPLIERS HAS BEEN ADVISED OF THE POSSIBILITY OF DAMAGES. BECAUSE SOME STATES/JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU. IF YOU ARE DISSATISFIED WITH ANY PORTION OF THE DynamicAccounting.net WEB SITE, OR WITH ANY OF THESE TERMS OF USE, YOUR SOLE AND EXCLUSIVE REMEDY IS TO DISCONTINUE USING THE DynamicAccounting.net WEB SITE.

SERVICE CONTACT : mpolino@gmail.com

TERMINATION/ACCESS RESTRICTION

DynamicAccounting.net reserves the right, in its sole discretion, to terminate your access to the DynamicAccounting.net Web Site and the related services or any portion thereof at any time, without notice. GENERAL To the maximum extent permitted by law, this agreement is governed by the laws of the State of Washington, U.S.A. and you hereby consent to the exclusive jurisdiction and venue of courts in King County, Washington, U.S.A. in all disputes arising out of or relating to the use of the DynamicAccounting.net Web Site. Use of the DynamicAccounting.net Web Site is unauthorized in any jurisdiction that does not give effect to all provisions of these terms and conditions, including without limitation this paragraph. You agree that no joint venture, partnership, employment, or agency relationship exists between you and DynamicAccounting.net as a result of this agreement or use of the DynamicAccounting.net Web Site. DynamicAccounting.net’s performance of this agreement is subject to existing laws and legal process, and nothing contained in this agreement is in derogation of DynamicAccounting.net’s right to comply with governmental, court and law enforcement requests or requirements relating to your use of the DynamicAccounting.net Web Site or information provided to or gathered by DynamicAccounting.net with respect to such use. If any part of this agreement is determined to be invalid or unenforceable pursuant to applicable law including, but not limited to, the warranty disclaimers and liability limitations set forth above, then the invalid or unenforceable provision will be deemed superseded by a valid, enforceable provision that most closely matches the intent of the original provision and the remainder of the agreement shall continue in effect. Unless otherwise specified herein, this agreement constitutes the entire agreement between the user and DynamicAccounting.net with respect to the DynamicAccounting.net Web Site and it supersedes all prior or contemporaneous communications and proposals, whether electronic, oral or written, between the user and DynamicAccounting.net with respect to the DynamicAccounting.net Web Site. A printed version of this agreement and of any notice given in electronic form shall be admissible in judicial or administrative proceedings based upon or relating to this agreement to the same extent an d subject to the same conditions as other business documents and records originally generated and maintained in printed form. It is the express wish to the parties that this agreement and all related documents be drawn up in English.

COPYRIGHT AND TRADEMARK NOTICES:

All contents of the DynamicAccounting.net Web Site are: Copyright 2005-2011 Mark D. Polino, CPA and/or its suppliers. All rights reserved.

TRADEMARKS

The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

The example companies, organizations, products, people and events depicted herein are fictitious. No association with any real company, organization, product, person, or event is intended or should be inferred.

Any rights not expressly granted herein are reserved.

NOTICES AND PROCEDURE FOR MAKING CLAIMS OF COPYRIGHT INFRINGEMENT

Pursuant to Title 17, United States Code, Section 512(c)(2), notifications of claimed copyright infringement under United States copyright law should be sent to Service Provider’s Designated Agent. ALL INQUIRIES NOT RELEVANT TO THE FOLLOWING PROCEDURE WILL RECEIVE NO RESPONSE. See Notice and Procedure for Making Claims of Copyright Infringement.

FTC DISCLOSURE
While most of the items on DynamicAccounting.net are free, we reserve the right to make a living. We accept paid ads and we sell some products. We reserve the right to make money on the website in other ways.

Privacy Policy

DynamicAccounting.net is committed to protecting your privacy and developing technology that gives you the most powerful and safe online experience. This Statement of Privacy applies to the DynamicAccounting.net Web site and governs data collection and usage. By using the DynamicAccounting.net website, you consent to the data practices described in this statement.

Collection of your Personal Information

DynamicAccounting.net collects anonymous demographic information which is not unique to you such as information about your computer hardware and software/ This information can include: your IP address, browser type, domain names, access times and referring Web site addresses. This information is used by DynamicAccounting.net for the operation of the service, to maintain quality of the service, and to provide general statistics regarding use of the DynamicAccounting.net Web site.

Please keep in mind that if you directly disclose personally identifiable information or personally sensitive data through DynamicAccounting.net public comments, this information may be collected and used by others. Note: DynamicAccounting.net does not read any of your private online communications.

DynamicAccounting.net encourages you to review the privacy statements of Web sites you choose to link to from DynamicAccounting.net so that you can understand how those Web sites collect, use and share your information. DynamicAccounting.net is not responsible for the privacy statements or other content on Web sites outside of the DynamicAccounting.net and DynamicAccounting.net family of Web sites.

Use of your Personal Information

DynamicAccounting.net may collect and use your personal information to operate the DynamicAccounting.net Web site and deliver the services you have requested. DynamicAccounting.net also uses your personally identifiable information to inform you of other products or services available from DynamicAccounting.net and its affiliates. DynamicAccounting.net may also contact you via surveys to conduct research about your opinion of current services or of potential new services that may be offered.

DynamicAccounting.net may sell, rent or lease its customer lists to third parties.

DynamicAccounting.net does not use or disclose sensitive personal information, such as race, religion, or political affiliations.

DynamicAccounting.net keeps track of the Web sites and pages our customers visit within DynamicAccounting.net, in order to determine what DynamicAccounting.net services are the most popular. This data is used to deliver customized content and advertising within DynamicAccounting.net to customers whose behavior indicates that they are interested in a particular subject area.

DynamicAccounting.net Web sites will disclose your personal information, without notice, if required to do so by law or in the good faith belief that such action is necessary to: (a) conform to the edicts of the law or comply with legal process served on DynamicAccounting.net or the site; (b) protect and defend the rights or property of DynamicAccounting.net; and, (c) act under exigent circumstances to protect the personal safety of users of DynamicAccounting.net, or the public.

Use of Cookies

The DynamicAccounting.net Web site may use “cookies” to help you personalize your online experience. A cookie is a text file that is placed on your hard disk by a Web page server. Cookies cannot be used to run programs or deliver viruses to your computer. Cookies are uniquely assigned to you, and can only be read by a web server in the domain that issued the cookie to you.

One of the primary purposes of cookies is to provide a convenience feature to save you time. The purpose of a cookie is to tell the Web server that you have returned to a specific page. For example, if you personalize DynamicAccounting.net pages, or register with DynamicAccounting.net site or services, a cookie helps DynamicAccounting.net to recall your specific information on subsequent visits. This simplifies the process of recording your personal information, such as billing addresses, shipping addresses, and so on. When you return to the same DynamicAccounting.net Web site, the information you previously provided can be retrieved, so you can easily use the DynamicAccounting.net features that you customized.

You have the ability to accept or decline cookies. Most Web browsers automatically accept cookies, but you can usually modify your browser setting to decline cookies if you prefer. If you choose to decline cookies, you may not be able to fully experience the interactive features of the DynamicAccounting.net services or Web sites you visit.

Security of your Personal Information

DynamicAccounting.net secures your personal information from unauthorized access, use or disclosure. DynamicAccounting.net secures the personally identifiable information you provide on computer servers in a controlled, secure environment, protected from unauthorized access, use or disclosure. When personal information (such as a credit card number) is transmitted to other Web sites, it is protected through the use of encryption, such as the Secure Socket Layer (SSL) protocol.

Changes to this Statement

DynamicAccounting.net will occasionally update this Statement of Privacy to reflect company and customer feedback. DynamicAccounting.net encourages you to periodically review this Statement to be informed of how DynamicAccounting.net is protecting your information.



Contact Information

DynamicAccounting.net welcomes your comments regarding this Statement of Privacy. If you believe that DynamicAccounting.net has not adhered to this Statement, please contact DynamicAccounting.net at mpolino@gmail.com. We will use commercially reasonable efforts to promptly determine and remedy the problem.