web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Purchase Order Status Report - Not including Returns

(0) ShareShare
ReportReport
Posted on by

Hello,

We recently began using Returns transactions within our POP system. One report we previously had relied heavily upon for discussions between purchasers, AP, and vendors was the Purchase Order Status Report. After processing some Returns transactions, this report is not accurately reflecting the PO Status in the "Qty Shipped", "Qty Invoiced", and "Remaining Ext. Cost"/"Remaining Subtotal" areas. 

The Return transaction Receipt No. is included in the list of shipments, but has no values. I would expect them to have a negative shipment amount to correctly updated totals. This makes the report seem like there is less left on the PO than there actually is. The Purchase Order window itself is correct when viewed directly however.

Is there a change I can make to report, or a setting in POP to help address this?

Thanks so much!

*This post is locked for comments

I have the same question (0)
  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at
    RE: Purchase Order Status Report - Not including Returns

    Hi,

    Have a look at Victoria Yudin's blog page about Receivable SQL Code..

    victoriayudin.com/.../receivables-sql-views

    you may find your solution in some of her scripts.

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Purchase Order Status Report - Not including Returns

    I eventually contacted Microsoft about this. This report is a known issue, and I don't believe there are any plans to fix it currently.

    I will attempt to modify at some point in time, and post my results.

  • Community Member Profile Picture
    on at
    RE: Purchase Order Status Report - Not including Returns

    I found out that return items had by default no due date, since the aging reports use due date for classification no amounts were reported.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans