Software Information |
|
Accounts Payable: A Powerful Document Management and Workflow Solution
Accounts payable is just one area of office management where problems arise because of the sheer complexity of transactions, and the vast amount of paperwork that is generated. A disproportionate amount of time and administrative resources is consumed just getting invoices approved for payment. The problem becomes compounded when invoices are lost when being circulated for clearance and even more time is then lost in the retrieval process. Typically these documents include purchase invoices from suppliers, sales invoices to customers and purchase orders generated by customers. Even if missing documentation is successfully recovered from the system, the delay will have caused major inconvenience. If it is not recovered, the effects on business are routinely disruptive, and in extreme cases, disastrous. TokOpen is a powerful document management and workflow software solution that goes far beyond conventional document capture and storage. Uniquely flexible, the package allows systems to be configured to meet customers' specific needs. How TokOpen works Automated data entry allows invoices to be scanned, indexed and stored in the system, avoiding time-consuming manual entry. Automated reading can take two forms: either header reading (reference number, client name and amount); or full line item reading. Alternatively, invoice information can still be entered manually if required. Once in the system, invoices are electronically routed through a workflow process that includes notifying all authorised staff when an invoice is waiting for their approval. Online reports are automatically generated where invoices awaiting approval are delayed or missing. These reports are configurable, so they can be set up to cover other factors critical to successful payment completion. Internal security is built into the system, and access controls ensure that only authorised staff can open invoices or related documents. Audits are automatically maintained on all documents as they progress through the system, so each time they are accessed or amended, time, date, identity and activity details are logged. Where associated documents are in the system, these are stored in the same file alongside invoices so they can be located quickly and easily. Access can be gained from other systems, in which case folders and documents are displayed in a standard Web browser. Invoice approval is integrated with the rest of the accounts payable process, and invoices can be accessed via systems like SAP or JDE. TokOpen in action ? a case study TokOpen is currently being used by a major Japanese multi-national, with multiple office locations in the UK. One office processes purchase invoices for all the other offices in the UK, and they are initially processed using the Oracle Financials system. For all new invoices, a barcode is generated and attached to each document. An Accounts Clerk then scans all documentation into TokOpen. This is carried out from a dedicated scanning and indexing workstation, using TokOpen Sorting Office. All documents are stored here and then uploaded on a daily basis to the TokOpen server, which is at another UK office location. Sorting Office reads the barcode and then looks up the original data in Oracle to extract additional index data such as invoice number, supplier number and site code. Standard browser access Most documents are retrieved via the users' standard Web browser, using TokOpen Web, and a total of 260 staff use this means of access. A restricted number of users also have access to the TokOpen Desktop, and access is provided to individuals based on an approval hierarchy. Invoices are handled using an efficient electronic workflow process. Once scanned, Invoice Status is set to Invoice Received. TokOpen ensures that users can only view documents that have been assigned to them in a particular workflow. A strict authorisation hierarchy is in place, based on the size of the invoices being handled. So if a member of staff attempts to authorise an invoice that exceeds their authorisation limit, TokOpen automatically routes it to a staff member at the next authorisation level. This continues up the authorisation hierarchy until the invoice reaches a member of staff who has had clearance to sign off that invoice value, and payment is completed. TokOpen brings together powerful and efficient document management, with easy-to-use, Web-based access. Tokairo is an international provider of Document Management (TokOpen) and Education systems solutions (TokAM). Tokairo has its headquarters in the UK, with a sister company in the USA responsible for the Americas. http://www.tokairo.com REF=TO2EZ
|
RELATED ARTICLES
Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer �Microsoft Business Solutions stakes on Microsoft Great Plains as main Accounting/ERP application for US market.� At the same time it seems to be staking on Navision in Europe and has Axapta as high end large corporation market competitor to Oracle, PeopleSoft, SAP, IBM.� This article is brief review of Microsoft Great Plains integration with Microsoft Access.� This is also applicable to Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary - DYNAMICS.DIC and runtime DYNAMICS.EXE) and Great Plains Standard on MSDE� or MS SQL Server. If you are developer who is asked: how do we implement� Great Plains integration/interface� with your MS Access-based� system ? read this and you will have the clues on where to look further. Great Plains Integration Manager - this is rather end-user tool - it is very intuitive, it validates 100% of business logic, brings in/updates master records (accounts, employees, customers, vendors. etc.) brings in transactions into work tables.� The limitation of Integration Manager - it does use GP windows behind the scenes without showing them - so it is relatively slow - you can bring 100 records - but when you are talking about thousands - it is not a good option.� By the way you can program Integration Manager with VBA.� Microsoft Access is ODBC compliant and so you can do direct Integration Manager query to MS Access eConnect ? it is type of Software Development Kit with samples in VB.Net.� Obviously the development environment should be Visual Studio.Net.� eConnect will allow you to integrate master records - such as new customers, vendors, employees, etc., plus you can bring transactions into so called Great Plains work tables (eConnect doesn't allow you to bring open or historical records - you need to post work records in Great Plains, the same limitation applies to Integration Manager above)� eConnect is rather for ongoing integration.� It was initially created for eCommerce application integration to Great Plains. SQL Stored Procedures.� Obviously you have unlimited control and possibilities with SQL queries.� You need to know Great Plains tables structure and data flow.� 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.�� Do not change existing tables - do not create new fields, etc.� Also you need to realize that each GP table has DEX_ROW_ID - identity column.� Sometimes it is good idea to use inbound/outbound XML in the parameters - then you can deploy web service as a middle party between two systems. Data Transformation Services (DTS) ? Good tool for importing your third party data into staging tables in GP - then you can pull them in using either stored procs of Integration Manager.� You can also deploy this tool for EDI export/import.� You can have DTS working with Linked Server - SQL Server Construction for linking to Microsoft Access Great Plains Dexterity Custom Screens.� Sometimes users prefer to have seamlessly integrated into GP interface custom screens - for parameters settings and initiating integration.� Dexterity is a good option, however remember - it is always better to create new custom screen versus customizing existing one - due to the future upgrade issues.� Also - Dexterity is in phasing our by Microsoft Business Solutions. Modifier/VBA custom buttons on the existing screens - �alternative to Dexterity is you are comfortable with VBA and ADO. SQL Linked Servers ? you can do direct SQL queries to other ODBC compliant platform via SQL Linked Server (including Microsoft Access) - you may need to familiarize yourself with OPENROWSET command in Transact SQL.� This is also good option if you need cross-platform Crystal Report - pulling data from SQL Server and third party databases on the same report. Warning - do not place existing GP tables into Replication! - you will have upgrade issues. Happy integrating!� if you want us to do the job - give us a call 1-866-528-0577! [email protected] Why Java RDBMS? It is a well known fact that Java as a programming language set off a new paradigm in the software industry. Suddenly, every software programmer worth his salt was amidst software jargons like 'Platform-Independence', 'Cross-Platform-Deployment' and 'The Java Virtual Machine'. In fact, it did not take long for Java to usurp the 'most sought after status' from many software languages, and become the most preferred tool for creating software; especially software for the web. As the recent trends in the industry show, Java is set to achieve an undeniable position as the most preferred software programming language for a long time to come. It is indeed Java's credit that many prominent vendors who tried to emulate the capacities of Java, failed miserably in the endeavor. Microsoft Great Plains in Metal Distribution: Implementation & Customization ? Consultant Overview Microsoft Business Solutions Great Plains serves to the wide spectrum of horizontal markets and could be also considered as generic ERP/MRP/Accounting platform for light and advanced customization to fit verticals. In this small article we describe distribution sector with the example from metal distribution - Dealer/broker of industrial nonferrous by-product scrap, de-tins and de-oils industrial by-product scrap and finished parts. It might sound a bit complex ? but we think this is typical for this horizontal market niche. The language of the article is targeted to primarily technical consultant and in-house programmer/software developer. In our opinion ? ERP applications should be implemented with the leveraged help and support of internal IT people ? we are entering into the epoch of technical specialists and IT departments ? smile. Great Plains Customization ? Programming Auto-apply in Accounts Receivable Microsoft Great Plains is one of three Microsoft Business Solutions mid-market ERP products: Great Plains, Solomon, Navision. Considering that Great Plains is now very good candidate for integration with POS application, such as Microsoft Retail Management System or RMS and Client Relation Systems, such as Microsoft CRM ? there is common need in Great Plains customizations and integrations, especially on the level of MS SQL Server transact SQL queries and stored procedures. RSS: Get Notified When Your Favorite Websites Are Updated RSS (Really Simple Syndication) is a way for a site to publish it's updates. RSS readers can read these notifications and display a listing of the updates to you, the user. How to Upgrade Dexterity Customization ? Tips for IT Manager If you have Microsoft Great Plains and support it for your company and have light or heavy Great Plains customization, written in Dexterity ? you need to know your options in upgrading Great Plains or migrating it from ctree/Pervasive to MS SQL/MSDE. Great Plains Dexterity is proprietary programming language/environment, which was created in early 1990-th to provide platform / database / graphical interface independence for Mac and Windows based Great Plains Dynamics.� Today it is legacy and Microsoft Business Solutions is phasing Dexterity out. However Great Plains 7.5 and even 8.0 is Dexterity based application, so you have to deal with it and it's customization. � Good news.� Prior to version 7.0 Great Plains had plans on expanding GP functionality and so was changing tables structure ? forcing Dexterity customization to be analyzed and partially rewritten with each upgrade.� Not any more ? GP structure stays the same ? Microsoft is doing new modules acquisition and unifying it's graphical interface to move all it's ERP packages: Great Plains, Solomon, Navision and Axapta to web-based Microsoft Business Portal. � Still pain.� Dexterity has possibility to customize existing Great Plains screens, so called Alternative Great Plains forms.� This was upgrade problem in the past and it stays now ? there is no way to do it in house (until you are willing to pay for full-time internal developer ? who is usually in the learning curve).� You got to bring in consultant. Recommended approach.� You should have the strategy to migrate Dexterity customization to SQL, Crystal Reports, custom web publishing ? Visual Studio.net and slowly abandon Dexterity customization SQL Stored procedures - performance improvement.� Consider replacing dexterity data manipulation with SQL stored procedures.� Dexterity is cursor-driven language and it is not efficient when processing huge datasets. Crystal Reports.� Take advantage of open and leading technology.� Crystal Reports will eliminate the need in the future for painstaking Dexterity reports upgrade.� Base you Crystal report on the SQL view or stored proc Do direct web publishing off your GP database.� Use Visual Studio ? it is easy to find specialists and have them in staff.� We are in the World when web publishing is very easy. Good luck 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! [email protected] What to Do if All Screensavers Fun is Grayed Out? Finally, you have some time to personalize your desktop with an interesting screensaver. But wait... What's that? Why in the world the system prevents you from doing that? The screensaver controls are grayed out or, even worse, the whole Screensaver tab is missing from Display Properties. Don't panic! This article will help you change things for the better. Business Plan Software Review: Ultimate Business Planner? One of the main reasons business owners and entrepreneurs use business plan software is to simplify building their financial models. Even with an explosion in business plan software packages on the market today, "doing the financial projections" is still often cited as the most difficult part of completing a business plan. Yet, software can still simplify financial forecasting. Microsoft CRM Messaging through Lotus Domino eMail Server - Balanced Solution Microsoft CRM and IBM Lotus Notes Domino seem to be taking completely different paths and if company is Microsoft oriented - we see MS CRM, MS Exchange, MS SQL Server, SharePoint, etc. In the case of Lotus Domino - it is opposite - Lotus is corporate Information Media and could technically play CRM role with internal messaging coming through Lotus Domino server. However realities of modern corporation give us multiple examples when Microsoft CRM and Lotus Domino should coexist in compromise. There are several reasons why corporation doesn't like to stick to one platform: Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management Let's first look at your ERP system selection (without Retail Solution). Your options are: Spyware Definitions List The adware and spyware definitions list is very long. But the definitions listed below are the most common ones. This is a glossary of spyware facts and terms so you'll know what these malicious programs are and what they can do to your computer. Groupware: Avoid the Ad Hoc Shuffle Groupware Removing Incoming Email in MS Exchange, C# Example The purpose of one of our projects was MS Exchange handler for processing incoming email. What is a Document Manager without Version History? Document Manager and Version History Basic Tips and tricks for Windows XP Running Applications in Compatibility Mode With Windows XP, you can run programs as if though they were being run under a different operating system. (This is known as "emulation".) Simply right-click a shortcut, select "Properties" and then check "Run in compatibility mode" and select the operating system you wish to make the program believe it is being run under. This fools or tricks the program into thinking you are really using a previous version of Windows, such as NT, 2000, 98, or 95. This is especially useful for certain games that won't run properly. Be careful *not* to use this with certain system utilities, such as antivirus, defrag, registry, and disk tool applications. Microsoft Great Plains Implementation ? Overview for IT Director/Controller What is installation in the language of technology?� Installation has server and client sides.� Server side - Installation creates security environment (logins) on MS SQL Server or MSDE, creates system database - DYNAMICS and then company databases.� All these tasks are performed by Microsoft Great Plains Utilities� Workstation side - workstation installation copies the client side application, installs current version of MDAC (we need SQL ODBC driver - please check documentation on ODBC DSN setup), registers the application.� If you plan to run Great Plains Utilities from the workstation to create server side (see above) - you need to check Install Client and Server Components What is following implementation?� Implementation requires combination of technological and accounting skills System Setup - you should refer to GP documentation.� In general setup consists of Company information, General GL/AR/AP/Payroll setup, User classes, Customer/Vendor/Employee classes�to name a few Master Records - you should either use integration tools, such as Integration Manager, SQL queries or have users to type in all your GL Accounts, Customers, Vendors, Employees . Beginning Balances - this is recommended approach - you place aside the old accounting application for querying the historical data and enter beginning balances� in Great Plains GL, AR, AP, SOP, POP, Payroll.� When you have balances in the system you are ready to use it in production Historical Data conversion - this is optional, in order to do historical data conversion you need to know basic Great Plains tables structure (Setup->Tools->Resource Description->Tables Structure).� This is similar to surgery - so you probably need outside consultant to help you.� If the volume of historical data is small - you can deploy Great Plains Integration Manager and then post the records in the modules. User Training - we are just listing this item - it is up to you to decide on the way to train your users Using Two Systems in Parallel - this is recommended.� You should print the reports from both systems during this test period and compare the results Customization - typical areas of customizations: Invoice form, Crystal Reports, pulling info from multiple databases, including Great Plains database, Great Plains forms modification with Modifier/VBA, Great Plains Dexterity forms and logic customization, integration with CRM, RMS and other business systems, web publishing from Great Plains tables, EDI with your suppliers, SQL Data Transformation packages Do I need consultant?� We strongly recommend you to use consultant in the following cases You have identified the need for Great Plains Dexterity customization You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools You are doing migration from Great Plains Accounting to Microsoft Great Plains You have to create a lot or ReportWriter Modified Great Plains Reports You have old version of Great Plains: Dynamics or eEnterprise 6.0 or prior - in this case you can not appeal to Microsoft Technical Support - it is discontinued Your Great Plains has more than 20 users in this case the mistake may lead to serious business problems You don't have support for your old Great Plains - then you have to select your Microsoft Business Solutions Partner and pay for the annual support/enhancement plan - you will get new registration key and will be ready for the upgrade Good luck with installation,� implementation, upgrade 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! [email protected] Microsoft Great Plains Implementation in Russia ? Overview for Consultant Microsoft Business Solutions Great Plains is very popular ERP platform in the USA, Canada (including French speaking Quebec/Montreal), U.K., Australia, New Zealand, South Africa, Middle East: OAE, Egypt, Arabia, Latin America. Former versions ? Great Plains Dynamics/eEnterprise was also popular in Europe: France, Poland, Russia. When Microsoft acquired Navision Software ? and handed it out to its subdivision: Microsoft Business Solutions ? we saw some geo-strategy changes. Navision, the leader on the European mid-market and successfully overcoming such localization barriers as language translation, adaptation to country-specific taxes and payroll taxes ? was chosen as preferred or the only recommended solution for emerging markets. In Russia we saw dramatic situation, when multiple Great Plains Dynamics/eEnterprise resellers went out of business. At the same time, Russia is huge and lucrative market for ERP/MRP applications and we envision large number of multi-national companies, having GP as their Headquarters chosen solution and who needs Great Plains to be implemented for Russian subsidiary. Here are the implementation highlights for you: Software Review: Xsitepro Total Site Management Software It's not very often I get excited about a software program, but today I'm so excited I just had to tell you about Xsitepro, the top tool for Internet marketers. In particular, those who have been using HTML applications programs like Dreamweaver and Frontpage to produce their Internet media will find this program revolutionary in that it can at least halve your time for site development. The Tools and Features of Adobe Photoshop Adobe Photoshop is one of the world's leading graphics editing programs, developed by Adobe Systems. Available on Mac OS or PC, Photoshop is used as one of the leading image design programs for the World Wide Web. The most recent version of Photoshop, or Photoshop CS2, "bridges" between other Adobe products such as Image Ready, Illustrator, Premiere, After Effects, and Encore DVD to produce professional videos and DVDs. Photoshop uses a file format called a .PSD or .PDD to store multiple layers of an image. Recently Adobe released a program called Photoshop Elements in order to give a less expensive version of Photoshop with many of the same features. Although Adobe Photoshop is used primarily in doing touch-up for digital photos, it is also used for creating designs for web pages and professional companies. Microsoft Great Plains Jewelry ? Implementation & Customization Overview Each Industry and market niche has business specific and unique requirements to ERP/Accounting System. Microsoft Business Solutions Great Plains is ERP platform, ready for third party modules additions and customizations, plus being SQL Server-based system it opens you wide spectrum of integration options and tools. In this small article we'll give you Microsoft Great Plains implementation and setup highlights, typical for Jewelry retail network. |
home | site map |
© 2005 |