Articles about DDF (0-50 of 71)

  • Dynamics Gp Ap Check Batch Recovery And Reposting Consulting Notes
    By: Andrew Karasev | - In Payables Management module computer check processing typically takes time or at least to say one minute or more. Traditionally Great Plains deploys two tiers architecture with the option to send batch posting to secured and backed by UPS processing server. If you are posting batches directly from your user computer and something happens with power and computer simply crushes then chances are high that you need to do data repair on the SQL or Pervasive/Btrieve levels. Lets review why the ...
    Tags: ,

  • Dynamics Gp On Pervasive Sql Server And Ddf Generator
    By: Andrew Karasev | - The technique of ODBC connection to old versions of Great Plains Dynamics based in Pervasive SQL Server 2000 or Btrieve is reasonably straightforward. Modern day programmers are typically comfortable to deal with ODBC or native driver connection to Microsoft SQL Server and the number of consultants who are ready to connect you to B-Trieve database is limited. Lets review the technology and the steps:

    1.Great Plains versions on Btrieve/Pervasive SQL 2000. Back in earlier 1990t ...

    Tags: ,

  • Sap Business One Moving Data From Legacy Great Plains Dos
    By: Andrew Karasev | - Data migration from legacy accounting packages to modern Small Business ERP is always popular and we do not expect the trend to change in the future. In this small paper we would like to review the options assuming that you are walking away from Great Plains Accounting for DOS, Windows or Macintosh versions 9.5, 9.2 or earlier. Publication is addressed to computer professionals who are comfortable with such terminology as ODBC, Pervasive SQL, Microsoft SQL Server Management Studio and data mas ...
    Tags: ,

  • Sap Business One Implementation And Walking Away From Great Plains Dos Accounting
    By: Andrew Karasev | - When you are switching from one software vendor to another one chances are high that you have to do data export, cleansing and migration to newly selected accounting application. SAP B1 is hosted in Microsoft SQL Server and data import is typically done in Data Transfer Workbench by filling CSV templates each per logical table. In our opinion real challenge is in exporting legacy accounting transactions especially when they are hosted in proprietary database platform or maybe in Btrieve with c ...
    Tags: ,

  • Accounting Data Conversion Highlights And Homework Recommendations
    By: Andrew Karasev | - When you are switching from one Accounting or ERP application to another one data migration is one of the key questions to consider. If you are staying within the same application vendor them chances are high that there is migration tool. For example if you are on DOS version of Great Plains Accounting then you can migrate to Dynamics GP via migration tool and then upgrading all the way up to current version 2010. Such migration allows you to avoid expensive and often difficult historical dat ...
    Tags: ,



  • Free Dmx Software Package - A Great Nightclub Deal
    By: Disco Designer | - Lighting is the life and soul of a place like a nightclub, bar or disco. While the proper mix of lights can endow an electrifying aura on the place, a lack of it can quickly make it boring and lifeless. A DMX controller may be the greatest lighting option that one can stream into the venue, but to get the management at your fingertips, you need the DMX software too. Free DMX Software package is obtainable in the web for download and is an superb tool to assist you generate the greatest lighting ...
    Tags: , , ,

  • Great Plains Payables Computer Check Batch Recovery Notes From The Field
    By: Andrew Karasev | - It is not really difficult to do it when your system is on Microsoft SQL Server and Dynamics GP has one of the recent versions with Batch Recovery functionality. We would like to describe how to do the job if you have old Dynamics on Pervasive SQL Server 2000 and its version is 7.5, 6.0 or older. Also if you are technical consultant you can use Pervasive SQL Driver with DDF file to create ODBC connection to Btrieve files. However if you are not too technical the method described below should ...
    Tags: ,

  • Data Migration To Sap Business One Or Walk Away From Legacy Accounting
    By: Andrew Karasev | - Native data conversion tool for Business One is Data Transfer Workbench. If your data cleansing and migration project is reasonably modest in its scope and number of records to bring over then all you need to do is to fill out so-called CSV template files. Natural tool to do the job is Microsoft Excel. We do not expect you to read this publication just to reassure yourself that CSV templates are the way to go. We rather expect you to get some issues with CSV templates due to enormous number ...
    Tags: ,

  • Sap Business One Data Migration Service Exporting Historical Documents From Great Plains
    By: Andrew Karasev | - Data Conversion phase should be taken seriously as it is one of the most popular reasons for Corporate ERP implementation project to fail. It is recommended to do testing and final data import into Business One in Data Transfer Workbench where you first have to work out CSV templates population process in Excel. This is not really a challenge except probably manual data massage in Excel with numerous templates. Today we would like to talk about exporting data from Microsoft Dynamics GP, Small ...
    Tags: ,

  • Sap Business One Data Migration From Great Plains Dos
    By: Andrew Karasev | - Great Plains Accounting for DOS versions 9.5 and 9.2 was very popular in mid 1990th prior to the time when Great Plains Dynamics proved itself as modern replacement to GPA. Accounting is still in use at some small and even medium size businesses but it is in phasing out cycle. Probably good idea is to consider checking with Dynamics GP resellers what would it cost for you to transfer GPA software licenses into GP licenses as well as migration and upgrade quote in consulting hours. If you do w ...
    Tags: ,



  • Erp Data Migration Or How To Export, Cleanse And Import Documents Into New Accounting System
    By: Andrew Karasev | - Before we dive into details lets restate the old data conversion wisdom that the best conversion is the one that was avoided. Think about the approach where you keep old accounting system on one of the small servers and use it for historical documents inquiry only whenever historical customer calls you. First couple of months this server might be busy providing inquiries results but after the period the shift should be toward your new Corporate ERP application while legacy system migh ...
    Tags: ,

  • Converting To Dynamics Ax And Exporting Data From Great Plains Custom Tables
    By: Andrew Karasev | - Former Axapta and now part of the Microsoft Dynamics ERP family known as AX is marching over United States Corporate ERP upper mid-market. This migration path is popular where you are abandoning your old Great Plains Dynamics version and moving to AX. There might be various reasons and in our opinion the most popular ones are rapid company grows where former GP doesnt provide required new functionality and the second one is the fact that you do not have active contract with Microsoft Busine ...
    Tags: ,

  • Compounds Usual External Therapies In Acne
    By: Lise Beverley | - Because many remedies on the market for treatment of skin and too much diversity in each sub-category, it's really not unusual to find several fascinating substances. Since its function is generally the same, it is not uncommon that a product of acne therapy to have at least a few ingredients in the midst of the products.

    You can see the ingredients common to the most reliable solutions, such as Proactiv and Clearasil. For example, Proactiv contains benzoyl peroxide compound, which ...

    Tags: , , ,

  • Dynamics Ax Initial Data Import Phase And Exporting Historical Transactions From Great Plains
    By: Andrew Karasev | - Data conversion especially historical documents move from one ERP system to another is something not recommended but sometimes required. In Axapta such migration technology as Excel Import is popular and you may consider doing it internally without appealing to consulting budget. Popular migration path is from old version of Great Plains Dynamics or even its DOS version GP Accounting. We would like to review GP table structure, data export options and other things to consider. This small pub ...
    Tags: ,

  • Moving To Sap Business One From Great Plains Steps And Recommendations
    By: Andrew Karasev | - The likely reason of such migration is outdated version of Great Plains Dynamics and inability to upgrade. Customers on older ERP version typically do not have current support plan with Microsoft Business Solutions and do not have new version registration key for upgrade. Sometimes the reason might be quite exotic. One of the multinational companies with facility in Brazil figured out that GP is not localized in that country. SAP B1 was chosen to be implemented over there with overnight GL e ...
    Tags: ,




  • Sap Business One Recovering Failed Implementation Or Second Opinion
    By: Andrew Karasev | - If your implementation is simple without customizations and historical data migrations it is very unlikely that you are reading this publication. Likely that in your situation you either are trying to force through massive historical data export from legacy accounting and import into Business One or maybe got complex SDK programming project in limbo and over budget. Generic consulting firm which is typically located in neighboring town has so-called sales engineers and functional consultants. ...
    Tags: ,

  • Data Conversion From Old Great Plains To Dynamics Ax
    By: Andrew Karasev | - It is popular route when your company grew and now your legacy Corporate ERP doesnt do the job and is not scalable to catch up with lacking functionality. Likely in the past you did strategic decision to implement high end ERP system and walk away from Great Plains Dynamics. And when you finally decided on Axapta Dynamics AX your Great Plains version is really old and it is hosted in Pervasive SQL 2000 and now you are facing the challenge to export historical documents and master records fr ...
    Tags: ,

  • Sap Business One Alternative To Excel Templates In Data Migration
    By: Andrew Karasev | - Data Transfer Workbench is traditional data import tool and consultants are trained to prepare so-called CSV or Excel templates filled with data rows from your legacy accounting. Workbench does perfect job where your import volume is modest and you only importing several tables. However it is not always possible to keep legacy accounting system for data inquiry. Especially when your legacy accounting is licensed on subscription base and you lose connection as soon as subscription expires. If ...
    Tags: ,

  • Data Cleansing And Templates Preparation Prior To Migration To Sap Business One
    By: Andrew Karasev | - It is generally good idea to avoid full scale data export and migration into your new Corporate ERP system or in other words to migrate large portion of historical invoices, payments and other documents. It is easier and budget wise cheaper to keep the old accounting online for data querying only purposes. Sometimes you have no way of keeping the old application online due to subscription model or maybe another reason. We would like to share with you advanced methods of migrating in Data Tran ...
    Tags: ,

  • Crystal Sales Commission Report Design Overview And Recommendations
    By: Andrew Karasev | - Major accounting applications such as SAP Business One, Microsoft Dynamics have Sales commission accruing functionality and reporting. However it is often the case when your commission formulae are complex and you have to do calculations outside of the commission login in your Corporate ERP. For example if you are selling advertising minutes your cost might be negotiated for each calendar month with media portal. It might be not practical updating the cost for each item in the inventory contr ...
    Tags: , ,

  • Alkaline Ph, The Effect Of Eating Disorders - 3 Tips
    By: zidit | - PH alkaline-food helps to counteract the acidity in your body. Acidity is a condition in which you must take into unhealthy foods, and then make you sick. PH alkaline-food is the only way you can balance your inner terrain. All you have to do what you're eating, is rich in alkaline foods and be healthy, feel younger and more energetic.
    Not long ago, when I turned 31. I never thought that I feel so bad. I was always feeling sick and tired, I felt pain in the joints andThe muscles are too ...

    Tags:

  • Data Conversion To Sap Business One From Great Plains Dynamics Plus Notes On Odbc Connection
    By: Andrew Karasev | - SAP B1 is popular as Small Business ERP system however we know the cases when multinational company with Dynamics GP in their headquarters decided to deploy Business One in its overseas subsidiaries. And in a matter of several years they switched to B1 for headquarters as well. Why they decided to do it? Well, there are reasonable advantages in running accounting on Business One for the company working on international markets. This small business ERP is localized virtually worldwide and use ...
    Tags: ,

  • Migrating Data From Great Plains To Dynamics Ax, Sap Business One, Oracle Notes For Consultant
    By: Andrew Karasev | - When you make a decision to implement new Corporate ERP in the near future, you typically stop version updates for your existing accounting application. When that future time comes legacy application might be so outdated that it is not easy to export its records without consulting help from somebody who is still supporting old releases. In this small publication we would like to review such popular mid-market ERP as Great Plains in its various clones. Chances are high that you are on somethin ...
    Tags: ,

  • Migrating Data Into Sap Business One
    By: Andrew Karasev | - There are several powerful tools, developed by ISV channel and they are obviously pricy and require consulting budget. If you ask SAP B1 consultant on how we move our old accounting documents and master records into the new system, the answer likely to be that we will use Data Transfer Workbench. And what are the steps to prepare integration? They are first export data from legacy system, second save then in predefined CSV templates and the third pull these CSV files via Data Transfer Workben ...
    Tags: ,

  • Data Export From Great Plains And Migration Into Dynamics Ax
    By: Andrew Karasev | - This data conversion path is popular, especially when you are on older versions of Great Plains Dynamics on Pervasive SQL Server 2000 or GPA for DOS and experienced high growth in recent years and need something more flexible. In this scenario you typically check on the Great Plains to Dynamics GP upgrade software and consulting hours cost and realize that you have to pay penalty for expired annual contract. And instead of repurchasing GP you decide to take upscale solution and switch to AX. ...
    Tags: ,

  • Sap Business One Data Conversion Projects And Recommendations
    By: Andrew Karasev | - It is not a secret that data migration is typically done in Data Transfer Workbench and the sources are CSV templates, which you need to fill with the data exported from your legacy accounting. We would like to talk about conversion scope, exporting data from legacy ERP as well as suggest Advanced ODBC data link. If you are reading this paper after data import failed and you would like to seek second opinion you are in the right place. We do not want to be too technical here and document shou ...
    Tags: ,

  • Sap Business One Customization And Data Conversion Getting Second Opinion
    By: Andrew Karasev | - SAP B1 implementation is typically goes pretty smooth, assuming that you do not require extensive programming in SDK and data conversion. Local implementation firms might be small in size and not affording to have SDK programmer in staff. Excel CSV templates are also simple to fill and conduct minor data migration. Custom objects, such as new user defined tables or additional fields for the existing table are easy to set and they even get instant user interface to access these objects. This ...
    Tags: ,

  • Corporate Erp Initial Data Conversion To Microsoft Dynamics
    By: Andrew Karasev | - In this publication we would like to review data migration in initial implementation for two ERP products: Dynamics AX and GP. Formerly they were known as Axapta and Great Plains respectively. Before we begin we would like to share with you some fresh air about data conversion, its export from legacy application, cleansing. Importing documents into the new system requires consulting budget, which potentially could be avoided. Think about just keying in initial account balances in General Led ...
    Tags: ,

  • Data Migration From Great Plains To Dynamics Ax
    By: Andrew Karasev | - Both Corporate ERP applications belong to Microsoft Dynamics family, their user interface navigation is similar. However they have different tables structure and there is no direct data migration utility to switch from GP to AX. Easiest way is probably through Excel Import, where you have to fill in formatted Excel file for each transaction or master record type. Excel Import is recommended for small scale data migration project where number of records in each Excel table is below ten thousan ...
    Tags:

  • Dynamics Ax Preparing Excel Templates For Importing In Data Conversion Project
    By: Andrew Karasev | - Data migration into AX might be tough, especially if you plan to bring over historical sales and purchases. When you are switching over from legacy accounting to new Corporate ERP system general recommendation is to keep old system alive for inquires only and in the new application avoid massive data import. The recommendation is to consider only master records migration, such as customers, employees, vendors, addresses, GL accounts. When you are ready to go into production you also need Gene ...
    Tags: ,

  • Dynamics Ax Converting Data From Great Plains Dynamics And Older Dos Version
    By: Andrew Karasev | - Both former Axapta and former Great Plains are now members of Microsoft Dynamics ERP family. However at this time, July 2011, there seems to be no migration tool to move your data from GP to AX. Probably the easiest and user friendly tool in AX to migrate legacy accounting data is Excel Import. Often the question is about how to export data from Great Plains Dynamics to cleanse it and save in Excel templates for further import into Axapta? Sometimes people refer as Great Plains its predecess ...
    Tags: ,

  • Dynamics Ax Importing Master Records And Transactions From Legacy Accounting
    By: Andrew Karasev | - General advice is try to make data massage and conversion project scope minimal. In the case of AX data conversion is recommended to be minimal as well. Consider keeping your legacy accounting open for inquires. And in your new Corporate ERP system enter GL beginning balances, import customers, vendors, employees, inventory items and start using the new accounting on the first day of new fiscal period. In certain situations this advice doesnt work and you have to dive into full scale hist ...
    Tags: ,

  • Dynamics Ax Data Import And Conversion
    By: Andrew Karasev | - If you are switching to AX from legacy accounting system, often the problem happens in exporting master records, such as customers, vendors, GL accounts and transactions, such as Sales Invoice, Purchase Order. If you as Axapta developer would have legacy ERP data exported to something like text file, SQL Server custom database, or Microsoft Access format, then further import into AX is not a problem. If you need help with integration methods to this application, please read whitepapers on Micr ...
    Tags: , ,

  • Data Migration To Dynamics Ax Projects And Highlights
    By: Andrew Karasev | - This upper midmarket Corporate ERP application often requires custom programming in initial data conversion. This is not necessary a big hurdle, as its technology is flexible and technical consultants are often expected to be part of the implementation team. What might be challenging is export legacy accounting data, especially when it is not hosted in client/server SQL platform, such as Oracle, Microsoft SQL Server. There might be two approaches in these situations. The first one is print a ...
    Tags: , ,

  • Corporate Erp Architectures: Dynamics Ax Versus Gp
    By: Andrew Karasev | - Both applications are members of Microsoft Dynamics ERP family. Former Axapta is often recommended to upper-mid market, process manufacturing, project organization, retail and entertainment, supply chain management. It is also available in most of the international markets. Dynamics GP in the past was also recommended to these industry niches, but with the AX catching up its role and offer were deemphasized. In late 1990th we remember that consulting firms were staffed with numerous Great Pl ...
    Tags: , ,

  • Converting To Dynamics Ax And Exporting Data From Legacy Accounting Application
    By: Andrew Karasev | - It is reasonably straightforward procedure to migrate legacy data into your new accounting system, including AX or formerly known as Axapta. Problem is typically associated with legacy ERP data platform, which is not friendly to modern programmers and consultants. We would like to give you data export highlights for popular switch over legacy accounting. Typically you can consider two strategies. First one would be running reports in legacy accounting and saving them as text files. And the ...
    Tags: ,

  • Exporting Data From Great Plains, All The Versions, Including Dos
    By: Andrew Karasev | - It is obviously the easiest question, if you are on the current version 2010/11.0, as every consultant can help you. It is also relatively straight forward export procedure, if your release is on Microsoft SQL Server platform. In this case all you need to know is review tables structure, well touch it below, open Management Studio and begin your Select statement exercises. If you are on former Select on MSDE, we recommend you install SQL Client workstation and do the work in Query Analyzer ...
    Tags: , ,

  • Tables In Dynamics Gp: Where To Find, Categories, Linking In Reports And Sql Queries
    By: Andrew Karasev | - Former Great Plains has special naming convention for its tables and the names are not self-explanatory, as this application was designed in earlier 1990th, where multiple competing DB platforms often used alphanumeric conventions. We would like to walk you through user interface, where you can find the table name, description and fields. Then we would like to discuss name convention and give you several examples. And finally we would like to review linking strategies in Reports and SQL queri ...
    Tags: , ,

  • Dynamics Gp Customer Email Informatio
    By: Andrew Karasev | - If you are programming integration to this Corporate ERP application as developer you may pose legitimate question about where customer email record is stored. If you know how access table structure via user interface, the first natural way is to guess that email related fields should be on one of the tables in the customer master table cluster in the company database, probably associated with individual address. However architecture of this application found another way of storing internet re ...
    Tags: , ,

  • Recovering Old Great Plains Dynamics Version
    By: Andrew Karasev | - You may find yourself in the situation, when your old Accounting application works until the old server crashes. When such event happens, you may realize that all the consultants, who were involved in initial installation and training are no longer available. So now what?.. Well, lets take a look at the options you may have. First of all, you should be aware that all ever released versions of Great Plains Dynamics, including Select on Pervasive SQL 2000 or Ctree (7.5, 7.0, 6.0, 5.5, 5 ...
    Tags: ,

  • Dynamics Gp Sql Scripting Level Data Repair
    By: Andrew Karasev | - This mid-market Corporate ERP application is hosted in Microsoft SQL Server. However it only deploys limited batch commit and roll back SQL transaction logic. There are some questions about why it is limited and there is the diversity of the opinions. Probably one of the reasons is metadata and business logic abstraction level in Microsoft Dexterity (and its dictionaries, especially the core one Dynamics.dic). Dexterity was introduced as the abstraction level and programming shell, coded in ...
    Tags: , , ,

  • Dynamics Gp, Great Plains Select, Gpa For Dos Remote Support
    By: Andrew Karasev | -
    Whatever version is in use in your organization, they are all reflecting initial design and Dexterity architectural ideas, probably except Great Plains for DOS, Windows or Mac. But even DOS version (9.5, 9,2, 9.1) seems to be similar in its business logic and could be considered as predecessor to Dynamics, which was released as sensational Accounting package available on Microsoft Windows and Apple Macintosh graphical platforms. GPS Dynamics was designed to be flexible, where its Dexter ...

    Tags: , , ,

  • Dynamics Gp Chart Of Accounts Copy From One Company To Another
    By: Andrew Karasev | - When you are implementing new Corporate ERP system it is good idea to review or even maybe redesign your legacy Chart of Accounts. There are sample COA available for the company that you could load during the installation in Utilities (such as generic Corporation, Partnership), however they might look too generic. In normal initial implementation you may decide to have details in such categories, as Sales, Purchases, Inventory, Cost of Goods Sold (if you are in Manufacturing business then prob ...
    Tags: ,

  • Dynamics Gp Cloning The Company
    By: Andrew Karasev | - Microsoft Dynamics GP deploys the architecture where each Company has its own SQL Server database. If you already have one of the companies implemented and in production phase, there might be a guess to reuse that company settings, such as Chart of Accounts, modules setups in the new company that you need to be created. It is possible to clone your existing company and we would like to give you some recommendations and steps. We will review the steps for current version 2010/11.0 (and older v ...
    Tags: , ,

  • Supporting Dynamics Gp, Great Plains And Gpa For Dos Versions
    By: Andrew Karasev | - If you feel that others Microsoft Dynamics resellers are not willing to talk to you due to the fact that you are on outdated Corporate ERP version, the help is available. In fact, some GP partners specialize in old version support, customization, reporting, upgrade and migration. Lets review some details:

    1.Great Plains on Pervasive SQL 2000/Btrieve or Ctree. Here you might be on one of the following versions: 7.5, 7.0, 6.0, 5.5, 5.0, 4.0, 3.2 and earlier. Typical support is ...

    Tags: , , ,

  • Great Plains Data Export Tools And Recommendations
    By: Andrew Karasev | -
    If you are working with ERP version, where your data resides in Microsoft SQL Server, data export or table access in reporting is out of the question. There are a lot of folks, who are still on older versions of Great Plains, including Dynamics Select on Pervasive SQL (often referred as Btrieve, which was original vendor) or Ctree. And also we would like to discuss here Great Plains DOS version, referred as GPA for DOS. In exotic cases we see limited number of customers using GPA on Ma ...

    Tags: , , ,

  • Great Plains Dos Exporting Data Via Odbc Connection Or Pervasive Sql Control Center
    By: Andrew Karasev | - Some of the mid-market and smaller ERP customers are still deploying Great Plains Accounting version 9.5, or 9.2 for DOS, Windows or Macintosh. There are numerous GPA installations frozen for data inquiry only, this is also helpful if you may expect future audit. From time to time we hear requests to open GPA database for ODBC connection, typically when your IT programmer has the project to create several reports out of the old accounting database. Of course, internet is the place where you a ...
    Tags: , ,

  • Great Plains Dos Support: Gpa 9.5, 9.2 And Earlier Versions
    By: Andrew Karasev | - Hello, I am Andrew Karasev, Great Plains Certified Master and consultant since 1995. I am aware that some of you may still be on Great Plains Accounting and Microsoft Great Plains for DOS, Windows or Mac. This is fine, you are hosting your transactions and master records in Btrieve database (or if somebody moved you to modern platform, then you are probably on Pervasive SQL 2000, the successor of Btrieve)

    If you like we can upgrade your GPA all the way through Microsoft Dynamics G ...

    Tags:

  • How To Choose A Good Anti-wrinkle Product
    By: Farid Mostamand. | - Maintaining the youthful appearance of our skin is probably the single largest factor people consider when buying cosmetics. With so many anti-aging products in stores and online, selecting the right anti-wrinkle protection can seem like a daunting task. So, how does one choose the right, and more importantly, the most effective age-defying products? Here are a few strategies in picking the best anti-aging products available.

    Choose a product for your skin type

    Not all ...

    Tags: ,

  • Acne, The Special Clearing Booster
    By: JishnuRaj | - Skin is the largest organ of our body and ample care is important for glowing and glittering skin. But, some skin disturbances like acne put our emotions completely down. Acne is the most visible end result of hormonal, bacterial and inflammatory disturbances. Our skin consists of layers that have blocked pores that do not allow the oil (produced by the sebaceous glands) to come out. As a result, these pores create an ideal environment for the growth of acne bacteria. The acne bacteria expel the ...
    Tags: , , , ,

[1][2

Copyright 2005-2011 ArticleSnatch, LLC - All Rights Reserved.
Privacy Policy | Terms of Service.