Microsoft Dynamics AX (Archived)

how to customize to get & filter only complete purchase orders in Arrival Overview Inventory Module AX 2012 R2

(0) Share

Report

Posted on by Codehunter

10,280

i need anybody help to filter only completed purchase orders in Arrival overview ASAP....

*This post is locked for comments

I have the same question (0)

All responses (27)

Answers (1)

Jonathan Halland 11,310 on at

Like (0)

Report

Hi. Is this a specific form? Do want the form to always only show completed purchase orders?

Was this reply helpful? Yes No
Codehunter 10,280 on at

Like (0)

Report

yes.

Was this reply helpful? Yes No
Codehunter 10,280 on at

Like (0)

Report

plz somebody answers me ASAP!!!!

Was this reply helpful? Yes No
Verified answer

Bilal Issa 4,370 on at

Like (0)

Report

Hi,

you need to modify class WMSArrivalOverviewGeneration -> method buildOverviewQuery

Regards,

Bilal

Was this reply helpful? Yes No
Annette Theissen 1,653 on at

Like (0)

Report

Hi

Jonathan has already asked which form you're talking about, please give that feedback.

My additional question would be: What do you mean by completed purchase orders? I'm asking because in the context of item arrival, "completed" could mean those where the item arrival is completed ... In general, I'd see a purchase order only as completed if all of its lines are fully invoiced. But that would not be interesting in the item arrival context.

A general answer:

Join the table that indicates the criterium (maybe purchase table?) to the form's main datasource. Add a Range to that table (PurchStatus = Invoiced?).

Annette

Was this reply helpful? Yes No
Codehunter 10,280 on at

Like (0)

Report

i found it but how to filter with only completed Purchase Orders

Was this reply helpful? Yes No
Codehunter 10,280 on at

Like (0)

Report

i found WMSArrivalOverviewGeneration -> method buildOverviewQuery but how to filter with only completed Purchase orders i only see Ordered,Arrived,Purchased

Was this reply helpful? Yes No
Annette Theissen 1,653 on at

Like (0)

Report

Well, this form is intended for stuff that still has to arrive. Therefore, in the buildOverviewQuery method, there is a filter on StatusReceipt = Ordered (on the inventTrans table).

If it's possible, let us know why you want to do this ... as I said before, invoice purchase orders are not of interest to item arrival. What is the intention of this request?

Was this reply helpful? Yes No
Codehunter 10,280 on at

Like (0)

Report

I need to get all purchase orders with approval status confirmed to be shown only on arrival overview

Was this reply helpful? Yes No
Codehunter 10,280 on at

Like (0)

Report

Plz need it urgently

Was this reply helpful? Yes No