Software Information |
|
Microsoft Great Plains Multicurrency ? Overview For Implementation Consultant
When you first think about multicurrency ? you probably have in mind the revaluation question. Currency triangulation ? which was the need when European currencies were fixed to Euro is not an issue any more. 1. Sales and Purchasing multicurrency ? when you are selecting accounting package with multicurrency, you need first understand if it has multicurrency on the Sales and Purchasing modules level, not just in GL. The problem behind is like this. When you have sales in foreign currency ? you will probably get the payment later on when currency may potentially lose some value against your functional currency (like US Dollar or Euro ? however in our days Dollar is very good candidate to do so, but this is outside of the scope). Then ? even if you do have payments upfront in foreign currency ? you probably don't plan to convert this currency to functional for repatriation, you probably keep it in the local bank and so your foreign money is subject to fluctuation in comparison to functional currency 2. Unrealized and Realized Gains and Losses ? gain or loss is unrealized when transaction is not yet settled (like payment is not received and not applied ? but you would already like to know if you have unrealized gain or loss). When transaction is settled ? then realized gain or loss might be in place ? this is simply the difference of what if you would get immediate payment and got payment now. 3. Revaluation ? this is when you decide to recalculate your Sales, Purchasing transaction and post realized and unrealized gains or losses. As the result you usually want GL transaction to be created 4. GL Multicurrency ? is simplified version. You may have transactions entered directly in GL with foreign currency selected ? in this case it is subject for possible revaluation. 5. Microsoft Great Plains Multicurrency ? it is on the level of the following modules: GL, Accounts Receivable, Accounts Payable, Sales Order Processing, Purchase Order Processing, Bank Reconciliation, Project Accounting. So it is full-featured multicurrency. Happy implementing! if you want us to do the job - give us a call 1-630-961-5918 or 1-866-528-0577! [email protected] Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Continental Europe, Russia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Microsoft Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
|
RELATED ARTICLES
Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer Microsoft Business Solutions Great Plains is written in Great Plains Software programming tool: Great Plains Dexterity. Dexterity in turn was built with conception of graphical cross-platform transferability (in time ? 1992 ? mostly Mac and MS Windows). Plus Dexterity had database abstraction level (through C programming language). The result of such a shrewd future-looking architecture ? Great Plains ReportWriter has multiple restrictions and drawbacks. Microsoft Great Plains Nationwide Remote Support ERP Consulting industry is on the way to serve clients nationwide and even worldwide, when the client is multinational corporation. There are several reasons to specialize in remote support. In this small article we'll give you these reasons and the advantages of remote installation, customization, integration, programming, reporting. Microsoft Great Plains eCommerce ? Stored Procedures Approach Since Version 8.0 Microsoft Business Solutions Great Plains & Great Plains Standard are available on Microsoft SQL Server and MSDE (which is in fact MS SQL with database size limit of 2GB). As eCommerce designer you should be aware of several options and customization tools in your disposition, when you utilize Microsoft Great Plains 8.5 (June 2005), 8.0, 7.5, Great Plains Dynamics/eEnterprise 7.0, 6.0, 5.5 or 5.0 Great Plains Dynamics C/S+. When you have old versions (7.5 and prior) we assume that you are on MS SQL Server 2000/7.0, because if you are on Ctree or Pervasive SQL/Btrieve ? you should use ODBC / RDO connection tools, such as MS Access and its queries or use MS SQL Server Linked Server technique with OPENROWSET statements. So, lets assume that you are on MS SQL Server. You have basically two options eConnect (you should pay for the reg key/license and this is SDK) and custom stored procedures. We'll only consider custom stored procedures way here: The Bluebird Project The objective for Zandi Digital is to make available clever programs to end-users that want and need something more diverse. Bluebird is the current application being developed by Zandi Digital. Bluebird will have the ability to compress multimedia(image, audio, or video) and text into one single file and later opened for reading or editing with Bluebird on Microsoft Windows� operating systems. A illustration is at http://www.videonotepad.net Should I Use Windows Update? Should one use Windows Update? Alien Intruders! You probably didn't casually invite, or extend a formal attendance request to, these undesirables known as viruses. Microsoft Blues With the advent of 'Service Pack 2' for Windows XP operating system, Microsoft have really made the forums hum. Unofficial Windows 98 SE Service Pack 2.0 RC2 Microsoft has never released a service pack for Windows98 SE, but I made a Service Pack for Windows98 SE users. Cross-Platform Custom Software Development & Integration ? IT Strategy for Large Corporation Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta, MS RMS integration with UNIX/Java based platforms & non-Microsoft applications: Oracle, Lotus Notes/Domino, DBII, PeopleSoft, SAP Free Software for Newbies and Web Developers Here is some free software tools to help you build your own websites and create web products. How to Upgrade Dexterity Customization ? Tips for IT Manager If you have Microsoft Great Plains and support it for your company and have light or heavy Great Plains customization, written in Dexterity ? you need to know your options in upgrading Great Plains or migrating it from ctree/Pervasive to MS SQL/MSDE. Great Plains Dexterity is proprietary programming language/environment, which was created in early 1990-th to provide platform / database / graphical interface independence for Mac and Windows based Great Plains Dynamics.� Today it is legacy and Microsoft Business Solutions is phasing Dexterity out. However Great Plains 7.5 and even 8.0 is Dexterity based application, so you have to deal with it and it's customization. � Good news.� Prior to version 7.0 Great Plains had plans on expanding GP functionality and so was changing tables structure ? forcing Dexterity customization to be analyzed and partially rewritten with each upgrade.� Not any more ? GP structure stays the same ? Microsoft is doing new modules acquisition and unifying it's graphical interface to move all it's ERP packages: Great Plains, Solomon, Navision and Axapta to web-based Microsoft Business Portal. � Still pain.� Dexterity has possibility to customize existing Great Plains screens, so called Alternative Great Plains forms.� This was upgrade problem in the past and it stays now ? there is no way to do it in house (until you are willing to pay for full-time internal developer ? who is usually in the learning curve).� You got to bring in consultant. Recommended approach.� You should have the strategy to migrate Dexterity customization to SQL, Crystal Reports, custom web publishing ? Visual Studio.net and slowly abandon Dexterity customization SQL Stored procedures - performance improvement.� Consider replacing dexterity data manipulation with SQL stored procedures.� Dexterity is cursor-driven language and it is not efficient when processing huge datasets. Crystal Reports.� Take advantage of open and leading technology.� Crystal Reports will eliminate the need in the future for painstaking Dexterity reports upgrade.� Base you Crystal report on the SQL view or stored proc Do direct web publishing off your GP database.� Use Visual Studio ? it is easy to find specialists and have them in staff.� We are in the World when web publishing is very easy. Good luck and if you have issues or concerns ? we are here to help! if you want us to do the job - give us a call 1-866-528-0577! [email protected] Microsoft Great Plains e-Commerce ? additional considerations for programmer Microsoft Great Plains, designed back in 1990th as database transferable and graphical platform independent ERP application ? Great Plains Dynamics/Dynamics C/S+/eEnterprise. For eCommerce developer the most important is to understand Great Plains tables structure and business processes in Sales Order Processing, Accounts Receivables, Inventory Control (inventory items allocation, backordering, etc), posting to Bank Reconciliation and General Ledger. And this is where Great Plains structure seems to be not transparent. Let's give you highlights: Software Automation Helps Increase your Bottom Line When you own a small business, time is money. And every time a task that should be automated is handled manually, it wastes your time and your business loses money. To make matters even worse, performing these tasks manually, in front of clients or prospects, projects the wrong image. Bill of Lading ? Custom Reporting for Microsoft Great Plains ? Overview for Consultant Bill of Lading is required report for Logistics and Freight Forwarding companies. If you are looking at Freight Forwarding software, targeted to automate transportation business ? Bill of Lading with multiple custom forms should be present there. However if you need the extension to standard ERP/Accounting application ? you may be looking at the option to customize the system. Microsoft Business Solutions Great Plains might be considered as ERP platform, ready for customization. Let us give you customization highlights. How To Identify, Cure and Prevent Spyware/Adware Infections Just when you thought you were Web savvy, one more privacy, security, and functionality issue crops up - spyware. Installed on your computer without your consent, spyware software monitors or controls your computer use. It may be used to send you pop-up ads, redirect your computer to websites, monitor your Internet surfing, or record your keystrokes, which, in turn, could lead to identity theft. Microsoft RMS Customization ? PO Items Receiving in Great Plains Microsoft Retail Management (RMS) and Microsoft Great Plains are retail and accounting/ERP solutions coming from the same Microsoft subdivision ? Microsoft Business Solutions. There is often common need to do integration between the two. Despite the fact that both systems come from the same software development company ? the integration is not as simple as it probably should be. What is Software Piracy? There are several kinds of software piracy. The bottom line is when software is pirated, the developer does not receive compensation for their work. The Religion And Philosophy Of Small Internet Business I have always had a tendency to focus on the positive. We, all of us, know the negative details in society and governments. So why not focus on solutions? Most self-actualized grownups even solve problems in this manner. Chances are we'll always have the mammoth corporations. Large corporations have their good and bad points. Click? Want to strike back at the aristocracy? Develop and advertise a business website. And it does not matter what country you are from either. Advertise your specialty 24-7-12. Microsoft Great Plains Middle East - Arabic Language Support Microsoft Business Solutions Great Plains is marketed for mid-size companies in North America, Europe, Asia Pacific, as well as in Middle East. Causes of ERP Failures ERP is the acronym of Enterprise Resource Planning. Multi-module ERP software integrates business activities across various functional departments, from product planning, parts purchasing, inventory control, product distribution, to order tracking. ERP has transformed the way multi-billion dollar corporations conduct their businesses. Successful implementation of ERP systems could save tens of millions of dollars and increase employee satisfactions, customer satisfactions and sustain competitive advantages in every-changing marketplace. Corporate executives are often perplexed by the stories that how reputable corporations (Hershey Foods, etc.) have failed miserably and lost ten of millions of dollars in their ERP endures. |
home | site map |
© 2005 |