Skip to main content

Notifications

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
    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
    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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans