Finance | Project Operations, Human Resources, ...

Open Purchase Order Report

(0) Share

Report

Posted on by Glenn M

Trying to run a Open Purchase Order Report to show only purchase orders that are still open. When I run the report it also shows PO's that are received and I don't want that in the report. Can someone please help?

Categories:

Microsoft Dynamics GP

All responses (11)

Answers (0)

Glenn M 5 on at

Like (0)

Report

RE: Open Purchase Order Report

Bill unfortunately it is against company policy for me to do that.

I appreciate your effort.
Bill Campbell 22,647 on at

Like (0)

Report

RE: Open Purchase Order Report

Glenn, if you would like to have me connect remotely to review this with you, provide me with an email and I will set up a remote screen session meeting. Should be able to look this over and figure out pretty fast. Be happy to assist on this one in 'remote person'

billc@misltd.ca
Glenn M 5 on at

Like (0)

Report

RE: Open Purchase Order Report

Bill I'm aware of this but I still can't seem to set it up for what I want it to do.

I must be doing something wrong.

I put PO line status and then after that whatever I put in the filter doesn't seem to work.
Suggested answer

Bill Campbell 22,647 on at

Like (1)

Report

RE: Open Purchase Order Report

Glenn, when you open the Smartlist - let it build the list, then look at the bottom of the window for a line like this

Click on the box where 'first 1000 records . . . .' appears. This will open the Search window

When you have the search window open, click on the look up on the first column name field and find PO Line Status

From here you can figure out what you need to do with the filters to get your desired results.

Trust this helps. Continue to post to the community for more assistance and when resolved be sure to tell us what you did.
Glenn M 5 on at

Like (0)

Report

RE: Open Purchase Order Report

Bill,

I'm not seeing or getting filter options to remove the RELEASED status.

How do I get to the filter box?

Thank you
Suggested answer

Bill Campbell 22,647 on at

Like (1)

Report

RE: Open Purchase Order Report

Glenn, looking at the FILTER options - it appears that you are selecting all lines are have status of RELEASED

Click on the box where you see RELESED and it should open the FILTERING window. Here you could also select where the status of the PO is not RECEIVED.

Continue to post and the community will continue to answer.

Hope this helps.
Glenn M 5 on at

Like (0)

Report

RE: Open Purchase Order Report

community.dynamics.com/.../pastedimage1601557248749v1.png
Glenn M 5 on at

Like (0)

Report

RE: Open Purchase Order Report

Hello, It's actually from the smart list option. I click on Purchasing, Purchase Line Items and then PO Line Items.

When the report runs and I export to excel all of the PO's come up including those that have already been received.

I'm trying to only get the ones that are not received yet that have a future date to receive.

Hopefully you understand what I'm trying to do. If you have a suggestion or can tell me how to get what I'm trying to do it will be greatly appreciated.

Thank you
Almas Mahfooz 11,003 User Group Leader on at

Like (0)

Report

RE: Open Purchase Order Report

if you are taking about this inquiry window then please make sure to unmark the second checkbox to print only open purchase orders.
Tian Tan 135 on at

Like (0)

Report

RE: Open Purchase Order Report

Hi Glenn,

It will be very helpful in solving your problem if you can tell me more details with some screenshots.

Thanks and BR,

Tian.