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

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

André Arnaud de Cal... 305,150 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
BCC 18 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No