PurchaseOrder Report

Finance and Operations/AX Technical Forum
1

Hello,

I want to create a new Purchase Order report i.e new format of PO .

But if we add maxof(purchOrderDocNum) from VendPurchOrderJour Table in header then related items from vendPurchOrderTranstable are not display in report.

Please help me How to create PurchaseOrder Report?

Thanks

2

Cannot you modify the existing report to meet your requirement?

How you are doing it ? What is the intention of it?

3

hi Kranthi,

i want to show maximum value of PurchOrderDocNum from VendPurchOrderJour table in header on report

and the related items to display on body of report from VendPurchOrderTrans table…

Thanks

4

r u geting maximum purchorderdocnum or not?

5

first of all get the max of PurchOrderDocNum and return it in the header after that in body write display method for the fields u wan to display

here is the example for one display method

…

select maxof(PurchOrderDocNum) from _VendPurchOrderJour;

k = _VendPurchOrderJour.PurchOrderDocNum;

select _VendPurchOrderJour where _VendPurchOrderJour.PurchOrderDocNum == k;

return _VendPurchOrderJour.PurchOrderDate;

6

Hi,

I would recommend you look at BI4Dynamics. We cover open order analyisis with BI4Dynamics as well as all Other Standard application areas: sale, purchase, inventory, receivables, payables, general ledger, account schedules, sales and purchase order analysis, jobs and resource, manufacturing, LS Retail. Pebblestone Fashion

You can do report you are aksing about in 30 seconds without any programing. You can simply use drag and drop functionlity as we have predefined cubes ready for analysis that already support all standard functionality.

I can show you a quick demo if you want. You can also check out our online demo on SharePoint; http://demo.bi4dynamics.com

Or

Apply for free trial at: http://www.bi4dynamics.com/en/downloads/112-trial

Please don’t hesitat to contact for any additional information: kl@bi4dynamics.com

Best Regards,

Klemen