Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans