A list of all the MOQ for all Released articles

(0) Share

Report

Posted on by BCC

Hello

Does anyone know how to get all the "Minimum order quantity"-values for all the Items we have in "Released items" in Our Ax 2012, on a list? And I want to get all out on an Excel list.

I can only find it if I go into an article i "Default .order settings".

regards BCC

All responses (3)

Answers (1)

BCC 18 on at

Like (1)

Report

RE: A list of all the MOQ for all Released articles

hello Junaid

Thanks.

I found a table called "InventItemPurchSetup" and there was what I was looking for. So your answer helped me along the way with this.

so thanks again

regards BCC
Suggested answer

Junaid Idrees on at

Like (0)

Report

RE: A list of all the MOQ for all Released articles

Hi BCC,

You can use data management to export min/max order Qty.

Check the entity called "InventProductDefaultOrderSettingsEntity", Create export project on this data entity and export into excel.
Verified answer

André Arnaud de Cal... 294,033 Super User 2025 Season 1 on at

Like (0)

Report

RE: A list of all the MOQ for all Released articles

Hi BCC,

The Data import export framework (DIXF) can be used to export data to an Excel file. You can check if there is an existing entity for the order settings (can't verify it myself as I don't have a running environment). It might be a separate or part of the Items entity. Otherwise, you can use a wizard to create a new entity as a start.