Notifications
Announcements
No record found.
Hello Everyone,
I need help with some invoices that are sitting in a batch and not getting posted. I have errors such as Sales distribution amount is not equal ; Cash distribution amount is not equal and payment distribution is not equal. Below is one example for Payment distrubutions do not equal the amount received.
2) Cash distribution does not equal the amount:
Change the distribution type from DEPOSITS to CASH. Scroll down to Chapter 17.
https://docs.microsoft.com/en-us/dynamics-gp/distribution/sales-order-processing-part2-transaction-entry
Changing the type does not affect my GL account right ? when I look other invoices it has deposits selected as type then why this one needs to be cash ?
Not at all. In all the years I used GP SOP I have never seen the distribution type set to DEPOSITS. Is this a non-US GP deployment?
Richard, does this have something to do with the CREDIT CARD Deposit taken likely at the time of recording the order? I am guessing that the order is only placed and processed with a CC on the account. I think it might be a timing issue. There is likely a CASH receipts transaction somewhere that is not posted or completed correctly.
Just like me to jump into someone elses work and stir the pot. Keep posting.
Bill
It appears the DEPOSIT distribution type comes about when a deposit is placed on a sales order and then that order is transferred to an invoice. Is that what happened in this case? If not, you will need to change the distribution type to CASH.
Yes Richard is right. Its a sales order imported from our web portal and customer has paid via credit card card already and the deposit is attached but not sure why I have to change this type to CASH when others never had this problem. Undeposited GL account is used always with the type DEPOSIT.
Just to add when I change to CASH it does not work, it still says cash distribution is not equal. I have to change it to RECV and then it works. Why ?On the other hand, the second order works when I change it to CASH. Not sure why they two differ when both of them has payment deposits attached. Same GL accounts are affected. Please help and thanks for your responses guys.
Has anything change with your import program.? Has this happened with other orders?
Nop Idont think anything has changed since there were other orders as well in batch that got converted to invoice with deposits and got posted with no errors. And only couple had these problems. I can change the type and post them but like I said first order needs to change to RECV and second one needs to change to CASH. And I’m lost as to why ? But the GL ACCOUNT remains same so I not sure changing the type and posting them affects anything ?
The distribution types are there to confirm the dollar values are entered into the correct fields. It is the accounts that are most important. You would have to look behind the scenes to see what is going on here. Do you know how to use SSMS?
No , haven’t used it before. What can be the error
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional
