Home » TIPS AND TRICKS BY MODULES » RM (Receivables Management)
Top Websites
- Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Dynamics GP Help
Over 1700 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 900 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 700 resources listed. - Microsoft Dynamics Partner Community Blog
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 500 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 400 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 400 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 400 resources listed. - eOne Business Solutions Blog
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Rose Business Solutions Blog New
Over 200 resources listed. - Dynamics CPM
Over 200 resources listed. - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - Victoria Yudin's Dynamics GP Website
Over 100 resources listed.Victoria Yudin - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 100 resources listed. - BKD Dynamics GP Insights Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Parent Category: RM (Receivables Management)
Links Sort by: Hits | References | Alphabetical
Automatic Aging for GP
http://mbsguru.blogspot.com/2009/04/automatic-aging-for-gp.html
The question came up on the Public GP Newsgroup about automating customer aging in GP. I recalled doing this for some customers in the past and found this method works well. GP calls a stored procedure called rmAgeCustomer to execute the Receivables Aging…
Posted by
Recommended byhttp://mbsguru.blogspot.com/2009/05/scheduling-jobs-in-sql-2005.html
http://msdynamicsgp.blogspot.com/2010/06/weekly-dynamic-run-ar-aging-from-sql.html
http://msdynamicsgp.blogspot.com/2009/05/scheduling-jobs-in-sql-server.html
http://msdynamicsgp.blogspot.com/2009/04/automatic-receivables-aging-for.html
http://msdynamicsgp.blogspot.com/2010/06/weekly-dynamic-run-ar-aging-from-sql.html
http://msdynamicsgp.blogspot.com/2009/05/scheduling-jobs-in-sql-server.html
http://msdynamicsgp.blogspot.com/2009/04/automatic-receivables-aging-for.html
AR Transactions - Printing by Batch
http://amllp.blogspot.com/2009/09/ar-transactions-printing-by-batch.html
Overriding Credit Limit Password
http://mohdaoud.blogspot.com/2009/12/overriding-credit-limit-password.html
Guys,
I found an interesting post in the newsgroup, the user wanted to override the credit limit password for predefined customers or classes using VBA, code below will run temporary runtime created macro to fill the password as required and proceed:
Private Sub ExtendedPrice_AfterLostFocus()
‘Fill you if condition here.
Set CompilerApp = CreateObject("Dynamics.Application")
Commands = ""
Commands = Commands & "local integer l_file_id; " & vbCrLf
Commands = Commands & "local string pathname; " & vbCrLf
Commands = Commands & "pathname = ""C:\CreditLimitPassword.mac""; " & vbCrLf
Commands = Commands & "l_file_id = TextFile_Open(pathname, 0,…
Posted by
Weekly Dynamic: Control Account Management for Receivables
http://msdynamicsgp.blogspot.com/2010/05/weekly-dynamic-control-account.html
One of my favorite unknown features for Dynamics GP is Control Account Management for Purchasing. This allows companies to process AP centrally and then roll down the AP balance at month end to the appropriate departments. A reversing entry then puts everything back into AP.
This is a…
This is a…
Weekly Dynamic: Receivables Scheduled Payments
http://msdynamicsgp.blogspot.com/2010/03/weekly-dynamic-receivables-scheduled.html
Last week we looked at Payables Scheduled Payments and this week we’ll take a look at the other side of the coin, Receivables Scheduled Payments. This feature allows companies to setup payment schedules, with or without interest, for existing receivable transactions.
The screen works the same way, a schedule number and description are used to track this receipt schedule. The original…
How to setup "No payments, no interests until June 1, 2009" payment term in Microsoft Dynamics GP
http://dynamicsgpblogster.blogspot.com/2008/12/how-to-setup-no-payments-no-interests.html
Business Situation
The current economic climate is forcing businesses to be a bit more creative. Some of these companies are resorting to No interest, no payments terms that allow customers to walk out the stores with the merchandise and begin payments at a future date. But, how is a company using Microsoft Dynamics GP going to deal with this type of payment term? What if the promotion is only being ran for the month of December only? What if all invoice generated in December are all due simultaneously on June 1, 2009 regardless of the date the invoice was generated?
Solution Implementation
Since invoices from SOP and RM flow to the RM Open table (dbo.RM20101) after they are posted, it is safe to say we can add a SQL Server trigger to overcome the hurdle. However, we must setup a payment term ID that…
The current economic climate is forcing businesses to be a bit more creative. Some of these companies are resorting to No interest, no payments terms that allow customers to walk out the stores with the merchandise and begin payments at a future date. But, how is a company using Microsoft Dynamics GP going to deal with this type of payment term? What if the promotion is only being ran for the month of December only? What if all invoice generated in December are all due simultaneously on June 1, 2009 regardless of the date the invoice was generated?
Solution Implementation
Since invoices from SOP and RM flow to the RM Open table (dbo.RM20101) after they are posted, it is safe to say we can add a SQL Server trigger to overcome the hurdle. However, we must setup a payment term ID that…
Posted by
Do you get wires or EFT payments from Customers? 
I suggest the use of the credit card feature to my customers for accepting wires, direct deposits and EFT payments from their customers.
Why the credit card feature? Well, you can setup a “credit card” called “Wire”, mark…
http://belindaallen.blogspot.com/2010/07/do-you-get-wires-or-eft-payments-from.html
I suggest the use of the credit card feature to my customers for accepting wires, direct deposits and EFT payments from their customers.
Why the credit card feature? Well, you can setup a “credit card” called “Wire”, mark…
Posted by
Weekly Dynamic: Speed Up the Receivables Aging Process
http://msdynamicsgp.blogspot.com/2009/08/weekly-dynamic-speed-up-receivables.html
The Receivables Aging process in GP can take some time if you have a lot of outstanding AR. There is an easy way to speed it up though. When running the receivables aging…
Writing Off A/R Balances in Microsoft Dynamics GP
http://amllp.blogspot.com/2009/09/writing-off-ar-balances-in-microsoft.html
One challenge many companies face is their ability to maintain a current and accurate aging of their accounts receivable. Collectors are judged on their ability maintain low DSO (Days Sales Outstanding) statistics, so keeping amounts out of the 60+Day buckets on the A/R Aging is a common goal. Receivables Management and Collections Management allow users to print A/R Aging reports, send customer letters and track collection progress on past due balances. But what can be done for the common over or underpayment by a customer?
Let’s say a customer’s balance on an invoice is $3,499.29. The customer pays only $3,499.09 (the customer may have short-paid the invoice because they have a dispute over the additional $.20, but just as often there are data entry errors on the part of the customer’s…
Let’s say a customer’s balance on an invoice is $3,499.29. The customer pays only $3,499.09 (the customer may have short-paid the invoice because they have a dispute over the additional $.20, but just as often there are data entry errors on the part of the customer’s…
Posted by
Writeoff vs. Credit Memo 
http://belindaallen.blogspot.com/2010/07/writeoff-vs-credit-memo.html
If you've used Receivables Management for a while, you've surely run across having a few cents left unpaid on an invoice. (I know Airplane fans, "Don't call me Shirley!") http://www.youtube.com/watch?v=0A5t5_O8hdA
Q…
Q…
Posted by
Over or under their credit limit???? 
You have a credit limit with your personal credit card. Even a popular credit card that boasts no preset credit limit will not approve expenses if you spend in excess of your normal spending history. So why not enter credit limits for your customers?
GP does something very…
http://belindaallen.blogspot.com/2010/08/over-or-under-their-credit-limit.html
You have a credit limit with your personal credit card. Even a popular credit card that boasts no preset credit limit will not approve expenses if you spend in excess of your normal spending history. So why not enter credit limits for your customers?
GP does something very…
Posted by
NSF: Non Sufficient Funds
http://mohdaoud.blogspot.com/2010/01/nsf-non-sufficient-funds.html
Great article on the above subject by Ian Stewart, explaining the affect of NSF transaction…
Posted by
Payables Vs Receivables - History Transactions
http://www.vaidy-dyngp.com/2009/06/payables-vs-receivables-history.html
Dynamics GP Reporting Series: Sales Invoice (Receivables Management)
http://mohdaoud.blogspot.com/2010/04/dynamics-gp-reporting-series-sales.html
Dynamics GP 2010: Cash Receipts Batch Entry
http://msdynamicsgp.blogspot.com/2010/03/dynamics-gp-2010-cash-receipts-batch.html
Amy Walsh takes a look at the new Cash Receipts Batch Entry feature in the Dynamics GP 2010…
Negative Cash Receipts in GP 2010
http://msdynamicsgp.blogspot.com/2010/02/negative-cash-receipts-in-gp-2010.html
Amy Walsh has a look at the new Negative Cash Receipts feature coming in Dynamics GP 2010…
My Favorite Receivables Inquiry Window
http://belindaallen.blogspot.com/2010/06/my-favorite-receivables-inquiry-window.html
GP Product Report III
http://ddelprado.blogspot.com/2006/02/gp-product-report-iii.html
Why it pays to read old quality reports
http://dynamicsgpland.blogspot.com/2009/07/why-it-pays-to-read-old-quality-reports.html
So, every once in a while, you stumble across an old quality report referenced in a knowledge base article. Usually I look at it, see it was resolved with a service pack to version 6, or 5.5, and I think "oh, well, that's not the problem". But today taught me that sometimes old quality reports will shed some light on a current situation.
So, here is the scoop. A client emails me asking why they see duplicate records in the RM30501 (Commission History table). They are paying commissions when invoice is posted (not when invoice paid). They see something like this in the table:
STDINV2599 with commission amount $100
STDINV2599 with commission amount $100
STDINV2599 with commission amount ($100)
Each entry has its own sequence number. So I do some testing. I enter an invoice, post it, void it, and see if I can come up with the same entries in the RM30501. No luck. So I told the client I needed to take a look on their system. We poke around for a bit, chasing one wild hair after another with no luck.
And then I…
So, here is the scoop. A client emails me asking why they see duplicate records in the RM30501 (Commission History table). They are paying commissions when invoice is posted (not when invoice paid). They see something like this in the table:
STDINV2599 with commission amount $100
STDINV2599 with commission amount $100
STDINV2599 with commission amount ($100)
Each entry has its own sequence number. So I do some testing. I enter an invoice, post it, void it, and see if I can come up with the same entries in the RM30501. No luck. So I told the client I needed to take a look on their system. We poke around for a bit, chasing one wild hair after another with no luck.
And then I…
Posted by
Customer Balance vs Customer Balance plus Open Transactions
http://rldu.wordpress.com/2009/12/13/customer-balance-vs-customer-balance-plus-open-transactions/
Extending customers credit, especially in today’s economy, has always and will continue to extend a companies financial risk. Unfortunately, we cannot do business (well most of us) on a cash and credit card only basis.
I had an issue arrise this week where a customer had a credit limit of around $2,500.00. This is a very low credit limit for most of our customers, so that tells me that we are keeping this customer on a tight leash. This particular customer’s balance was around $1,000 to us. Now, the customer’s balance is made up of the unpaid invoices that have been posted against his account. We…
Posted by
Latest links
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
- Error message -Could not find a part of the path when publishing Excel Report Builder report in GP
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
- Where are all of the official Microsoft Dynamics Blogs?
- eOne Office Closed for the US Memorial Day Holiday (May 27th)
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
GPWindow.com
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.