Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Purchase Receipts via aborted Auto-Receive Function

(0) ShareShare
ReportReport
Posted on by 12,931

I have a client who recently reported  a sharp up-tick in Accrued Purchases and COGS.  After a short investigation we discovered that one of their clerks was trying to determine what remained open on purchase orders, and decided the best way to do this was to Auto Receive purchase orders to see what popped up. Allegedly, they cancelled the Auto-Receive, expecting it to disappear - I cannot validate this.  These receipts wound up being posted.  I have proceeded as follows:

1.  Created a report to show what is actually open on Purchase Orders using SmartList Builder.
2.  Document and retrain the PO Handling Process
3.  Identify best way to remove the erroneous transactions created by using Auto Receive to identify outstanding items on Purchase Orders.  Still working on this.
4.  Create an exception report to identify when these transactions might have occurred in the past or if this occurs again on future occasions.  Still working on this.

Has anyone experienced a similar problem, and if so, how did you go about cleaning the mess up?

*This post is locked for comments

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Purchase Receipts via aborted Auto-Receive Function

    Over the weekend I was able to create and additional query, which identified Receipts in Excess of Payments, which identified another 211 problem Purchase orders.  The math on the differences is not equivalent to the amounts identified manually by the finance team, so we have tools to ensure this situation is not replicated in the future.

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Purchase Receipts via aborted Auto-Receive Function

    In order to identify transactions which amount to phantom receipts, I put together a query which compares receipt transactions to payments.  Specifically, if the receipt has not had a payment applied to it, the query returns the PO and Receipt Number, this has helped identify numerous transactions since Purchase Order Processing was implemented, which seem to share this 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.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans