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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Manual Batch Posting E...
Microsoft Dynamics GP (Archived)

Manual Batch Posting Error Message.

(0) ShareShare
ReportReport
Posted on by Judith DeRemer 110

I am getting an error message when posting a manual batch.  The message states to correct Distributions that do not match Transactions beofre posting.  I have reviewed all distributions by line item and cannot seem to find out what the problem.  Please help if anyone knows the answer.  Thanks

*This post is locked for comments

I have the same question (0)
  • JoanLL Profile Picture
    JoanLL 75 on at

    I am just running into the same situation and have not been able to figure out what the problem is. Were you ever able to resolve this? Thanks

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    You my simply try to delete the distribution and press on "Default" to have all your accounts entered as they are initially setup.

  • JoanLL Profile Picture
    JoanLL 75 on at

    There were 300 employees in the batch, which was imported, so I ran a DEX_SQL.LOG and found out what record it was getting hung up on. Since the distributions actually balanced for the transaction I just deleted the transaction and manually reentered it and the batch posted fine. Something was funky with that one transaction.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Funky things happen quite often ..Good that you got it solved out anyway.

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

    Hi Joanll (and Judith)

    Does the error message say 'The whatever Distribution does not equal the actual amount'?

    The 'out of balance' is that the Distribution TYPE codes do not match up to the amounts on the face of the transaction.  So, if you have an amount in the Trade Discount field, all of your distributions with the TYPE TRADE need to add up to the value of the Trade Discount. You can have as many lines per distribution type as necessary, but it has to balance to the Invoice itself or you will receive the error.  For instance, if you entered a payables invoice, all of the distribution lines with a type of PURCH must add up to whatever amount you have entered in the 'Purchases' box on the face of the transaction.

    Here how the distribution types match up to a PO Invoice (for example):

    TRADE = Trade Discount

    FREIGHT = Freight

    MISC = Miscellaneous

    TAX = Tax

    PAY = Total

    ACCRUED = Subtotal

    PURCH = the difference between the receipt & invoice price of the item

    Is this the kind of thing you are running into?

    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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans