Microsoft Dynamics AX (Archived)

View PR List with PO number or PO List with PR Number

(0) Share

Report

Posted on by benjamin84

2,075

Dear All,

anyone know how to view List PR with PO number or List PO with PR Number ?

would be nice if have with detail information as item and price ?

Thank you

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

benjamin84 2,075 on at

Like (0)

Report

RE: View PR List with PO number or PO List with PR Number

Hi Chaitanya,

thank you for your effort. Appreciate.

its seem you specialize at development/code, could you help for this case at : community.dynamics.com/.../738743

here's my requirement :

I need menu allocated charges always enabled,

but since my company use po approval, those menu only enable if po status still/currently on draft state.

once po submitted for approval ( in review state ), its disable/not clickable.

in approved state, confirmed stated, its disable too.

I need those menu always enable , so we don't have to recall/request change for keyed-in the charges.

we had do recall/request many times, if vendor did partial shipment, if vendor did partial shipment 10 times, its mean we must do recall/request change and approval process again for 10 times,despite the fact we didn't amend anything at po and po lines.

would be nice to have solution for this case.

Thank you

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

RE: View PR List with PO number or PO List with PR Number

Hi Magic,

thank you for your effort. appreciate.

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

RE: View PR List with PO number or PO List with PR Number

Hi Mahmoud,

appreciate, its works like a charm.

thanks a lot

Was this reply helpful? Yes No
Verified answer

Mahmoud Hakim 17,887 on at

Like (2)

Report

RE: View PR List with PO number or PO List with PR Number

yes, this is very easy without any customization or modification, just make some personalization on form as the shown below

add line status and remove open order to show all orders, add the purchase requisition field

procurement and resourcing / inquires /open purchase order lines

Was this reply helpful? Yes No
Verified answer

Chaitanya Golla 17,225 on at

Like (0)

Report
RE: View PR List with PO number or PO List with PR Number

Hi,

You can use the below job/code to list PR based on PO number and let me know if anything is missing.

static void AXC_PRToPO(Args _args) { PurchReqLine purchReqLine; PurchTable purchTable; PurchReqTable purchReqTable; while select purchTable where purchTable.PurchId == "XYZ" // Specify purchId here join purchReqLine where PurchReqLine.PurchId == PurchTable.PurchId && purchReqLine.PurchIdDataArea == PurchTable.dataAreaId join purchReqTable where purchReqLine.PurchReqTable == purchReqTable.RecId { info(strFmt("PurchId: %1, Requistion Id:%2, Activity: %3", purchTable.PurchId, purchReqTable.PurchReqId, purchReqLine.ActivityNumber)); } }

Was this reply helpful? Yes No
Suggested answer

guk1964 10,886 on at

Like (0)

Report

RE: View PR List with PO number or PO List with PR Number

There is no direct relationship between a PO and Purchase Requisition.   In AX, a PO can be created from multiple Purchase Requisitions.  And each Purchase Requisition could contain multiple Lines. The relationship is from a PO to 0 or more Purchase Requisition Lines, and from each Purchase Request Line to its Purchase Requisition.   Knowing the PO AX can find all of the Purchase Requisitions related to it, but not from which one any particular PO line comes gets you only half way..

So AX also has a relationship directly from a PO Line to a Purchase Requisition Line (assuming the PO line came from a PR).   when you know the Purchase Requisition Line, it can get the Purchase Requisition i.e. you have to select a PO Line before you can find out the related Purchase Requisition.

In the PurchTable table there is a field 'PurchId' which you can link to a PurchRFQLine that has a field of 'PurchId'  to get the purchase order number once the PR line for the item requested is converted to a PO.

PurchTable.PurchId == PurchRFQLine.PurchId

Was this reply helpful? Yes No