Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6300 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title: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 typically have a 1-2 day lead time for orders to be processed by account receivable, invoiced, and posted to a customer’s account. What happened in this case was the customer placed 3 more $1,000 dollar orders with us in that 1-2 day period. While his balance remained the same, $1,000, he had open charges, yet to be posted, of around $3,000. Since none of these individual transactions of $1,000 pushed him over his credit limit (current balance $1,000 + individual transaction $1,000 does not equal credit limit $2,500), no credit limit hold fired. You can obviously see the problem here.

To get around this, we have written a SQL query that will combine the customer’s balance, plus all open transactions against the customers account. If the total of the balance and open transactions exceeds the customer’s credit limit, we fire off an email to our receivables department to stop the order and manually place it on hold. We then contact the customer and alert them that their account is over it’s limit and that the order has been placed on hold. This is usually, but not always, enough to get the customer to send us a check.

If you are extending credit to your customers, this is definately something you should be aware of. It is always better to be proactive and hold the order, which also gives you the leverage to get paid, as opposed to reactive and battling to get paid. Do you ever think about how much it costs for you to collect your receivables?

Category:TIPS AND TRICKS BY MODULES: RM (Receivables Management)
Link Owner:
Date Added:June 17, 2010 07:06:55 PM
Number Hits:27
RatingsAverage rating: (0 votes)

No Reviews Yet.


Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.