Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Customer Factoring/Discounting

(0) ShareShare
ReportReport
Posted on by 880

How do i do the process of factoring or discounting a customer invoice through Great Plains 

*This post is locked for comments

  • Niju David Profile Picture
    Niju David 880 on at
    Re: Re: Customer Factoring/Discounting

     Dear Ian,

    Good day to you

    Thank you very much for the reply. Actually we are also following a manual procedure. But what I was looking forward to was a factoring functionality.

    I think we need to write to Microsoft for this atleast in the next release.

    Thanking you

    Regards

    Niju David

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Customer Factoring/Discounting

    No Factor functionality tht I can find exists in standard GP for this.

    What would be needed (and would probably be a very good addition to GP given the current business climate) would be factoring functionality somewhat similar to Witholding Tax...except for debtors.

    To manually handle the transaction, maybe you could consider the following:

    1. Post original Sales Invoice: Cr Sales 100.00, DR Receivables 100.00 as usual.
    2. Receive cash from Factor company and post it against the customers account Dr Bank 80.00, Cr Receivables 80.00...as usual.
    3. Post a DR note to the Customers account for 20.00 to clear the balance to zero. DR Factor Expense in the P&L, Cr Receivables 20.00.

    The above depends on the Factor company paying you the net amount after they have collected the debt.

    If they invoice you for the 20.00, and they probably will, and you want to record it, which you should...you could do the following:

    1. Post the factor invoice: Dr 'Factor Expense' in the P&L, CR Payables.
    2. Then you would have to process a Cr Note on the factor creditors account (since you won't be paying them as they have retained the 20.00)...Dr Payables, CR Factor expense in the P&L.

    The above process leaves your GL correct: No Receviable, No Payable, Sales of 100.00, 80.00 in the bank, 20.00 in a Factor expenses account in the P&L.

    You could also look at using settlement discounts, or write offs when you apply the 80.00 payment to the 100.00 invoice...but from an audit perspective, I would go with the clearly defined document process above...as you are recording exactly the underlying transactions.

    Anyone think any different? Or is there any specific software available for this or functionality that could be 'bent' to accommodate the above?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans