Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Cleaning up Receivable Account

(0) ShareShare
ReportReport
Posted on by

Cleaning up Receivable Account is fun but not this fun.  Let me lay the ground work

- Customer Invoice 1,145.50

- Sent in CHEQUE for 1,744.00 ( not sure why I don’t have the INVOICE for that amount ) this was not applied – ever

-New cheque was issued for 1,144.50 ( correct amount ) – DEPOSITED TO BANK

- User applied the 1,744.00 from #2 – creating remaining balance of 599.50

- User entered a negative Cash Receipt to ‘show as refund’ to customer Credit Card for 1,754.00 – extra 10.00 was for bank charges – this appears to have been done on the First Data account

- Month end was done and the applied invoice ( now fully paid was moved to HISTORY )

 

ISSUES
1. Cannot void the payment that are applied to HISTORICAL Invoices

2. Can not do anything with a NEGATIVE cash receipt

3. Customer has been correctly refunded the 1,754.00

4. Customer Account shows that Canyon owes the Customer 1754.00

– which is made up of 2 Payments 5128 and 4618 – in fact the customer is ZERO

 

To Correct - that is my QUESTION to you - I will hold off on my answer until I hear a bit from others.

*This post is locked for comments

  • RE: Cleaning up Receivable Account

    Sorry, I thought I clicked that off when I first replied - thanks again.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Cleaning up Receivable Account

    It sounds fabulous!

    If the PSTL thing works for you - do I get an answer confirmation ???

    No worries,

    Leslie, I'm jealous, Vail

  • RE: Cleaning up Receivable Account

    Yes I love it - in 23 days I am off the computer for a week of sailing in the Caribbean islands for 7 days - can not wait - but in the mean time I have to work.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Cleaning up Receivable Account

    C'mon Bill,

    You love it!

  • RE: Cleaning up Receivable Account

    Yes I knew that someone somewhere would rattle this brain and get me to recall where I knew I could do this - man I have to take a break - 90 plus straight days in front of the computer without much time down is killer -

    Thanks Lisa, I will get that done and then I can unapply and move forward.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Cleaning up Receivable Account

    Hi Bill,

    First, you'll need to go into the PSTL tool and unapply the payment so that you can void it. When you unapply, both transactions will move back into the Open table. Take a look at that, I think it will fix you up.

    Kind regards,

    Leslie

  • RE: Cleaning up Receivable Account

    Thanks Lesile - I did have a typo - the amount of the INVOICE was 1,144.50

    I want to VOID the whole bunch but I have a problem - the payment of 1,744 was applied to the invoice - and then the INVOICE was cleared to HISTORY.

    I have tried to VOID that payment, but it does not appear - maybe I am looking in the wrong place - any suggestions?

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Cleaning up Receivable Account

    Bill,

    Have you tried to void the whole lot so that you could enter the transactions properly? Also, I noticed you said the new check for 1144.50 was the correct amount, yet the sentence before that stated the Invoice amount was 1145.50. Which is correct?

    Leslie

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans