Small and medium business | Business Central, N...

Generating a Report for all Purchase orders that have a specific dimension

(0) Share

Report

Posted on by Holo_AV

We want to generate a report for Purchase Orders (or Purchase Invoices) that are all related to a specific dimension (in this case a project). The dimension has been already set for all PO´s. (and are also set for each specific line)

any support is appreciated

Thanks

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

JAngle 135 on at

Like (0)

Report
Copy link

Link copied!

Quickest result would be to publish a web service for the purchase line page 518. Use the URL in excel or create a power bi report.

Better than using the table as the project dimension you need might be a shortcut dimension.

Was this reply helpful? Yes No
Suggested answer

noor1 56 on at

Like (0)

Report
Copy link

Link copied!

Hi Holo,

I could not get specific answer related to your query. but i have received an answer which i haven't tried yet.

Answer:

Before trying to make a system modification, check out the available AX2012 cubes. There is a specific purchase and ledger cube that might give you the information you are looking for. So please check out those before spending money for system/report adjustments.

Was this reply helpful? Yes No