Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Shipped not invoiced mismatched to accrued GP 2010

Posted on by 75,730

I have a situation where the accrued purchases account amount has strayed from the value on the shipped/not invoiced amount. I have tried looking for any cancelled PO's but have not found any. Trying to use the POP10500 and POP10600 has been difficult. Does anyone have any scripts that may help find from where the difference is coming?

*This post is locked for comments

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Shipped not invoiced mismatched to accrued GP 2010

    Good luck and let us know what you find.

    Thanks,

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Shipped not invoiced mismatched to accrued GP 2010

    That was my first thought. I went into the GL20000 and found a couple of Edit PO's but they were from last year. Whatever  it is happened in the past two weeks. I was hoping I would find a cancelled PO where it as cancelled after the shipment receipt was done but that turned up nothing either. I am going to try to build a script that will look at every PO line and then sum the shipment receipts and compare that to the invoice receipts. I do remember someone's computer locking up while posting a receivings entry. Perhaps it got doubled up.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Shipped not invoiced mismatched to accrued GP 2010

    Richard, have you looked at the account activity to see if someone posted a manual journal entry into accrued purchases?  It's also possible that a transaction from another module hit the accrued purchases account.  You can spot this easily enough by running a SmartList on the accrued purchases account transactions and pull the originating transaction source in to spot any errant transaction coding.

    Hope this helps,

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans