Software Information

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing


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


MORE RESOURCES:

ABC News

Apple unveils software updates, new laptop
San Francisco Chronicle,  USA - 11 hours ago
The presentation included updates to the iLife and iWork software suites, a new 17-inch MacBook Pro with an 8-hour battery and a new digital rights ...
Video: Steve Jobs Weight Loss Due to Hormone Imbalance AssociatedPress
Apple's Macworld Surprise Is the Software PC Magazine
Summary: Software, MacBook Pro updates star in final Apple keynote Macworld
The Associated Press - Reuters
all 2,735 news articles


SAP Wants Oracle to Reveal Software, Support Profit Margins
PC World - 1 hour ago
SAP wants Oracle to reveal profit-margin information for JD Edwards and PeopleSoft software and support, according to a joint discovery statement filed this ...


BBC News

ITunes embraces 3-tier pricing, will remove anti-copy software
Los Angeles Times, CA - 12 hours ago
Apple also updated much of its software. The latest version of iPhoto scans for individual faces so computer users can label photos of friends or family, ...
Apple removes protection software from songs TourDates.Co.Uk
Apple changes iTunes prices; removes copy protection USA Today
Apple changes iTunes pricing CNNMoney.com
Bloomberg - Shiny Shiny
all 1,054 news articles


HEB Mexico adds price optimization software
Bizjournals.com, NC - 2 hours ago
HEB’s Mexico subsidiary will begin using a price optimization software program currently in use by its parent company. Supermercados Internacionales HEB ...


Macworld

IBM Lotus Delivers New "Social" Notes and Free Symphony Software ...
CNNMoney.com - 22 hours ago
At Macworld, IBM (NYSE: IBM) today announced the availability of Lotus Notes 8.5 collaboration software with social computing features for all Mac OS X ...
Macworld: IBM finalizing free Symphony office suite for Macs Computerworld
Lotus Notes 8.5 ships, free IBM Symphony suite coming MacNN
IBM unveils Lotus Notes 8.5 VNUNet.com
eWeek - Computer Business Review
all 45 news articles


ABC News

Macworld goes for the soft sell with budget-minded software
USA Today - 17 hours ago
Tuesday, the big news concerned 69-cent and $1.29 music downloads, and an upgrade to a $79 software suite. "In this economy, to focus on launching expensive ...
Feature: A Guide To iPhone Development In 2009 Gamasutra
Turning Technologies Announces ResponseWare Application Available ... Business Wire (press release)
Boingo Brings Wi-Fi Connections to Mac and iPhone Users Business Wire (press release)
all 225 news articles


Telegraph.co.uk

Indian Software Giant Admits Financial Wrongdoing
Washington Post, United States - 5 hours ago
The revelation shook India's stock market and sent shock waves across the country's booming software industry, while television commentators quickly dubbed ...
Satyam Chairman Resigns After Falsifying Accounts Bloomberg
Chairman of 'India's Enron' Resigns After Falsifying Financial Data FOXNews
Collateral Damage Feared From 'India's Enron' CNNMoney.com
Reuters India - Livemint
all 1,269 news articles


Plymouth software firm Paisley sold to Thomson Reuters
Bizjournals.com, NC - 1 hour ago
Paisley, a maker of risk-management and fraud investigation software, has been sold to Thomson Reuters’ tax and accounting business for an undisclosed ...


Times Online

Apple Unveils Software, MacBook At Macworld
CNNMoney.com - 23 hours ago
The first hour of the speech was dominated by updates to Apple's software line, which remains an important element for the company, but more as a driver to ...
Apple rolls out 17-inch MacBook Pro, new software, iTunes Store tweaks DVICE
Apple unveils raft of new Mac software Times Online
Apple updates iTunes, iLife, unveils 17-inch MacBook Bizjournals.com
CNN International - Sydney Morning Herald
all 279 news articles


New York Times

Data Analysts Captivated by R’s Power
New York Times, United States - 3 hours ago
R first appeared in 1996, when the statistics professors Robert Gentleman, left, and Ross Ihaka released the code as a free software package. ...

Software - Google News

home | site map
© 2006