Microsoft Great Plains is now targeting large and midsize businesses and being matured ERP has advanced, but still very simple in use modules and features: Lockbox Processing for Accounts Receivables, Customer/Vendor Consolidation, Multicurrency etc. We'll try to cover these features in the series of small articles to help decision maker and end user understand the feature and how does it work to make a decision to purchase additional nice modules. In our opinion large corporation, which had to use ERP with rich functionality in the past, doesn't have to do it in our new time. There are few reasons to switch to cheaper ERP, the most important are: database platform reliability improvement ? nowadays MS SQL Server does excellent job and has most of the former instability and maintenance issues resolved. The second reason ? MS Windows server is now close to be considered as a solid rock and you do not have to reboot it on the regular basis to fix all the types of "memory leaks", etc. OK, lets review Lockbox processing:
? Customer Matching. This is rather the question about generic lockbox application ? which basically imports text file, received from your bank and matches them with customer invoices, debit memos and miscellaneous charges. The question typically sounds like this ? in our Great Plains CustomerID is different from bank customer ID. This is right, but each check has Bank Account Number and Bank Routine Number, identifying the customer, all you need to do is ? carefully review first processing and enter this customer info, or open it here: Cards>>Sales>>Lockbox Bank Details ? and next time you get check from this customer ? lockbox will catch and identify it. This is true even in the case of hand written check.
? Invoice Number Matching. This is a bit tricky question, and you can't catch invoice number from hand written check. However when we are talking about large businesses ? these checks have invoices printed. If you bank has so-called Automatic Clearinghouse (ACH) lockbox file format ? it can provide invoice number line if the check is issued by corporate or midsize established business. In the case of ACH header will have prefix 6 and line prefix 4.
? No Invoice Number Matching. This is still OK if you have a lot of small customers with one or few outstanding invoices. In this case ? use autoapply method. You can have variety of apply criteria: None, Document Number (when you have ACH), Due Date/Oldest Document, Due Date/Oldest Invoice (other than invoices you apply manually), Document Date, Specific Invoices (and you specify them in the list)
? Additional Considerations. Virtually if you have corporate account in any bank ? lockbox processing module does the job ? because you map lockbox file at your will in Lockbox Maintenance screen: Cards>>Sales>>Lockbox
? Customization Options. Lockbox is Dexterity piece, so it is in the hand of Dexterity Developer, if you need to improve it for your corporation. VBA Modifier and Continuum are also available. Also feel free to use new tools, such as Extender or eConnect.
Good luck and you can always seek our help in customization, implementation, integration and support. Call us: 1-866-528-0577 or 1-630-961-5918, help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Continental Europe, Russia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer
expert residential cleaners Park Ridge ..If you're online using a dialup Internet connection, you'll probably... Read More
All your software is stored on a hard-drive. But how... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
This article will not attempt to advocate the use of... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
I have yet to see a business that, sometimes in... Read More
Fundraising software lets you connect with donors in a way... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
Some companies that are in need of fleet management may... Read More
The objective for Zandi Digital is to make available clever... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
I completed an experiment recently. I wanted to find out... Read More
Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
You probably didn't casually invite, or extend a formal attendance... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Scrapbooks are very popular these days. I think that almost... Read More
green cleaning service Park Ridge ..Programming Help for BeginnersWe write programs to instruct computers. When... Read More
Program Flow is what you think it is. How the... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
Executive SummaryAn effective plan for entering, cleaning and updating the... Read More
Viruses and spyware usually show up on your computer one... Read More
Since its release in 1987, QuarkXpress had made an immediate... Read More
It is possible that if one avoided all sources of... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
When you visit department stores and see that majority of... Read More
When you own a small business, time is money. And... Read More
With the advent of 'Service Pack 2' for Windows XP... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
ERP Consulting industry is on the way to serve clients... Read More
We all already got used to computer monitoring both at... Read More
The Internet is reshaping every form of communications medium, and... Read More
Is your PC is slow and wimpy? Then you need... Read More
In the early days of the personal computer, we're talking... Read More
Ad-Aware and Spybot are probably the two most well known... Read More
While Ukraine is becoming a new popular IT outsourcing destination,... Read More
Designing without tables by using CSS layouts is fast becoming... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Do you want to get quality software at a reasonable... Read More
C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
Software |