| Home | Links |
Microsoft Business Solutions Great Plains is very generic accounting application out of the box and has multiple modules to address specific horizontal or vertical market requirements. At the same time Great Plains, now being moved on MS SQL Server platform allows you to deploy standard tools to customize and fit to these requirements, when you don't need rich custom functionality, just few touches. In this small article let's take a look at finance industry.
Bonds and Loans. If you are issuing these documents ? you probably already have production system in place. What is often seen ? this loans tracking system is not integrated with accounting application. Another case ? loan tracking system may required manual interest recording, especially when client is state agency working in state subsidized programs, such as loans to farmers or small inland townships
? Customer Link. In Microsoft Great Plains borrowers are usually customers in the Accounts Receivables module (RM00101 table ? customer master). To link customer with loans you can have simple Dexterity or web application/extension to be opened from customer maintenance screen. This custom application will show you all the loans associated with this borrower/customer
? Interest/Principal invoices. In Great Plains you naturally use Receivables Management invoices for this purpose. The first step would be manual entry, based on the interest/principal portion, recorded in the above tracking system.
? Automatic Interest Calculation. Yes ? you could associate loan with repayment schema and program it in the formula. The easiest way is to have this implemented as Stored Procedure in MS SQL Server company database. Using SQL Exec statement you can build formula on the fly, considering multiple case scenarios and calculations.
? Reporting. Reporting could be based on both sources ? Microsoft Great Plains customer records and loan tracking database, even if the last one sits in different platform, such as Microsoft Access. You can create so-called linked server to MS Access in MS SQL Server Enterprise Manager and use OPENROWSET construction to pull the data from heterogeneous sources. Feel free to use popular tools, such as Crystal Reports ? you usually base your Crystal Report on SQL view or stored procedure (the second one allows you to use parameters and build temp tables in the body of your stored procs). If you are building web-application you can incorporate Crystal Report in it or deploy html publishing directly with your result set.
? Tools. Consider these tools first: direct web publishing from Great Plains Company database ? use C# or VB.Net with ADO.Net classes; Great Plains Modifier with VBA ? if you are VBA or VB programmer ? you can create masterpieces here, if you need GP tables structure ? Tools->Resource Description->Tables; direct SQL Programming ? you can create custom SQL views or stored procedures in company and DYNAMICS databases; Great Plains Dexterity ? this tool requires Dexterity knowledge and you should probably contract consultant or programmer to spec out this customization and do the job.
Good luck with implementation and customization 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! help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com
Advent Software to Host Analyst and Investor Day Event on Friday, May 11, 2012 Reuters SAN FRANCISCO - February 6, 2012 - Advent Software, Inc. (NASDAQ: ADVS), will hold its Analyst and Investor Day in New York on Friday, May 11, 2012, beginning at 9:00 am (EST). The meeting will feature presentations by Advent's executive team covering ... Advent Software Achieves Record Quarterly Revenue of $86 Million and Record ... Advent Software's CEO Discusses Q4 2011 Results - Earnings Call Transcript Advent Software Q4 Profit Drops; Issues Q1, FY12 Revenue Outlook - Quick Facts |
Oakland police get free forensic software to analyze Occupy videos San Francisco Chronicle (blog) A Pasadena forensic video enhancement software company has donated its technology to Oakland police to help in capturing the goings-on at Occupy Oakland demonstrations, the company announced in a statement. At the request of Oakland law enforcement, ... |
Scorpion Software Announces AuthAnvil Single Sign On Support for Level ... San Francisco Chronicle (press release) Scorpion Software, an industry leader in strong authentication and password management solutions for IT Service Providers and IT departments is pleased to announce integrated support for AuthAnvil Password Solutions with Level Platforms, ... Scorpion Software Offers Support for Level Platforms Managed Workplace |
Caduceus Software Plans to Integrate a Cloud Platform with its Software ... SmallCap Network By Ed Liston Caduceus Software Systems Corp. (OTC: CSOC), a software company specializing in the development of an all-in-one solution for private practitioners and doctors, today, said that it plans to integrate a cloud platform with software systems. Caduceus Software Systems Corp. Plans to Integrate a Cloud Platform with its ... QualityStocks News - Caduceus Software Systems Provides Update on Current ... |
Proposal Software Continues Strong SaaS Revenue Growth in 2011 MarketWatch (press release) WESTPORT, Conn., Feb 06, 2012 (BUSINESS WIRE) -- Proposal Software, Inc. (PSI), The Leader In Proposal Productivity(TM), and makers of PMAPS(R) WebPro (Proposal Management and Production System) announced 2011 results that continue its systemic growth ... |
Manhattan Software Announces Strategic Partnership With Indiabulls for ... MarketWatch (press release) 6, 2012 /PRNewswire via COMTEX/ -- Manhattan Software, the global leader in enterprise real estate software and a leader in the 2011 Gartner Magic Quadrant for Integrated Workplace Management Systems, announced today a strategic partnership with ... |
Mezeo Software Announces National Master Distributor for Japan MarketWatch (press release) HOUSTON, TX, Feb 06, 2012 (MARKETWIRE via COMTEX) -- Mezeo Software(R), a leading provider of cloud storage management solutions, today announced the appointment of a master distributor for Japan, AIR Company Limited, a Japanese company focused on ... |
Is BMC Software Growing or Slowing? DailyFinance By Seth Jayson, The Motley Fool Posted 4:11PM 02/06/12 Investing There's no foolproof way to know the future for BMC Software (NAS: BMC) or any other company. However, certain clues may help you see potential stumbles before they happen -- and before ... |
The Cloud Software Companies You Need to Know About Motley Fool But software as a service is easy enough to define. Whenever you have to access your application through a central location, and pay ongoing license fees to the developer, that's generally software as a service. Microsoft's Office suite is plain old ... |
Longwood Software Establishes Strategic Reseller Agreement with Canada's Interlinc MarketWatch (press release) MAYNARD, Mass., Feb 06, 2012 (BUSINESS WIRE) -- Longwood Software, Inc., the developers and marketers of the RevBase(R) software-as-a-service (SaaS) marketing asset management system ( www.revbase.com ), announced today a strategic reseller agreement ... |
Google News
Related Articles
The Software 2005 Conference - A Review
The Software 2005 conference is now a wrap. This conference, presented by M.R. Rangaswami and The Sandhill Group, is now an annual event and attendance increased 35% this year over 2004. It is an ideal opportunity for those in the enterprise software industry to see what's new and what's coming, as well as to catch up with old colleagues and make new connections. It is also a perfect forum for startups to gain exposure as well as solicit funding and key partnerships.
These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software
1. What determines the software price? Is it Per Seat or Per User or Per Processor?
Great Plains Dexterity Development: FAQ
Microsoft Business Solutions Great Plains is Dexterity-written application and currently we see increased interest for Great Plains customers to do in-house Dexterity development and customization. Dexterity itself is written on C programming language and its initial architecture was based on the Graphical and Database platform independence, which C programming language was believed to provide. Initially back in 1994 Great Plains Software Dynamics and Dynamics C/S+ were realized for Macintosh and Windows and pretty similar Dexterity DYNAMICS.DIC dictionary worked for Ctree/Faircomm and Microsoft SQL Server 6.5. In our days Microsoft Great Plains is available for Windows and MS SQL Server only (since version 8.0). In this small article we would like to give you highlights on the most typical entry level Dexterity development questions
Free Preventive Maintenance Software
While several preventive maintenance software manufacturers offer free trials for their products before charging a fee, some companies offer their products for free. Free preventive maintenance software is rare, and is sometimes less thorough than software that must be purchased, but it can be a good solution for a new or struggling business.
Hear It in Digits
Music downloads are off the charts! We're listening to digital music in the digital era.
What is Spyware? Are You Being Watched?
Find out why Spyware Removal from computers is important and how adware infestations affect your computer, your privacy and your family.
Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager
As you probably know, when Microsoft purchased Great Plains Software ? the whole strategy for Great Plains Dynamics/eEnterprise line was changed. Initial GPS strategy was to maintain DB platform independence ? via it's C-written engine Dexterity, based on the believe that C programming language is platform independent. So ? Great Plains was running on MS SQL Server, Ctree (Faircom ? if you remember 1995-96 Macintosh era), Pervasive SQL (Btrieve). Microsoft obviously had no plan to keep this multiplatform capability and Great Plains was optimized to MS SQL Server and with the introduction of MSDE ? the need to keep entry level Dynamics on Ctree/Btrieve disappeared.
Putting Screensavers Under Control
No matter how much you enjoy your favorite screensavers, sometimes they can be rather annoying. Don't like them interrupting your presentations? Hate them disturbing you watching movies? Look no further. This article will show you how to gain full control over your screensavers in no time.
Fast Car Knoppix
Small can be beautiful! Working with Knoppix for the past two years has been a joy. Two terms to describe this distribution, simple, elegance. See Knoppix is one of the many operating systems that runs from the CD, so it doesn't have the hardware conflicts associated with many instruction sets between hardware and software.
Create A Flash Presentation For Free With Open Office
The intentions of this short tutorial are not to teach you how to use Open Office, but rather to show you a quick and dirty way to create presentations and tutorials that can be exported as a Macromedai Flash file.
SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer
Microsoft Business Solutions Great Plains has Project Accounting module where you can budget the project, assign it to customer contract and then log expenses, timesheets, inventory spending, and finally bill the customer against the project or contract. Microsoft Great Plains Project Accounting does excellent job, but there are cases when you need developer or MS SQL DB Admin touches.
Reloading Windows XP
If you have been running Windows XP for a couple of years or more you may find that it is not running quite as quickly and smoothly as it was when you did your first install. I am constantly 'evaluating' software and uninstalling and reinstalling beta software on my computer and have always gradually become more and more disappointed after nine months to a year with the performance of my PC. So I regularly do a backup and reinstall all my software, including Windows.
Microsoft CRM and No-Frills Cadillacs
In today's business world it's all but impossible to escape Microsoft. Either you're using MS applications, developing your own, or negotiating your company's acquisition by this techno-behemoth. I must that the company is a daily part of my life (in fact I'm typing this article on MS Word). I've found however, that although Microsoft develops many versatile business software products, the company's 'one size-fits-all mentality goes only so far. I'm referring to the Microsoft CRM system. For you lay-people out there, CRM (customer relationship management) systems are designed to help you gather and interpret customer data in order to anticipate future customer purchasing demands and trends.
Exactly What Does FTP Stand for and What Can it do for Me?
FTP stands for "file transfer protocol". FTP is basically a way of sending files over the Internet.
Healthcare Preventive Maintenance Software
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can benefit greatly if up to date CMMS software is used. Healthcare CMMS programs will help with the maintenance of the building, alerting workers when items such as automatic doors, light fixtures, and plumbing structures are due for checkups.
Microsoft CRM and Great Plains Implementation: Freight Forwarding Business Automation Example
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision, Solomon and its own CRM solution ? Microsoft CRM. Targeting to automate all business operations, Microsoft CRM is now integrated with Microsoft Great Plains and in the close future it should have integration with Microsoft Navision. In this small article we'll show you business automation example, where Microsoft CRM and Great Plains are integrated and customized to fit Freight Forwarding business processes.
Did You Ever Want to Completely Erase Everything on Your Computer?
Did you ever want to erase everything on your computer? This is a program I found that does that for you quickly and easily.
XML Parser and Their Types
XML parser is a software module to read documents and a means to provide access to their content. XML parser generates a structured tree to return the results to the browser. An XML parser is similar to a processor that determines the structure and properties of the data. An XML parser can read a XML document to create an output to generate a display form. There are a number of parsers available and a few of them are listed below:
Professional XP Style Icons in Software and Website Development
Using professional icons in your application or website can bring a modern and aesthetically pleasing appearance to your product or service. This will not only help you to attract potential customers but also give you that "edge" you need to stand out from your competitors. In an internet age, it's important that your interface looks professional or your potential buyer might move on without really giving your product a chance to prove itself.
Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant
When Great Plains Software introduced the first graphical accounting application for Mac and Windows in the beginning of 1990th it had Great Plains Dexterity customization tool, IDE and programming language. Dexterity design was based on several longevity principles: Graphical platform independence and database platform independence and easy switch from one DB to the other among the most important ones. Dexterity was written as a shell in C programming language, which was "platform independent" and at the same time very efficient in compilation (close to assembler). Since then we saw new tools and options:
Common misspellings for words used in this page include addres adn adres adress againnst agains agaisnt aganist agianst aginst ahev ahve allready allthough alreayd alsot altho althought altough alwasy alwyas amke amoung amung anbd anual aplication appeareance appearence apperance applicaiton apprearance aquisition archetecture architechture aready artical artice articel asign aslo asociated assoicate assoicated asthetically attendence availaible availble availiable availible avalable avaliable avilable bakc basicaly basicly bcak bedore befoer beggining begining beginnig beleive beleived belive belived beng benifit betwen bewteen buisness busineses busness bussiness caperbility cmoputer collegues comany comapany concidering constanly consttruction constuction consulant controll contruction coputer coudl currenly decribe delevopment desgined dessigned developement develpment devolopement diferent diferrent differnt diffrent discribe dissappointed doccument doccuments doens dowloads driectly effecient efficent ened especialy ethose everthing excelent excellant exelent exellent expecially eyar eyars eyasr facilites fianlly fidn finaly fomr foudn frome ganerate haev halp heterogenous hten htere htey htis hvae hvaing hvea hwihc hwole implimented importamt inbetween inclreased includng inctroduced incuding indepedence independance independece indipendence inital inlcuding instuction intergrated intergration interpet intial intrduced intrest introdued intruduced inudstry issueing itnroduced iwll iwth jstu jsut knowlege laguage lastr levle liek liuke lsat maintainance maintainence maintance maintenence mkae mkea monts moreso mroe naturaly naturely naturually nowe nto oftenly omre onyl oportunity opprotunity otehr owudl performence populare probablly probaly procedger proceedure processer proffesional proove puchasing qtuie quicklyu qutie raelly realy realyl recquired referiang refering reguarly regularily relaly relatiopnship remeber requred runing runnung senarios severeal shoudl shoudln similiar simmilar smae smoe soem sofware sohw somtimes sould specfic specif startegy statment stradegy stucture stuctured stuggling sturcture sytem tahn taht tath teh tehy tghe thast theese ther theri thgat thge thier thn thna thne throrough thsi thsoe thta thyat tiem tihs timne tiome tje tjhe tkae twpo tyhat tyhe typcial uise usally useing usualy ususally vell verison vetween veyr vrey vyer vyre wass watn weas wehn whant whcih whic whihc whith whlch whn wich wiew wih wiht wille witht witn wiull wnat wohle wokring worls woudl writen wroking ws wtih yearm yeasr yera yeras yersa ytou yuo.