Dynamics GP Reports Design Notes | ArticlesBase.com

<p>If you are in reports design tools for Microsoft Dynamics GP (formerly this ERP application was known as Great Plains Dynamics and eEnterprise, please do know that older Great Plains Accounting for Dos, Windows and Macintosh is different from Great Plains Dynamics GP and is out of scope in this publication), we would like to give you small orientation article.  We will start with reports classification, then cover GP associated tools and then generic reporting tools:</p> <p>1. Report classification.  This first small step can save you a lot of time and potentially rework efforts.  Please, try to think about your report and in which category it fits: financial report, business logic specific (often referred as managerial reporting), other than pure financial (it is Sales, Purchasing, Project Performance and Timeline, Employee Per Plant, Manufacturing Budgets, etc), or if it is Business Form (Sales Invoice, Customer Statement, Purchase Order, Project Card, Picking Ticket, Bill of Lading), or if it is international reporting (when you have to design Great Plains reports in your country native language)</p> <p>2. Financial Reporting.  If in the first paragraph you decided to classify your report as Financials, likely that you will have to deal with Balance Sheet, P&amp;L, Statement of Cash Flow, GL Trial Balance, or consolidated version of the reports mentioned above.  If this is the case, tool selection is simple - review FRx Financial Reporting, and if you are on Small Business Financials, review GP Advanced Financial Analysis Reporting (AFA is in our opinion less powerful and has more restrictions and requires more learning time, comparing to FRx, however it comes free with your Small Business Financials licenses).  FRx deals with GL Accounts, Budgets, it has direct link to Account Summaries table and allows you to combine Dynamics GP GL data with external Excel Worksheets (in the case, when you have smaller or international subsidiaries in Small Business Accounting packages, or something like SAP Business One, where BS, P&amp;L export to Excel is very simple).  Consolidated reports, here you work with Reporting Tree, and you could slice and dice your reporting tree based report by Tree Unit, which might be account segment or separate company</p> <p>3. Managerial Reporting.  Here, you know that FRx is not the right tool.  Now, sensational news - probably this reporting tool you like the most - yes, Crystal Reports!  CR can do fabulous job in Dynamics GP reporting.  When you are back from excitement to the working routine, please note our recommendations, coming from multiple cases of records duplication in CR - try to separate reports SQL Selection side from CR design itself.  We recommend you to create report SQL base as SQL View or Stored Procedure.   In Stored Procedure you have the most of the flexibility, as here you can deploy intermediate steps, such as temporary tables (this is not possible in SQL View).  Plus, in our opinion, you can have similar to CR power in Microsoft SQL Server Reporting Services (SSRS) and even in MS Office reporting extensions: Excel, MS Access Reports, Microsoft Word Reports, however these topics are out of the scope</p> <p>4. Business Forms.  If all you need to do is to place logo on Sales Invoice, then turn your attention to GP Modified Reports and Report Writer.  RW is Dynamics GP Dexterity based module, meaning that you can call RW modified reports directly from Batch or individual Sales Invoice, Order, or Quote window.  ReportWriter is limited to Dexterity indexing, and in some complex Forms printing cases you may decide on switching to Crystal Reports or SSRS (where you base your report on real SQL Select statement)</p> <p>5. International Dynamics GP Reporting.  If your business subsidiary is located in the country, where the language is ASCII compliant: English Speaking Countries, such as Australia, New Zealand, South Africa, UK; Europe: France, Belgium, Netherlands, Germany, Denmark, Norway, Poland, Lithuania, Latvia, Estonia, Czech Republic, Slovakia, Serbia, Slovenia, Croatia, Russia, Ukraine, Belarus, Italy, Greece, Turkey, Arabic Speaking countries: Saudi Arabia, Egypt, Syria, Jordan, Algeria, Libya, Tunisia, you can deploy GP Dexterity Reporting.  If you are in the country where Unicode characters are required: China, Korea, Thailand, Japan - please consider deploying Crystal Reports, SSRS</p> <p>6. International Consolidated Reporting, SAP B1 considerations.  If you have subsidiaries located in such countries as Brazil, Chile, Argentina, Colombia, Costa Rica, Europe, Philippines, India, China, where SAP Business One ERP and MRP is very popular and it is localized and certified by Government Tax Agencies, please consider combining your FRx reports with Excel export from your SAP B1 overseas subsidiaries</p> <p>7. How to get help?  Please, feel free to call us: 1-866-528-0577, <a href="mailto:help@albaspectrum.com" rel="nofollow">help@albaspectrum.com</a></p><strong>About the Author:</strong><br /><p>Andrew Karasev, Alba Spectrum, <a href="mailto:help@albaspectrum.com" rel="nofollow">help@albaspectrum.com</a> 1-866-528-0577, <a target="_blank" href="http://www.albaspectrum.com" rel="nofollow">http://www.albaspectrum.com</a> Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: <a target="_blank" href="http://www.pegasplanet.com" rel="nofollow">http://www.pegasplanet.com</a> We serve you USA and Canada nationwide from our Dynamics GP call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Central America
</p>

Detoxify Your Body For Good Health

<p>Are you having a difficult time going to the bathroom? When was the last time that you actually had a bowel movement? If the answer to this question is a few days, you may need to detoxify your colon. Over the years our colons have become polluted from the foods we have eaten. It is a smart choice to rid our bodies of the things that are stored in our colons. Simply put, we have become what we have eaten. It is crucial to clean our colons on a consistent basis, in order to be in the best shape possible. This article will list 2 features any good colon cleanser should contain.</p><p>Probiotics are your friends
<br>Factors such as working long hours, studying for exams, trying a new eating regimen and other taxing activities can result in the disturbance of our digestive process. If your body is feeling like it needs an extra boost, you should consider adding "nice" bacteria called probiotics to your life to help detoxify your colon. This type of bacteria aids in your digestion, and will cause you to go to the bathroom on a normal basis. It is especially important to take probiotics when you are taking medications because these good bacteria will help you to fight any potential side effects that the medicine may have.</p><p>Get rid of the parasites
<br>A good colon cleanser will also help you to eliminate the parasites that may be making their home in your body. These parasites may be eating away at you, and causing you to be unhealthy. They can attack the intestines and must be stopped at all costs. The bad news is that much of the population of the world has parasites. They can be found in human feces, and come in over 900 different varieties. Using a product that cleanses your colon and detoxifies your body can get rid of the ones that even your medical practitioner will not find.</p><p>In short, cleaning our colons is a great practice. A good way to clean our colons is to use a product that contains probiotics, and attacks those terrible things called parasites in our bodies. Taking an active interest in our health will help us to feel better, look better and be better members of the human race.</p><p>If you would like to try one of the best methods to detoxify your colon on the market, go to <a target="_new" href="http://detoxify-your-body-now.com" rel="nofollow">http://detoxify-your-body-now.com</a> This product has the essential ingredients you need to rid yourself of parasites, achieve optimal health and dispose of all the refuse that has made its home in our bodies over a period of years. I am Richard Holzhauer.Would you like to know more? For more information, go to: <a target="_new" href="http://detoxify-your-body-now.com" rel="nofollow">http://detoxify-your-body-now.com</a></p>

Create Your Own Forum Using VBulletin or PhpBB3

vBulletin is the most popular and most frequented online message board systems. One of the best marketing tools you could launch along with your site is an active online community. A message board system allows members to create topics and reply to other members' post. You can find message boards for every niche possible.
<br>
<br>10 Easy Steps – How To Set up a Forum in vBulletin
<br>The following ten steps will walk you through the basics of setting up a vBulletin forum. vBulletin offers online and phone technical support. They offer two licensing structures – leased or owned. Check out vBulletin for pricing options.
<br>
<br>You will need to purchase your license and download the software before you begin creating your forum. You also need a username and password before you can log into the Admin Control Panel.
<br>
<br>1. Using your website browser, log into the "Admin Control Panel" on vBulletin website.
<br>
<br>2. Click "Forums and Moderators" link (found on the left-hand Control Panel)
<br>
<br>3. Pull down drop-down menu and choose "Add New Forum"
<br>
<br>4. Fill out all required information in "Add New Forum" section.
<br>
<br>5. You have the option to choose the following features: moderation, style, access and posting options. You can enable or disable custom features.
<br>
<br>6. If information is correct, click "Save" button.
<br>
<br>7. Go into Control Panel menu – under "Forums and Moderators" choose "Forum Permissions." Click on "Quick Forum Permissions Setup" at top of list.
<br>
<br>8.Choose newly created forum from list and select usergroups (people who have permission to access your forum).
<br>
<br>9. Add Custom Permissions by choosing either "Yes or No" in Forum viewing, forum searching, post/thread, attachment and poll permissions (sections located on bottom of page)
<br>
<br>10. Make sure your permissions are set up properly - click the "Save" button.
<br>
<br>How To Create a phpBB3 Forum
<br>PhpBB3 is one of the most popular Open Source (free), bulletin board systems used across the world. phpBB3 offers "real time" technical support via their website and offers assistance for non-native English speakers.
<br>
<br>• Read phpBB's Quick Start Guide which breaks down each section step-by-step, and walks you through installation and forum configurations.
<br>
<br>• Pay close attention to the "Requirements" and "Installation" sections. Make sure your server supports PHP language before you install the file.
<br>
<br>• Click on "Downloads" and unzip the latest version of phpBB3. Use a FTP program to upload to server.
<br>
<br>• After you install the software, you will be directed to "Administration Control Panel" (the link is also found on the bottom of the page). This is where you configure your basic settings. Refer to "General Settings" under Quick Start Guide. Set up "Board Features" and "Board Settings" under "General Settings."
<br>
<br>• After you install the software, you will be directed to "Administration Control Panel" (the link is also found on the bottom of the page). This is where you configure your basic settings. Refer to "General Settings" under Quick Start Guide. Set up "Board Features" and "Board Settings" under "General Settings."
<br>
<br>• At the top of "Administration Control Panel" click on "Forums" tab. Click on "Create New Forum" on right side of page. Type in the desired name of the forum you want to create (in the textbox). For more in-depth instructions, follow steps in "Creating and Setting up Forums" in "Quick Start Guide."
<br>
<br>• Setting permissions – Allows you to choose the following criteria
<br>
<br>oGlobal – User/group, moderator or administrator permission (manages forums and bans users)
<br>
<br>oLocal – Moderator or forum permissions (lock topics and allows who sees forum or post topics)
<br>
<br>About the Author: Zeke Camusio is a serial entrepreneur, Internet Marketing expert and founder of The Outsourcing Company, an Internet marketing agency with offices in Aspen, CO and New York. Let's Do It!, Zeke's Internet marketing blog, has thousands of followers from all over the world. Check it out at <a href="http://www.TheOutsourcingcompany.com/blog" rel="nofollow">www.TheOutsourcingCompany.com/blog</a>
<br>