Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Cannot Apply credit to...
Microsoft Dynamics GP (Archived)

Cannot Apply credit to customer

(0) ShareShare
ReportReport
Posted on by baxter05 2,680

Dynamics GP 2013

Collections Mgmt

Field Service

A RETURN (CREDIT) was automatically created via Field Service to give a customer $472.50 for the return of material.  The RTN# was posted and does show in the HISTORY table (SOP30200, SPO30300).  

But it is also showing in the SOP10102 table, however we cannot 'get to it to apply it'.

In Collections Mgmt, we can pull up the customers account and see $472.50 in "unapplied sales", but when we click on the link of "unapplied sales" it does not bring up the RTN#

The OPEN tables the RTN# shows up in:

SOP10102

SOP10106

RM00103 - AGPERAMT_4 = -472.50

RM20101

It shows as closed in all the other tables.  

How can we correct this so we can apply the $472.50 to the cusotmer's account?

*This post is locked for comments

  • Verified answer
    baxter05 Profile Picture
    baxter05 2,680 on at
    RE: Cannot Apply credit to customer

    William, you are correct.  I resolved this issue Friday night and meant to post -

    After doing my monthly reconciliation for Sales/Purchasing/Inventory, I decided to  run "Receivables Reconciliation".  This removed all UNPOSTED SALES & UNPOSTED CASH from customers accounts.  I have not yet gotten with the accounting manager to see how often she runs this but it will be addressed today.

    Thank you for everyone's feedback.

  • William W. - Professional Advantage Profile Picture
    William W. - Profes... on at
    RE: Cannot Apply credit to customer

    The Collections Main window pulls right from the RM and SOP tables, so if it looks wrong, they must be.

  • ArthurA Profile Picture
    ArthurA 321 on at
    RE: Cannot Apply credit to customer

    When you click on the unposted sales does it come show anything...I am assuming you mean it doesn't yet the Collections Main window is not updating?

  • baxter05 Profile Picture
    baxter05 2,680 on at
    RE: Cannot Apply credit to customer

    The account manager manually created a DEBIT that could be applied to the RTN.    She then went to Sales Trx>Apply Sales Documents in order to apply it.  The system does show that the DEBIT was applied to the RETURN DOCUMENT.

    However, when we go into Collections Management, we still see "Unposted SALES" = $472.50.  When we click Unposted Sales we know see four open orders that can be chosen from (they are new orders).

    RM00103 no longer shows AGPERAMT_4 with $472.50 - that is now empty.

    However RM00103 "UNPSTOSA" is showing $472.50 (which is unposted other sales amount)

    The RETURN DOCUMENT is CLOSED, the DEBIT was posted yesterday.  How can we get rid of the UNPOSTED SALES of $472.50?

  • soma Profile Picture
    soma 24,406 on at
    RE: Cannot Apply credit to customer

    Pam,

    Your account manager said "she did a DEBIT to apply the $472.50 against the customer account". What way she was used to debit  the $472.50 against the customer account? Manual GL against AR accounts? Or any other ways(Sales transactions returns)?

    Your reply is much appreciated.

  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Cannot Apply credit to customer

    Hi,

    Go to the Apply Sales Documents window (Transactions | Sales | Apply Sales Documents) and pull-up for the Return document and apply it to the Debit.

  • ArthurA Profile Picture
    ArthurA 321 on at
    RE: Cannot Apply credit to customer

    Can you screen shot what you mean?

  • baxter05 Profile Picture
    baxter05 2,680 on at
    RE: Cannot Apply credit to customer

    no - it will not allow us to select the return.

    I followed up with the accounting manager today and she said she needed to get rid of the credit of $472.50 on the customer's account so she did a DEBIT to apply the $472.50 against.  Which was fine for what she wanted to do, but in Collections Mgmt, it still shows $472.50 in Unapplied Sales.  But now it won't bring up anything.

    At this point, since the Acct mgr did the debit, and she is happy with the way the customer's account looks,

    Where can I go to just delete/remove/void the Unapplied Sales amount?

  • ArthurA Profile Picture
    ArthurA 321 on at
    RE: Cannot Apply credit to customer

    Hi Pam,

    When you go to apply sales documents can you select the return?

    Cheers

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans