web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Create a Receivable wi...
Microsoft Dynamics GP (Archived)

Create a Receivable without posting to the GL

(0) ShareShare
ReportReport
Posted on by Community Member

We have an odd issue where we need to create a Receivable to clear a negative balance on a Customer Account without posting anything to the GL. The GL is correct. If we just create a Receivable without posting, it does not clear the balance for this Customer. 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Create a Receivable without posting to the GL

    John,

    You can create a debit memo and do an in and out to the same account. This will prevent the system from updating the General Ledger

  • Community Member Profile Picture
    Community Member on at
    RE: Create a Receivable without posting to the GL

    Won't that zero out and leave me with the existing negative balance?

  • Community Member Profile Picture
    Community Member on at
    RE: Create a Receivable without posting to the GL

    Actually, it did not even allow me to apply the Dr memo. The only options were Payment, Credit Memo and Returns. Even though I selected Debit memo in my transaction, it did not appear.

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Create a Receivable without posting to the GL

    Maybe I should have started by asking who owes who. Do you owe your customer or does your customer owe you? I want to make sure we are on the same page when it comes to the term "negative credit". That way I can formulate a better response. My initial assumption was that all you needed to do was clear off a credit balance showing on one of your customer accounts since you said that the GL is correct. If all you want to do is clear the account, then the debit memo is still a good option.

    The debit memo will be for the value you are trying to clear, let's assume for discussion sake $100. You will then click the Distribution button on the transaction window and select the same AR account for both the debit and the credit side of the transaction. You will post the document, which should create no entries in GL, then open the Apply window, locate the outstanding credit document(s) you want to clear, and apply against the debit memo previously created, until the debit memo balance is zero. This should close out the customer account. 

  • Community Member Profile Picture
    Community Member on at
    RE: Create a Receivable without posting to the GL

    Odd situation. Because we have one bank account outside of GP, we received a check that had to be moved to an account that could send an ACH. We received the check under a Customer Account and posted the cash, but we transferred the cash to the outside bank. Now we have this credit balance for a Customer that should be zero.

  • Verified answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Create a Receivable without posting to the GL

    Correct, very odd indeed. Based on your narrative above:

    1. Entered cash receipt for $100 for customer XYZ

    2. Posted cash receipt. Customer account now shows $100 on credit

    My steps now:

    3. Enter debit memo for $100 for customer XYZ

    4. Click on Distribution button and make debit and credit accounts the same (GL is correct according to your original post)

    5. Post debit memo

    6. Open Apply window

    7. Locate credit payment for $100

    8. Apply to debit memo for $100

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Create a Receivable without posting to the GL

    Worked perfectly, thank you!

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans