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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Customer payment before AR is entered

(0) ShareShare
ReportReport
Posted on by

I work for a non-profit. Our normal procedure is to enter a donor pledge into Sales>Transactions>Transaction Entry. The account distribution is a credit to revenue and a debit to accounts receivable. Then when the donation arrives I enter it as a cash receipt and apply it to the invoice.  If the donation is not for the full amount of the pledge, I send a statement showing the payments made and the remaining amount due. Now I have an unusual situation. One of our donors is still waiting on budget approval for a very large donation. I can't enter the pledge into GP because the amount is not finalized, and I have no signed agreement. The donor, however, is concerned that the program might close, and has sent an initial donation that they would like to have applied to their pledge once it is sent to us. Here is my concern: I need to book the revenue now, because that is what drives the governance of the program. Here is what I have tried so far in TEST:

1. So my initial thought was to create a cash receipt and credit revenue/debit cash.  But you cannot select Sales as a distribution type from the cash receipts entry screen. 

2. I then tried entering a credit memo from the transaction entry screen, but that also wouldn't let me select a Sales type. 

3. I tried entering an invoice, but leaving the sales amount as $0 and only recording the check. I thought that was going to work for a moment, but this time the distribution amount didn't equal the functional amount of the transaction, and the system wouldn't allow me to post. 

4. I tried entering the invoice with both the sales amount and the check amount. My distribution was credit revenue and debit cash. This worked, but did not create a credit balance on the customer account as I had hoped. But that was minor so I entered a second invoice for the full pledge amount. I unapplied the initial donation from the first invoice and applied it to the new one.  Then I voided the first invoice, but the void wouldn't post in financial because it had only one line for reversing the revenue. I recovered the batch and manually entered the second half of the distribution as the AR account. That seemed to work, as the trial balance for the revenue and AR accounts were accurate, and the customer balance looked correct.

My question is:

Is this really the only way to do it? It's really messy and it doesn't show that the customer is carrying a credit balance.  Am I just overlooking something super obvious here?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    kassab Profile Picture
    660 on at

    Hi,

    Regarding the AR invoices and cash receipts the Dynamics GP works with a middle account when there is a sales and a cash receipt

    the only time it wont use a middle account it will be when making an invoice and applying a cash receipt at the same time.

    a sales account wont be available in any screen either than the invoice.

    i guess you should make 3 entries to make this work until the invoice arrive to you but i don't know if its applicable to your case!

    1- create a normal cash receipt for the customer

    2- create GL transaction from the Sales account to your Middle account from the cash receipt ( this GL transaction should be reversed when the invoice arrive)  

    3- create the invoice and apply the cash receipt with it.

    I hope i understood your case correctly for my suggested answer!

  • Suggested answer
    L Vail Profile Picture
    65,271 on at

    Hi,

    You could:

    1. Enter the cash receipt

    2. Change the distribution account on the RECV type to your Sales GL account

    3. Post your cash receipt, it will update cash, sales and show a credit to the customer.

    4. Once they commit to the pledge, enter the invoice and change the distribution.

    5. Reduce the SALES distribution type by the amount of the cash receipt.

    5. Put the amount of the cash receipt as a credit to your SALES distribution type, but use the receivables account number.

    6. Go into Apply Sales documents and apply the cash receipt to your invoice.

    Initially, this will cause the AR trial balance to be out of balance with the GL by the amount of the cash receipt because you credited Sales instead of AR. Once the Sales invoice is created and posted, all will be back in balance.

    I'm not sure that's any cleaner, but I think it will get you where you want to go. It's something out of the norm, so I'd hope it doesn't happen too often.

    Kind regards,

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans