List of Items on POs to Excel

Finance and Operations/AX User Forum
1

Hello All -

Is there a way to get all items on all POs to pull on a report, ideally to Excel? Basically I’m looking to try and track how many of one item has been purchased, what projects those go to, average costs of one item, etc.

Any help would be greatly appreciated.

Thanks,
Justin

2

Is there any reason why you can’t simply export the report to Excel? It’s a standard feature of SSRS. (Because you haven’t mentioned any version, I assume you’re using Dynamics AX 2012.)

3

Hi Martin -

Yes, I’m using AX 2012. I know how to get the export to Excel with the POs, however I haven’t been able to find a list of all items that have been added to POs. At that point, i’d love to be able to get it out into Excel. Is that possibly something I don’t have access to see? I would imagine the functionality is there, I just don’t know how to access it all.

Thanks,

4

Okay, so we can put the question of Excel aside, because that’s already handled by SSRS.

I doubt that there is any such report, but you can create a new report according to your requirements (= probably ask a developer to do it).