Vendor Data

(0) Share

Report

Posted on by Community Member

Hi All ,

Is there any standard report available in AX 2012 R2 to show all the open/confirmed vendor wise purchase orders with PO value in vendor currency and company currency ?

If not what is way to get such information ?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Fredrik Sætre 12,644 on at

Like (1)

Report

Yes.

The simplest way is to use the excel addin.

Add the PurchLine.

Most of the fields are natively in this table, like currency and line amount, but the amount in company currency isn't in the table.

There is however an amountMst function on the table, and this is where the Excel add in shines.

When selecting fields, right click the PurchLine node in the fields tree and select properties. Now activate "calculated fields".

You should now have a Master currency/Company currency field based on the amountMst function. Include this in your fields.

Now all you have to do is filter and pivot the table.

Good luck.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the reply ,

Does PurchTable or PurchLine has any field name that when the PO has created and when sent to vendor ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Does PurchTable or PurchLine or in purchase order form has any field name that when the PO has created and when sent to vendor ?

Was this reply helpful? Yes No
Suggested answer

Fredrik Sætre 12,644 on at

Like (0)

Report

It is also in the functions. It is called Document Status...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

[quote user="Fredrik Sætre"]

It is also in the functions. It is called Document Status...

[/quote]

Sorry , i did not get you what you mean by docuement status in functions.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Does PurchTable or PurchLine or in purchase order form has any field name that when the PO has created and when sent to vendor ?

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

PO can be sent to a vendor multiple times. while staying on PO form itself,, you can only get Last date (when last time PO was sent)

As, you can send multiple revisions of PO to a vendor, so you will to get date of old revisions you have to get this information form PO confirmation screen. With one record of PO you cannot get N number of PO confirmation, while staying on PO header. On PO header, you can get information for latest PO confirmation Date. to do this navigate to Upside in General >> Related Information>> Postings

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Sohaib for the reply ,

How to get the information that when the PO is created and when did sent to vendor ?

I didn't see any fields in AX PurchTable and PurchLine . Please help.

Was this reply helpful? Yes No
Suggested answer

Fredrik Sætre 12,644 on at

Like (0)

Report

If you have posted a confirmation. The system creates a record in PurchConfirmJour or if you use it correctly you use the purchInquiryJour. Created date for this record is your date from when it was sent to your vendor. As Sohaib sais. You might have sent multiple confirmations/inquiries sent.

So PurchTable createdDate is offcause when Purchase is created.

Was this reply helpful? Yes No