Software Information |
|
Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes
Microsoft Great Plains fits to majority of industries, in the case of Chemicals & Paint you should consider implementation with balanced approach of utilizing existing Great Plains standard module and light customization and reporting with Great Plains Dexterity, MS SQL Server stored procedures, Modifier/VBA and direct .Net publishing from Great Plains Company database. Let's consider industry requirements and their implementation in Microsoft Great Plains: ? Raw Materials Labeling. Microsoft Great Plains ReportWriter supports Barcode fonts and you can print out barcodes off the inventory control items list. You should modify existing report or create new report ? in the case of new report ? you should train GP users to change report restriction to print labels for your raw materials batches ? Quality Check & Bin Locations. Great Plains Inventory Control (IV) module supports bins and you can allocate items from specific bins, quality check should be implemented as either light Dexterity customization in IV or set of Crystal Reports to print checklists ? Quarantine/Blocked inventory. In Great Plains you deploy sites and when you need to quarantine your Inventory ? you move it into quarantine site. The other way is to quarantine bins ? Accident Procedure Sheet (APS) ? this and others compliance reports should be printed off the IV tables via Crystal Reports ? Elements of Process Manufacturing. Catch Weight and others scenarios should be realized in the form of light Great Plains Dexterity customization for Bill of Materials module (BM). Catch Weight sometimes should be complemented with approximate input material unit weight variation control. ? Logistics & Warehouse Management. If automated shipment is the most business processes critical requirement ? you can implement Supply Chain solution, integrated with Microsoft Great Plains. If you are looking for budget solution ? we recommend you light modification in Sales Order Processing (SOP) and Purchase Order Processing (POP) modules to automate Shipping/Receiving with barcode scanning. ? Customer Orders. Here you should consider EDI (if you are large corporation) or eOrder or other simple internet ordering solution. In the case of custom internet application you can deploy .Net web publishing ? Microsoft Great Plains data sits on Microsoft SQL Server: SQL Server stored procs with ADO.Net Good luck with implementation, customization and integration and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 866-528-0577 or 630-961-5918! [email protected] Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in California, Minnesota, Illinois, Washington, Florida, Arizona, New York, New Jersey, Virginia, Georgia, Louisiana, Texas, Canada, UK, Australia, Brazil, Germany, Russia
|
RELATED ARTICLES
6 Easy Steps for a Smoother CD/DVD Order It's all about turn times in the eMedia industry! The speed with which your vendor can get your CD or DVD project completed is vital to many customers. However, responsibility for these projects meeting their completion dates starts with the customer and ends with the vendor. It's a partnership that shares the responsibility. Just follow the 6 easy steps below: 10 Things You Can Do With Photoshop CS2 That You Couldnt Do Before Now Is Photoshop CS2 worth the upgrade? You bet it is! Here are just 10 things you can do with this fantastic new version of Photoshop that were impossible (or difficult) to do with previous versions: Microsoft CRM Implementation ? Fundamental CRM Principles Revision Microsoft CRM is relatively new player on the now becoming traditional CRM software applications market. We would like just to mention shift in the technical conception ? Microsoft CRM is committed to Windows and Microsoft components: Exchange, Active Directory, SQL Server, etc (while traditional CRM applications, such as Siebel were biased toward multiplatform compatibility: Unix, Oracle, Windows, SQL Server) and move up to business logic paradigm shift. Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS) are getting new market share due to the Microsoft strong marketing campaign. Both products: Microsoft Great Plains and Microsoft RMS are coming from the same Microsoft subdivision - Microsoft Business Solutions (MBS), however due to the fact that both products were bought by Microsoft from different vendors, the integration between the two is not an easy thing. At this time MBS has RMS integration on the General Ledger and Purchase Order level into Great Plains out of the box. This integration has some advancements in comparison to old product: QuickSell, but it is still GL and PO only. We do understand the need for midsize and large retail companies, structured as clubs and selling on account to their members to have more adequate integration when you can synchronize your Sales information and have robust Great Plains reporting. There is the product on the market, which is integration on the Receivables Management level from RMS to Great Plains, written by Daniel Sionov and Andrew Karasev and maintained by the alliance between LightEdge Solutions (www.lightedge.com) and Alba Spectrum Technologies (www.albaspectrum.com). In Alba Spectrum Technologies we actually do coding and product tuning for specific client needs. Microsoft Great Plains Reporting ? Overview for Developer Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it.� Now it is targeted to the whole spectrum of horizontal and vertical market clientele.� Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.� There are several reporting tools available and you definitely need to know which one to use for different types of reports. If you are developer who is asked: how do we create report for Microsoft Great Plains ? read this and you will have the clues on where to look further. Great Plains Report Writer (ReportWriter) ? this is built-in reporting tool.� All the original report in Great Plains are written in ReportWriter.� ReportWriter itself is Dexterity module.� You should use this tool if you would like to modify existing Great Plains reports, such as Blank Invoice Form - here you can place your company logo, change the positioning, fonts, colors, etc.� ReportWriter will allow you also do new� reports - simple option� if you want to export all the records from one Great Plains table - use it.� New report, however doesn't have interface where you would enter parameters - so it is not useful for real custom reports.� Another limitation of ReportWriter - you can not do cross-modules report - when you need sales and purchasing info on the same report for example. FRx.� This is excellent tool when deal with financial reporting - it works on the General Ledger level (Balance sheet, P&L, Cash Flow Statement, etc.).� It also allows you to do multiple companies consolidation - when you do consolidated Balance Sheet (with inter-companies transactions elimination). Smart List - Export to Excel ? this is nice feature in Great Plains - you could create a list with simple criteria and then export it to Excel. Crystal Reports.� It gives you unlimited functionality.� Obviously flexibility requires you to know Great Plains table structure:� Launch Great Plains and go to Tools->Resource Description->Tables.� Find the table in the proper series.� If you are looking for the customers ? it should be RM00101 ? customer master file.� If you need historical Sales Order Processing documents ? they are in SOP30200 ? Sales History Header file, etc.� Create ODBC connection to GP Company database.� Use the same technique as when you create standard ODBC connection for GP workstation ? but change default database to targeted company database.� Create SQL Query to probe the data ? we always recommend tuning your query and see that you are getting adequate results ? in any case ? Crystal Report is just a nice tool to show the results of your query. Direct Web Publishing off Great Plains databases ? yes - it is easy now with Visual Studio.Net and you can hire good programmers.� This is good - Microsoft Business Solutions products: Great Plains, Solomon, Navision and Axapta will be integrated into so called Microsoft Business Portal - which will have web interface - you can get the idea if you look at Microsoft CRM web client - so direct web publishing is good taste. SQL Queries.� If you have SQL background - this is great field for you.� You know - with properly formatted SQL query you can realize simple EDI export/import for the integration with legacy systems. Happy designing!� if you want us to do the job - give us a call 1-866-528-0577! [email protected] An Easy Way to Deal with Email Viruses and Worms If you feel intimidated when someone tries to teach you something new on the computer, this article is for you! Microsoft Update - 5 Reasons to Update Service Pack 2 Microsoft released Service Pack 2 (SP2) for the Windows XP operating system back in August (2004), representing significant improvements in many areas, especially system security. For those people that are still unsure whether they should update to it, the following five reasons may help make the decision easier. What To Do When Windows Wont Boot When Windows fails to boot it is normally caused by you installing a program or device and it has caused a conflict with one or more other programs. Lowering The Risks In Developing Do-It-Yourself Software Projects Mike Dunville* had a decision to make. As the new operations manager for Alpha Staffing, he wanted to make a difference at the dynamic staffing firm. The principals of the firm had charged him with making the day-to-day operations run smoothly and efficiently while they concentrated on growing the business in today's challenging economy. Editing Your Photos Using Microsoft Picture It Publishing Platinum 2002 - A Great Dinosaur I started using PIP (Picture It Publishing) Platinum 2002 right after I got it in a bundle with my HP Pavallion N5295 Notebook more than several moons ago! Linux Vs. Windows This article will not attempt to advocate the use of Linux over Windows or vice versa. I will try to present the differences and similarities between Linux and Windows in a fair manner. SSH (SCP) Send Files from Windows to Your Linux Box Not all of us have the luxury of working both at home and at work on a UNIX based system. However that doesn't mean you can't transfer files safely and securely between the two systems. Is Your Family Protected? When you think about Security, what do you think of? We all have one device or another to assist in keeping us safe. We have pad locks and security systems to safe guard our home, alarm systems to protect the equipment in our cars, parental controls on our cable TV and satellite accesses. We even have ways to protect our loved ones from computer invasions. But are we protected enough, are we using the best devices to combat the unwanted and dangerous intrusions, not to mention keeping our family from stumbling across those out on the internet? Let's face it, without the proper soft ware to protect your computer, you are at risk every time you connect to the internet. There are the viruses, the Trojans and unwanted spam, not to mention the chat rooms where millions fall victim of on-line predators, and let's not forget the #1 problem on the internet, pornography. You may be saying, but I have the best anti- spy ware money can buy and my internet service provides parental controls. Here's the underlying question: How effective are they? Statistics show that 95% of internet users don't have the adequate security to prevent attacks or control the content the computer user can access. The average computer is scanned by online intruders on average of 12 times a day. More and more victims are realizing the importance of these safety devices. The newest trend for identity theft is to steal information and cash out, out side of the country making it impossible to trace and leaving the victims with nothing to replace the funds. What do I do, you ask? Let me begin with the basics. There are four steps to take into consideration. 1. Evaluate- There are diagnostic tools to find and identify dangerous threats to your computer. These tools are as simple as popping into you computer and scanning your hard drive. Threats are then identified with the proper recommended course of action to take. 2. Eliminate- Once the threats have been identified the obvious next step is to eliminate. These security tools help scan, eliminate and block threatening spy ware, annoying ad ware and cookies, damaging worms and Trojan horses. 3. Protect- Set up a barrier around your computer. This will keep intruders out and create a fire wall. This is the most effective way to defend you against hackers and avoid identity theft. 4. Control- This final step will create a peace of mind for you, with the knowledge that you can avoid potentially dangerous web sites. You can block undesirable websites as well as avoid ones that try to download spy ware onto your computer. So what's the next course of action? Find a security device that will cover these four steps and protect you from all of these hazardous things. There are even programs that will do this and automatically update every month to ensure added safety and avoid any new unknown danger. My advice, find them, get them on your computer to avoid any heartache that could happen. The average cost for these programs, to completely cover you computer, vary from $40- $120 depending on the collection of software you use. The products that will automatically update usually run $5 - $10 a month to give you the essential idea of, get it and forget it. Too many times we forget to update our securities and fall victim of these malicious acts. Don't wait, don't become a victim before you take action. What is the price for your safety? Microsoft CRM Lotus Notes Domino Connector FAQ Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being two groupware products from competing software development leaders, however could coexist within one organization computer network and even work together in collaboration. There maybe multiple reason why corporation would use both products: licensing, commitment to IBM Lotus Notes as legacy product, risk balancing ? staking on both Microsoft and Java/EJB/J2EE platforms, deploying Lotus advanced workflow to automate document management, etc. The need to synchronize MS CRM and Lotus Notes Domino databases is dictated by the ERP market and the connector is available. In this small article we'll answer on the frequently asked questions. Reduce Pop-ups and Annoying Ads There is many things more frustrating than surfing a website only to have your screen suddenly full of pop-up advertising or a cascade of new windows opening. There are so many intrusive kinds of advertising on websites that there must be a way to deal with them. Luckily for us there is a few programs out there that will help to reduce the amount of advertising that happens while you surf. 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: Examining the Substance of Studio MX To all web designers out there, this article is for you! I guess you already heard about Studio MX (I think so!) ? the ideal bundle for professional web designers, bringing together Dreamweaver MX for page design, Flash MX for animation and interactivity, and Fireworks MX for editing and optimizing graphics. With all these components, it certainly provides professional functionality for every aspect of web development. Microsoft CRM Implementation & Customization: MS CRM Fax Gateway With this small article we are continuing Microsoft Business Solutions CRM customization, development, modification, setup and implementation discussion. Internet Security Threats: Who Can Read Your Email? Before being able to choose a secure Internet communication system, you need to understand the threats to your security. 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. |
home | site map |
© 2005 |