ERP System Finance Modules

Posts Tagged ‘Plains’

Dynamics GP Partner Newsflash: Great Plains licenses and implementation

p

Dynamics GP Licensing for new customers GP Business Ready Licensing can for two levels: .. Business (mid-size. Small businesses or corporations that require a standard feature of ERP and MRP) and advanced management (for large organizations or companies, demanding greater functionality) The format of this publication registration modules, but give the idea – if you need manufacturing, field service or human resource management function modules – should review the proposals and consider the purchase of Dynamics GP Advanced Management Enterprise Ready, set,

Wed two Great Plains installation, data conversion. Publication of user training and advance to production if you are in the small business or a legacy ERP or accounting system. QuickBooks, MAS 90, Peach Tree, ACCPAC, Oracle Financials, Sage, Great Plains Accounting for DOS or Windows, JD Edwards, PeopleSoft, and if you upgrade or move away from Microsoft Dynamics GP Great Plains, we want policy recommendations. As you are in Quick Books, the migration tool is available, should plan to migrate their accounts, customers, suppliers, AR and AP invoices for sales and purchase transactions. The same is true if you are on GPA for DOS (if the migration tool has been proven over the years and is doing almost all objects of the transfer.) For the rest of you, we recommend that current exports chart of accounts, customers, suppliers and sales to start the period, the import of these items to Great Plains Dynamics GP and start the new year or a period of years (months, example). I really do not advise you to take into account the migration of historical data until it is absolutely necessary -.. instead you can keep your legacy ERP system available for research and reporting only

Book sales report: Great Plains Dynamics GP sample reports

If you are responsible for processing or assembly numbers back to the General Ledger newspaper sales, then you can have a place where you see your monthly or quarterly sales Ledger in the general ledger distribution. In addition, we heard the representations of corporate accounting and Dynamics GP functional consultants that this relationship is often difficult, even tried to be designed or Dynamics GP FRx Report Writer (assuming it does not take the route of the Great Plains Customization Dexterity). In this book, we would like advice on how to design the report in Crystal Reports:

1. Logic reports. This report should summarize all the various streams of receivables (with the statements, taken as negative samples), but only for transactions with SJ and RMJ types: the sense that the sales invoices for processing orders, statements module and managing accounts receivable invoices, credit notes. This summary of AR flow should not include the payments. Now for the credit, you must examine all accounts related to sales, sale, transportation, miscellaneous expenses, sales tax payable, tax payable

2. Under the hood. We assume that found in Microsoft SQL Server 2005 or 2000 as the database platform and SQL queries you as a SQL stored procedure and the basis of sales journal report SQL stored procedure, which provide the parameters Date and Date fields. ideal life is very attractive, but in real life is a number of changes to documents and distribution of SOPs RM. Therefore we recommend that generates SQL Select a list of all accounts, participation in the sales invoices and income distribution. Can be reached from the GL20000 table, again, restrictions on the type of record: SJ and RMJ. account numbers and names should be interviewed in the table GL00100 – Account Master

3. Newspaper Sales Audit Operations. Include details declaration Select the body section of the report with the option to hide the deepening OK. If you examine the GL20000 table structure, you will notice that includes the customer ID field in ORMSTRID, ODMSTRNM customer name and sales invoice or a callback number in the field ORDOCNUM

4. Let us know. The above should give you very good start. If you feel that you are really Dynamics GP technical consultant or Crystal Reports Developer, please call or email us

Microsoft Great Plains changes? Implementation and Integration Overview More Options

Each system must be considered as ERP platform that could adapt to your company’s business processes through custom programming, integration, information, and modification of existing logic. Microsoft Dynamics GP is no exception and in this short article you would like to come by disturbances such scenarios GP

1. Great Plains Dexterity. It is Integrated Development Environment or IDE with its own programming language Sanskrit. Dexterity was designed specifically for Great Plains Dynamics in earlier 1990th and is one reason why DEX is a bit “old fashioned” and if you’re a programmer, do not expect to enter the skill overnight. If you are considering the establishment of the extension of Medicine for the free market, then you should know that most extensions are written in Microsoft Dexterity. To understand the inner face of Dex, please take a look at the file Dynamics.set, where all products are listed. You start by opening the project Des DYNAMICS.DIC dictionary and the addition or modification of resources within it, forms, reports, screens, fields, scripts, etc. Some tips Dex – a copy of your workstation to your GP Dex.ini skill application directory – this allows you to run in the mode of Dex. Since version 7.0 of Dex can call Microsoft COM objects.

2. eConnect. This tool gives access to GP work operations (SOP Invoice, POP Purchase Order, GL registration, depreciation of the FA to name a few) and results (customers, suppliers, employees, property, general account). EConnect was initially designed for eCommerce developers by opening up sales orders, inventory and accounts receivable management modules, but later spread to most of the objects of general protection. You can call from your eConnect for Microsoft Visual Studio C # or VB.Net projects, the internal logic of eConnect (Business Objects) is written in MS SQL Server stored procedures encrypted />
3. VBA / Edit. If you are comfortable with VBA scripts (remember MS Excel changes?) You can add logic to existing GP windows, such as SOP Entry screen, where you can make new Edit button, and then join VBA script for this domain. If you intend to hit the database Medicine, the Edit and add the field, you must implement ADO technology, which most likely is to encode the user ID and password. Edit allows you to include Sanskrit scriplets GP skill in the VBA code - which allows you to use technology to Continuum for VBA modules pass GP and skill to manipulate objects in multi-workstation GP module, but this technique is very complex and usually expensive version upgrade />

4. SQL script. One of the most popular routines, which are implemented SQL stored procedures is the electronic exchange of documents or EDI. EDI head, body and trailer and to implement these constructs SQL CAST CONVERT to handle fixed-length fields implementing EDI />
5. GP integration. Microsoft Dynamics GP Integration Manager should be considered in the first place – it is possible to extend instant messaging with VBA scripting and translation table fields (you can create a translation table in Excel and then import it into Integration Manager .) If IM does not work, consider scripting eConnect, SQL and skill. Note – GI valid business logic physician and stops you all errors in integration. SQL scripts in front GP does not validate the logic and not do – that can compromise data integrity

6. Changing update. Of course you should expect some complications in the updated version if you implement the development of technologies GP GP. In the case of Great Plains Software alternative logical skill, you should keep or change Extract.dic DYNAMICS.DIC with scripts for them – Dex developer should be able to update your custom logic. Modifier with VBA talk – if no tricks modules deployed continuous change, the upgrade should be simple. IM is the trial version of GP. To give other considerations update – Great Plains 7.5 and earlier versions: 7.0, 6.0, 5.5, 5.0, 4.0 and 3.2 have been available on platform DB Alternative: Btrieve (later in this database has changed its name to Pervasive SQL Server), Ctree / FairCom, and, respectively, if in these platforms, changing the logic could deploy programming constructs, such specific DB platform only – if you plan to go to CU recent version (10.0 or 9.0) – which must go through the custom logic migration to Microsoft SQL Server 2005 and 2000

7. GP reporting tools. ReportWriter is Dexterity module and is perfectly integrated in the workstation interface and security model GP GP. The reports are stored in the recorder Reports.dic. RW is often used when it is necessary to modify the GP reports: SOP Long Invoice form (put your company logo is a classic example). Crystal Reports – good design should consider the report to record discharge report provided to create the stored procedure view MS SQL Server or SQL. SRS or Microsoft SQL Server Reporting Services – in our opinion, this tool is a competitor of risk capital should consider using the same strategy – to put the logic of selection of records available to SQL stored procs. You can deploy MS Excel and MS Access to make a statement to GP – please search options ODBC connections for these tools

8. GP licensing examination modules. Depending on the version of GP – GP standard professional or a business loan, you should be aware that custom modules may require additional purchases, please contact your Microsoft Business Solutions or MBS partner

ISV
9. Review data conversion. If you change your legacy MRP, such as ACCPAC, MYOB, PeopleSoft, Oracle E-Business Suite / Finance / Applications, JD Edwards, QuickBooks, Peachtree, MAS GP 90/2000, data migration and massage may be necessary. We recommend keeping the legacy accounting system to investigate and search the data and not historical data from the Great Plains ERP conversion. However, if the migration of historical transactions is necessary, please contact us for data cleaning /> <

Great Plains Accounting for DOS and Windows export Notes data
If you still

GPA for DOS or Windows, versions 9.5, 9.2, 9.1 and earlier versions of your business as customer orders ERP, MRP, inventory control, order processing and accounting application, to offer this small publication, where data is collected on the export of our experience of PAM. If you are on obsolete platforms such as Windows NT, Novell, Windows 95 (as a user workstation ACP), please know that there is a technology that allows you to implement Great Plains on Pervasive SQL Accounting 2000 and the new Windows Server 2003 and redeployed DOS user interface in Windows XP – but this topic is beyond the scope of this publication, please call us if you need this service. PAM to start the export of data work:

in the selection criteria or simply type in each field to select all customers, click the print screen> or export file, mark titles, legends, headers, footers, and print all its customers. If you print the file, you must be able to import Excel data massage and for use as source of the company’s new ERP data conversion (if you migrate to Microsoft Dynamics GP 10.0, 9.0, 8.0, 7.5, you do not have to do such as Great Plains Dynamics GPA migration tool, simply call your member of Great Plains for more details) to Oracle Financials / Applications / E-Commerce Suite, ACCPAC, QuickBooks, Lawson, Epicor, Navision, Axapta, SAP Business One etc. Now, the AR historical records, simply select the transaction history report

3. Establishment of MPAs ODBC driver. Then, create DDF files, as required by Pervasive SQL and Btrieve its predecessor. Please enter the CD of PAM and go to the Documents section of Btrieve. This is the quotation from Manuel ODBC2000NT: Installing data definition files (DDFS) Install the data definition files (DDFS) for Great Plains accounting. Great Plains has produced DDF files for versions 9.1 and later versions that support ODBC and differ from previous years DDF. Because these files are different from previous versions, do not intend to support ODBC versions of Great Plains accounting prior to version 9.1. To install these DDFS, go to DOS and go to the board of a company that you want to access. . Insert the disk labeled “Disk 1 ODBC 2″ Type A: INSTALL A:. This will load the files and FILE.DDF FIELD.DDF INDEX.DDF in this directory of the company. They should be installed directly in the signature data file (eg GPDATA) you want to create the data source, otherwise it will not be able to see your data.

p <4. Migration Route Great Plains 7.5 GPA. If your business is successful and wants to move away from archaic corporate ERP, such as GPA for DOS or Windows (support was stopped by Great Plains Software in 2001, Microsoft Business Solutions, the current owner of Great Plains Dynamics for Migration has reduced, so Overall 40% of the AGP modules within your organization), please call us to update the information each time of re-entry into 5. New license key company in the GPA. If you want to open in the new company Great Plains Accounting, please call us and we will send Dynamics GP Partner change shape when viewing files in Microsoft Business Solutions customer database, we can generate new registry keys related to your new company name

Dynamics GP Partner CA, IL: next step if the implementation of the Great Plains not
business

ERP Microsoft Dynamics GP, formerly Great Plains Dynamics, eEnterprise (please note that the Great Plains Accounting for DOS, Windows and Mac is the legacy of different ERP applications), is designed to medium-sized companies and has lots of features and battery technology in general: Dexterity, MS SQL Server, MS Office integration, SSRS, Integration Manager, eConnect, etc. That said – we want to wait a certain level commitment to implementing management of projects, including the IT department. Also, sometimes you may be exposed to the situation when your partner Dynamics GP is a kind of introduction of new Great Plains Consultant, or simply do not have enough experience in your industry or size of the project may be too difficult. In other words, a combination of factors, and if you read this, you are probably trying to figure out how to recover your investment in Dynamics GP licenses and go to the second opinion and the implementation of the Great Plains of recovery. Try to analyze the most typical scenarios of project failures Dynamics GP and get out of there:

p <4. I get help? Please do not hesitate to call us at: 1-866-528-0577, outside U.S.: 1-630-961-5918 or email help@albaspectrum.com We are very technical and real skill Dynamics GP, SAP Business One SDK programming gurus. We have Great Plains Software Development Factory and unlimited support can customize Dynamics GP and programming needs. Besides speaking English speakers, Chinese, Spanish, Portuguese, Russian, and not just as a native of the sale, but as real advisers. If you prefer skype: albaspectrum

Microsoft Navision, Axapta or Great Plains – ERP selection for Large Corporation

ERP selection for large corporations is typical because of their presence in different countries with different laws, languages, business culture, market trends, customer taste and currency. Apart from these scalability and adaptability of the ERP is also of utmost importance for future requirements and problems.

Microsoft has been working on ‘project green’ which is to unify all four ERP into one to give a powerful solution to its users. The reason being that there are serious overlapping of features and functions in the four ERP of Microsoft which does not justify their separate presence in the market. As far as Microsoft dynamics SL is concerned, it is more suitable for project based companies rather than manufacturing or large distribution enterprises. To identify the most suitable option for any large enterprise out of the other three ERP solutions of Microsoft, it is important to consider the criteria companies follow to choose an ERP solution.

Customization of the available ERP is important to fit in the exact requirements of the user, Microsoft Navision, Axapta or Great plains can be customized with ease but customization of GP is the easiest of them. Great plains is considered as easiest to setup and launch in comparison to Navision and Axapta. Navision requires mid-size customization while Axapta has longer implementation cycle. With the MS SQL server at back end both Navision and GP, are capable of giving more integration and reporting options with crystal reports. Being an SQL based ERP both of these can be integrated with Unix, Linux or Oracle comfortably.

While doing ERP selection for large corporation one of the primary requirements is the capability of the ERP to work in multi-company, multi-division and multi-currency environment. These procedures shall be added on, as and when required, and with out any restrictions, Navision, Axapta and Great plains provide such working environment. In terms of flexibility all the three ERP solutions of Microsoft are at par, though Great plains has more options as add on, which gives it more flexibility to adjust according to the user requirements and also makes it cost effective.

User friendliness and internet integration are other criteria used by the large enterprises for ERP selection. Today almost every ERP provide internet integration for e-commerce, web portals and e-business facilities including Axapta, Navision and Great plains. All the Microsoft ERP solutions are user friendly and can be handled easily even by the staff of the company having minimum IT skills. Role tailored of role center screens of Axapta has been its highlight which gives a customized screen for better and quick understanding and feeding of data by removing irrelevant grids and information.

Over all out of the three Microsoft dynamics ERP solutions, Great Plains with its 10 years of presence, its flexible features, quick implementation, cost effectiveness, internet integration and integration with MS office and other Microsoft products, appears to be the most suitable ERP solution for large enterprises. Though recently there has been a surge in the installations of Axapta but it is still a relatively new ERP compared to Navision and Great plains.

Great Plains Partner Newsflash: the implementation and support of recession

If you have Microsoft Dynamics GP implementations in your company, or if you are anxious to buy Dynamics GP user licenses and modules, install and implement, at the time of recession, as is currently 2008 and 2009, we recommend you review the following selection of ERP, sales cycle, data conversion and user recommendations for training, our experience in implementing Great Plains since 2004 shows that it can save money and ensure successful implementation and go into production:

systems 1 Scope compared with the standard functionality ERP and MRP idea is simple – if regular business with most business processes to the standard .. and only some of the unique processes, which is likely to have a PRS custom logic to be scheduled for you, consider the idea of purchasing the ERP system, you do not get what we call the logic of the rich, but instead of buying ERP standard logic simply does not work and you do not have to pay in advance, and then once a year for most of the “rich” logic, is not intended as a practical example of using -. if you are very controversial because MRP rich functionality such as Oracle E-Business Suite, try to download and considered “normal” logic of ERP, such as Great Plains Dynamics GP

three search options are much better support of Great Plains resellers, ISVs and consultants customization market that could serve. Choose the one that does not try to strong sales in these difficult years, and customers who prefer a low profile, which has not seen maintenance and repair of data

4 . Train your IT department to support simple GP internal matter. If you already have MS SQL Server DBA, or Microsoft Visual Studio C # or VB programmer also may form in the GP architecture, and user support cases GP

only

Flash Partner Dynamics GP: Great Plains Erp recession Time Re-Haul

p

deployment

automatic integration dynamics GP Do people in manual data entry, which are responsible for receiving an email in his recent e-commerce transaction (the customer order and placed credit card payment) have to manually enter in the Dynamics GP Sales module processing orders If you do -? this could be one of the most costly and time consuming process, and leads to human errors in data collection and monitoring of customer calls the resolution of support consider switching to automatic integration You have two powerful tools: … Dynamics GP Integration Manager and eConnect IM is an easy to use, while eConnect is for your IT department programmers code in C #, VB.Net, SQL

2. Dynamics GP manual Excel reports. This is another example of irrational business processes. In Great Plains Dynamics GP Installation Reports usually a journalist Financial FRx, Crystal Reports, Microsoft SQL Server Reporting Services (SSRS o). Sometimes you could hear the words of apology to the Excel manual that the statement includes several businesses, implemented in multi-platform applications ERP: Dynamics GP, SAP Business One, Oracle E-Business Suite, Quick Books Peach Tree Even in this case , Dynamics GP you should review options with FRx reports consolidated reports

. 3. Dynamics GP customization. If you see employees more as accounting or HR manual handling is something that is not automatic in the standard Great Plains business logic, consider re-examine this issue with your Great Plains VAR to see if single or modification could reasonably cover GP gap. Microsoft Dynamics GP Dexterity is usually the way of encoding GP or add your own customizations

p <5. In this recession, there are many new opportunities to reduce the budget, please contact us by our specialists in medicine to hear your story and help you on your way to reduce costs and merits of zero cool

Great Plains Accounting Windows7 : compatibility, installation, support

If you still have the old Great Plains Accounting for DOS or Windows (archaic Windows application, based on the engine of Windows event model ancient and primitive GUI), which tried to implement Windows 7 and the results are presented in this publication. If you do not know, you can redeploy environment PAM DOS / Windows client / server, where server is PAM and the PAM client Windows 2003/2008 Server in Windows XP, Windows Vista. These facts have been described in previous publications on the subject. Today we publish new information relevant to the operating system Microsoft Windows 7:

1. ACP could be implemented in Windows 7 32-bit version. Note that the GPA and Btrieve / 2 Pervasive SQL Server 2000 Service Pack 4, 3, are not compatible with 64-bit operating systems. As we write these lines in September 2010, if you just go to the computer store and try to buy the PC standard (either AMD or Intel platform) – may have weighed the chances are that the store all teams in the 64-bit (64 Windows 7 Home or Professional, Windows Vista Home or Professional). At that time, one of the best options for 32-bit Windows 7 installed – buy a small PC (netbook not as they may conflict Windows 7) with an Intel Atom, if you can not find the hardware system Windows7 32-bit preinstalled. Then, just download and install Windows 7 32-bit MSDN Subscription

2. Installation. In our case we used 32-bit Windows 7, the small load PC (Intel Atom Zotac, loaded Windows7 Business 32-bit), which is currently available through TigerDirect and sold without an operating system. We have PAM installed Windows from the CD to install version 9.5, after all the defaults. If you need your GPA only for claims transactions, you can install a database user with the GPA only your computer directly to Windows 7 (usually in C: folder GPDATA GPS, if you have several companies in the Act you have to copy the database to register the company GPA, usually are the abbreviations of the names of companies). When you want the GPA to the company by default in Windows, please locate the file in the Windows folder GPAWIN.INI (usually drive C:), look GPDATA DefaultCompany = string and change the default file as Company necessary

3. Great Plains Accounting support. PAM can be updated through the current version of Microsoft Dynamics GP 2010. Update is not free, you’ll pay for the software (usually with a good reduction, as the owner of DPM’s license you have the privilege of coupons for Dynamics GP with the same set of modules), the more you pay by office hours to migrate PAM Dynamics GP (migration tool is available from Microsoft Business Solutions). However, we know many stories of clients of PAM, which simply stick to the accounts of the Great Plains, due to lack of budget (reduction of personnel is often the case). We are more than happy to support the GPA for DOS, Windows and to some extent, on the Macintosh. The way in which support AGP, see next paragraph

4. Knowledge Base PAM support in Excel. Microsoft Business Solutions does not directly support GPA (probably due to the high overhead of training consultants and supported only a few calls, compared to 11.0 Dynamics GP. 10.0 or 9.0 to 8 full-time hours a day coach the typical workload). Therefore the direct support given to the dynamics of PAM GP VARs that have to do with former officials of the Great Plains accounting consultants (obviously these people support the new versions of Dynamics GP as well, but I still remember his training AMP and certification exams)

5. Typical case of WFP support. The majority of calls we face are damaged data recovery and repair of the GPA. Second in popularity is the travel demand Novell SPM / Windows NT4 Server to something more modern (Windows 2003, Windows Small Business Server 2008). The third candidate is when you move away from the AMP to another application Small Business ERP, something like SAP Business One, QuickBooks, Peachtree, MYOB, ACCPAC and need to export data (customers, suppliers, employees, sales and trading purchase, the chart of accounts, transactions GL)

6. Far from the amplifier when the business grows. Our recommendation is to consider switching to Microsoft Dynamics GP, home to the migration and upgrade path. In our view, this migration to high-end business ERP applications like Oracle Financials, PeopleSoft, SAP R / 3 is not likely that your software licenses and consulting budgets optimal hours

7. Great Plains Accounting e-commerce and programming. Do not recommend betting on the law, when passing through e-commerce website with shopping cart, and in our opinion Btrieve database PAM can be very hostile to programmers with modern electronic commerce (which you can connect to Btrieve tables through an ODBC connection PAM, PAM Btrieve see manual for details.) Instead, you should upgrade to Dynamics GP, then rotate the integration of e-commerce web

8. How to contact us Please call 1-866-528-0577 or email us help@albaspectrum.com Due to the limited number of average customers, we support your U.S., Canada, national and even international, Latin America, the Caribbean, Asia (English, Spanish support Chinese and Russian). local service in the Chicago area, Western Michigan (Kalamazoo, Benton Harbor, Holland, New Buffalo, Grand Rapids, Battle Creek, San Jose), Southern California:

Los Angeles, Orange County, San Diego

Great Plains eEnterprise upgrade, migration, support

Before the day of Great Plains Software was bought by Microsoft (the form of Microsoft Business Solutions Great Plains, later renamed simply for Microsoft Business Solutions and later the subdivision of Microsoft Dynamics) eEnterprise was high-level or version of Great Plains Dynamics luxury, which was applicable to versions 6.0, 7.0, earlier versions were known as Dynamics C / S +. He later became Great Plains eEnterprise professionals (while the low profile version of Pervasive SQL 2000 and Ctree, and later in MSDE 2000 was known as Great Plains Select version 7.5)

2. Migration. In this sense, are supposed to be at the foot of the Great Plains eEnterprise ERP application to another (or possibly in the form of Oracle eBusiness Suite high-end, PeopleSoft, or in the way of reducing the size of fish QuickBooks ACCPAC). eEnterprise available on MS SQL server platform and is reasonably simple routine to export the logs, work and historical transactions from MS SQL to something like the tab-delimited text files or comma or even set up an ODBC connection to convert data of the database

Source 3. eEnterprise and international corporate ERP market. Great Plains Software has been active in providing Corporate ERP implementation in Europe, Latin America, Africa, Southeast Asia, Russia (in countries where English is the language of business). When Microsoft entered the scene, downplayed all ERP platforms, except for Axapta (Dynamics AX) and partially Navision (Dynamics NAV)

4. For more information, please call 1-866-528-0577, email us help@albaspectrum.com By the nature of our services, we are available to implement WMS U.S. nationally in Canada. local service available in West Michigan: St. Joseph, Kalamazoo, Grand Rapids, Muskegon, Holland, New Buffalo, Chicago area, Northwest Indiana, Southern California (Los Angeles, San Diego, Irvine, Orange County) , Houston and Dallas areas of Texas