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
![]() |
|
![]() |
|
![]() |
|
![]() |
Costs of fleet maintenance software can vary widely. It is... Read More
Looking at all the ads which promise to get rid... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
In this small article we will be looking at the... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
Ad-Aware and Spybot are probably the two most well known... Read More
When Windows fails to boot it is normally caused by... Read More
We are in a transition phase in the Managerial Administration... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
It is really interesting that a bug can create problem... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Executive SummaryAn effective plan for entering, cleaning and updating the... Read More
With any good luck and a good amount of hard... Read More
When Great Plains Software introduced the first graphical accounting application... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
In this short FAQ style article we would like to... Read More
Are you one of those people that keeps track of... Read More
Are you a whiz at calculating financial information? Not the... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
In order to implement VLANs in a network environment, you'll... Read More
It is a well known fact that Java as a... Read More
There are two approaches for application integration:? Programmer's approach ?... Read More
Trying to figure out a stream in banning one email... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
Not all of us have the luxury of working both... Read More
If you copy something from a Web site or elsewhere...... Read More
The vast majority of us will have, at some point,... Read More
Crystal Reports is the most flexible tool on the market... Read More
When Great Plains Software was designing and developing Great Plains... Read More
The software giants don't do everything and don't always produce... Read More
If you have been running Windows XP for a couple... Read More
There are many commands that are used in linux on... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
Imagine something that follows you home and sets itself up... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
In order to implement VLANs in a network environment, you'll... Read More
Fortunately one of the most common reasons cited for the... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
When Windows fails to boot it is normally caused by... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
It could just be me, but my experiences with document... Read More
In the real world a "fire wall" is a fireproof... Read More
Do you want to get quality software at a reasonable... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
Linux essentials:It's free for download but you have to pay... Read More
Our hosted solution allow you to run your own search... Read More
Since technology changes so quickly, it is hard to begin... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
The java programming language is becoming more and more popular... Read More
Bill of Lading is required report for Logistics and Freight... Read More
If you are software developer or database administrator - we... Read More
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More
What is a Web Database?A web database is a database... Read More
In the early days of the personal computer, we're talking... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
Should one use Windows Update?This topic has good and valid... Read More
If you copy something from a Web site or elsewhere...... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
User interfaces and accessibility are some of the most important... Read More
MS CRM is very close to document workflow automation, including... Read More
Software |