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 :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error: The Accrued an...
Microsoft Dynamics GP (Archived)

Error: The Accrued and/or purch distribution(s) don't equal the actual amount

(0) ShareShare
ReportReport
Posted on by Community Member

Error is appearring on Purchasing Invoice Edit List - Purchase Order Processing.  Weird thing is these documents were okay this morning and when user went into the batch to continue adding documents, these errors started appearring.  HELP!!!!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    You may have a problem among the "Purchase amount" and the associated distribution. Go to the Transaction distribution, click "Delete" then "Default".

    This shall get it solved.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,627 Moderator on at

    You need to check not only the distribution amounts but also the distribution types in your documents.  If either amounts or types don't match what is entered into the invoice, you'll get this error.

  • Community Member Profile Picture
    Community Member on at

    Thanks, Have tried this and the default values only populate totalling the freight and misc charges.  Somehow the line item has disappearred offof the IVC.  What could be casueing this?

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

    I'll expand a little bit on my previous two colleagues excellent tips, only because I have this happen a lot!

    The 'out of balance' is that the Distribution TYPE codes do not match up to the amounts on the face of the PO Invoice.  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 Purchasing Invoice itself or you will receive the error you spoke of.  Here how the distribution types match up to the Invoice:

    TRADE = Trade Discount

    FREIGHT = Freight

    MISC = Miscellaneous

    TAX = Tax

    PAY = Total

    ACCRUED = Subtotal

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

    Please let us know if this was not the source of your problem.

    Kind regards,

    Leslie

     

     

  • Community Member Profile Picture
    Community Member on at

    Thanks for the clarification, my problem seems to be a bit deeper as the line item has fallen off of the receipt thus refreshing to default distribution only returns distribution for freight, taxes and misc charges, but not for Purch.  Result is still out of Balance.  What could be causeing the line item to disappear from when it was entered and appeared in batch earlier in the day but have since "disappeared"?

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Try running a reconcile on the receipt.

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

    Hi,

    Can you not add the proper distribution lines manually?

    Kind regards,

    Leslie

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    Create the same type of receipt in test company with trade discount, tax, etc what all are you using for this receipt and check the distribution account and distribution types. This will help you to understand the purchasing distributions and resolve the issue.

  • Community Member Profile Picture
    Community Member on at

    Hi,

    I am having the same problem.  About 80 invoices were entered in Receiving Transaction Entry and they were all correct.  We tried posting them and has the Error: The Accrued and/or purch distribution(s) don't equal the actual amount.  Even when I put the cost unit 0 and Extended cost 0, the subtotal and total at bottom show $.04 cents on 1 invoice.  Can you please help?

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

    If all of the amounts are zero except the bottom, I would look to the detail in the SQL table and see if you have numbers beyond the two decimal places that are visible on the window. I've also seen this with multicurrency, same problem. Check the POP10310 table in SQL. If you put a 4 cent distribution debiting and crediting the same account (net to zero on GL), do any errors come up on the Edit List report?

    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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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