Editorials » Technology » Microsoft
 

Microsoft Dynamics GP SQL Reporting: overview for consultant
by Andrew Karasev.Plus SQL has advantage of joining GL with SOP, POP, IV and produce aggregated queries for specific set of posted transactions.  In this small article we will show you how to produce Balance sheet for account segment.Let’s assume you have subdi...
Similar Editorials : Microsoft Great Plains Reporting

Popular SQL Queries for MS Dynamics GP
by Andrew Karasev.As technology advances, computer professional needs balanced level of SQL querying skills to support ERP application, sufficient to be able to produce queries for reporting, minor data repair, transaction auditing. ?Typical scenarios are: month closi...
Similar Editorials : MS Dynamics GP

Microsoft Dynamics GP support in Chicago Metro
by Andrew Karasev.Microsoft Great Plains is part of Microsoft Dynamics family together with Navision, Axapta, Solomon and Microsoft CRM – each product was renamed as Microsoft Dynamics GP, NAV, SL, AX and CRM respectively.  Currently Microsoft is advancing rapi...
Similar Editorials : Microsoft Dynamics GP

Microsoft Great Plains Chicago area consulting
by Andrew Karasev.Here we would like to give you highlight on how to implement unique business processesCustomization.  This is very helpful and at the same time modification requires experience in GP software development.  You should become completely satis...
Similar Editorials : Microsoft Great Plains

Microsoft GP Dynamics GP Integration with Microsoft RMS
by Andrew Karasev.This was long lasting issue and demand from the ERP market – to integrate back end accounting with retail management application.At this moment MS RMS version is not a concern, it should be easily adaptable for new RMS releases.? Integration works ...
Similar Editorials : Microsoft CRM Integration

Microsoft Dynamics GP Posting Server Extension
by Andrew Karasev.To give you some excurse – eConnect is type of replication of GP dex logic in SQL stored procedures. eConnect has several shells or interfaces, but in the core you see dexterity logic replication.  And eConnect limitation sits in work document...
Similar Editorials : Econnect Posting Extension

Microsoft Dynamics GP Lot Number Tracking Logic
by Andrew Karasev.In GP we control Purchasing, inventory (inter-stores) transfers, new items/lot creation and barcode labels printingBarcode labels.  You receive new or existing inventory items in GP and print labels for RMS stored, containing GP Item Number plus...
Similar Editorials : Microsoft Dynamics GP

Microsoft GP SQL Scripting: repairing lot number
by Andrew Karasev.Below we would like to give you brief excurse to lot number tracking and provide fixing scripts:Item Lot Number Master table, IV00300.  This table gets record when lot is received at the specific date, please familiarize yourself with its primar...
Similar Editorials : Microsoft RMS

Microsoft Dynamics GP as back office ERP in Retail business
by Andrew Karasev.Microsoft Great Plains typically integrates with Microsoft Retail Management System (MS RMS).  You should consider the level of integration: do you plan just to pull transactions from RMS to GP or you plan to control RMS inventory and purchasing...
Similar Editorials : Microsoft Retail Management System

Microsoft Dynamics GP Dexterity Customization Upgrade
by Andrew Karasev.Since then the initial purpose of Dexterity lost the actuality, but it still does the job and Microsoft Dynamics GP 9.0 and 10.0 are dex built applications.  And, so dex modification upgrade is actual, especially for businesses with custom ERP l...
Similar Editorials : Microsoft Navision Customization Upgrade

Microsoft Dynamics GP implementation, modification & reporting
by Andrew Karasev.Crystal Reports vs. MS SQL Server Reporting Services.  In our opinion both tools are good, however you should make a choice.  If your internal IT support feels comfortable supporting your SQL server and web interfaces, for example if you ho...
Similar Editorials : Microsoft Great Plains Implementation

Microsoft Dexterity Programming Challenges
by Andrew Karasev.In this small article we will try to orient you in how you should consider your current Microsoft Dexterity modification upgrade, what are dex pluses and minuses from contemporary programmer standpoint:OOP or object oriented programming.  If you...
Similar Editorials : Dexterity Trigger

Microsoft Dynamics GP Reporting – overview for consultant
by Andrew Karasev.This variety of reporting gadgets sometimes leads to misunderstanding on what reporting tool can do for you.  Let’s take this philosophical approach – if you have a tool to create screws, required in car assembly – this doesn’t mean that...
Similar Editorials : Microsoft Dynamics GP

Microsoft Dynamics GP Autoposting server
by Andrew Karasev.This is actually architectural restriction of Microsoft Dynamics GP, former Great Plains Dynamics Dexterity: work documents must be reviewed by GP operator and manually posted through GP interface.  These facts had Alba Spectrum developers to bu...
Similar Editorials : Microsoft Dynamics GP

Microsoft Dynamics GP internal, external support
by Andrew Karasev.Look at this with the following approach – if you have very old car, you probably can repair it on your own, however if you bought new one, where you don’t know how to deal with computer, fuel injection, plus you don want car warranty not to be c...
Similar Editorials : Microsoft Dynamics GP

Microsofts Windows Server Beta Arrives
by Subhash.The first public "beta" release of Microsoft Corp.'s next-generation Windows Server operating system, code-named Longhorn, is now widely available, the company said.The Redmond-based company's last major overhaul to the server OS was in 2003.Longhorn...
Similar Editorials : Windows Server

Microsoft Dynamics GP version upgrade – overview for consultant
by Andrew Karasev.Custom logic could be introduced in the form of Dexterity (integrated module, which you see in your Dynamics.SET file), Modifier (modified GP forms and VBA scripts), Integration Manager (where you can also have VBA alternate logic), plus it can be on...
Similar Editorials : Microsoft Great Plains Upgrade

ReportWriter: Microsoft Dynamics GP technical highlights
by Andrew Karasev.Microsoft Great Plains was designed as Dexterity application in earlier 1990th.? At this time ReportWriter was the platform-independent Dexterity based GP module and as we see through about 15 years – it still is an does the job.? Of course, there ...

Microsoft Dynamics GP table structure overview
by Andrew Karasev.Setup Tables.   These tables have 4 prefix.  IV40100 – this is Inventory Control Module setup table.  Setup tables may have only one record, if this is module setup or multiple records, if this is something like Inventory Class ...
Similar Editorials : Overview of GP Dynamics

Microsoft Dynamics GP large scale customization overview
by Andrew Karasev.You should be familiar with: Microsoft Dexterity, eConnect, Business Portal, VBA/Modifier, GP Integration Manager.? Plus you should be comfortable in understanding how to balance your internal IT resources and potentially internal development contrac...
Similar Editorials : Microsoft CRM Customization

Microsoft Dynamics GP Data Conversion – Overview for Consultant
by Andrew Karasev.Do not be overwhelmed with potential problems expectation, relax, think about your options and ways to go.? In this small article we would like to give you some orientation on the possible steps to undertake and pitfalls.? First you should think and ...
Similar Editorials : Data Conversion

Microsoft Dynamics GP data migration – overview for programmer
by Andrew Karasev.As simple if might look – this approach requires close familiarity with GP architecture, its Microsoft Dexterity database features (such as DEX_ROW_ID).  So, here we would like to orient you in which set of tools should be tried first, which t...
Similar Editorials : Microsoft CRM Data Migration

Microsoft Dynamics GP Dexterity Customization Quality Assurance
by Andrew Karasev.GP has pretty adaptable and complex application business logic, consider the specific of serial and lot number tracked inventory items over the ones, that are not tracked as a good example.? Our point is this – if you order Dexterity customization ...
Similar Editorials : Microsoft Dynamics CRM customization

Excel Training Courses For Employees
by Trycmcw.The heart of a profitable business is one that operates effectively and efficiently; one where every employee works hard at doing their part to meet the overall company goals. Having had the opportunity to peer inside the operations of multiple succe...
Similar Editorials : IT Training Courses

Excel Advanced Course for Learning Complex Tasks
by Microsofttraining.There was once a young man who, in his youth, professed a desire to become a great writer. When asked to define "great" he said:"I want to write stuff that the whole world will read, stuff that people will react to on a truly emotional level, stuff t...
Similar Editorials : Accomplish Difficult Tasks Easily

 
Page 11 of 26 : «Prev | 11 12 13 14 15 16 17 18 19 20 | Next»