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
recurring maid service Arlington Heights ..The research in the field of Natural Language Processing usually... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
The Windows registry is a huge database that ensures normal... Read More
Now that spyware is the single most dangerous threat to... Read More
Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More
With the advent of 'Service Pack 2' for Windows XP... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
Small can be beautiful! Working with Knoppix for the past... Read More
How would you like to prevent spyware and adware from... Read More
Once a business idea is selected, it is highly recommended... Read More
I have yet to see a business that, sometimes in... Read More
In this small article we will show you the possible... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Not all of us have the luxury of working both... Read More
Following tips help you to learn a software in lesser... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
If you have been running Windows XP for a couple... Read More
Bill of Lading is required report for Logistics and Freight... Read More
Since technology changes so quickly, it is hard to begin... Read More
Have you ever noticed that when you look at your... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
There are certain pluses and minuses in both cases and... Read More
Today's business world is fast-paced. No matter what it is... Read More
While paper labeling CDs and DVDs may appear to be... Read More
If you are software developer or database administrator - we... Read More
insured cleaning company Highland Park ..Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
This article illustrates the best practices to improve the performance... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
We all take the computer for granted. I mean, all... Read More
Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
Follow the steps below to quickly design, generate, and deploy... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
You've finally created databases that you can actually use to... Read More
We live in a post-industrial age where information is the... Read More
Homeland security, airport security, Internet security ??" these days we???re... Read More
Now is the time to look at an alternative to... Read More
Finally, you have some time to personalize your desktop with... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Once upon a time not so long ago, there was... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
I like my software simple. If it's too complex or... Read More
Your computer cost you from hundreds to thousands of dollars,... Read More
Considering whether or not your software company should hire a... Read More
It's all about turn times in the eMedia industry! The... Read More
Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More
Google Inc. has launched a new software package that allows... Read More
It's not very often I get excited about a software... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
Software |