How to query inventory data across all companies efficiently

(0) Share

Report

Posted on by PP-08051102-0

Hello,

I am trying to query the Inventory data by writing a select query for /InventWarehouseInventoryStatusOnHandEntity/ with cross-company enabled.

Due to huge set of data, facing memory issue. Is there any efficient way to query all the inventory details across all companies.

Thanks!!

All responses (3)

Answers (0)

Sort by

Martin Dráb 241,417 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

First of all, which version of AX is it about?

Then please tell us more about the problem.
PP-08051102-0 35 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

It is Finance And Operations version - 10.0.35 Dev VHD setup.

I have a requirement of fetching entire inventory data across all legal entities/companies.

So I have created x++ class to make a select query for entity "InventWarehouseInventoryStatusOnHandEntity" with cross-company enabled as shown below..

InventWarehouseInventoryStatusOnHandEntity inventoryDetails;
while select crosscompany DataAreaId,ItemNumber,ProductColorId,ProductConfigurationId,ProductSizeId,ProductStyleId ,InventorySiteId, InventoryWarehouseId,InventoryStatusId,AvailableOnHandQuantity,ReservedOnHandQuantity,AvailableOrderedQuantity,ProductName,ReservedOrderedQuantity,OnHandQuantity, AreWarehouseManagementProcessesUsed,OrderedQuantity, OnOrderQuantity,TotalAvailableQuantity from inventoryDetails

{

// entity data conversion to json object

}

But this approach is throwing memory issue..

is there any other way to fetch the bulk data efficiently ??
Martin Dráb 241,417 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Moved from Dynamics AX forum.

"It's throwing memory issue" is not the level of details I hoped to get, so I must resort guessing. My assumption is that your problem is not caused by the query, but I guess you're trying to keep all the data in memory. That's the part you need to fix; not the query.

How to fix depends on what you're doing in your code. For example, if you're trying to creating a JSON file, you should write into in in smaller pieces rather then trying to have "entire inventory data" in memory at the same time.