Aged Purchase Orders

(0) Share

Report

Posted on by Community Member

Good Afternoon,

I am wondering if anyone can help with a query regarding Aged Purchase Orders, if it can be done. I am looking to find which Purchase Orders were open at a certain date including the line items. I need to produce a report to show this information however I am struggling to find where I can obtain this. Could anyone assist?

Thanks

Kevin

*This post is locked for comments

All responses (4)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Aged Purchase Orders

Do you see the Required Date on the list when you click the add field button?
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Aged Purchase Orders

I simply added the required date to the Smartlist. You can then set search criteria on the date.
Community Member on at

Like (0)

Report

RE: Aged Purchase Orders

Thanks for replying Richard. I have had a look at the Purchase Line Items Smart List however I cannot see Items Past Required as a field (both filtered and all) to add. As I understand, these lines will show what they are currently as at now rather than at the specific date?
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Aged Purchase Orders

You can do that with Smartlist and the document date. Purchasing->Purchase Line Items and modify the Items Past Required date.