Finance | Project Operations, Human Resources, ...

Matrix report values are disturbed when I run report with a blank parameter. How to fix?

(0) Share

Report

Posted on by JJDunaid

226

Hi everyone,

I have been working on a report recently with a two parameters /Quotation id/ from quotation table and /Warehouse/ from warehouse from Invent sum with range of (0 or 1) either with a value or null value.

So getting o the point reports works fine when i run it on //quotation id / parameter. when i run it with the /Warehouse/ parameter with a value (w6001)in it it works fine the /available physical quantity in warehouse (w6001) from invent sum is calculated accurate / but when i pass null value to /warehouse/ the available physical amount is disturbed.

in simple when I run report for a specific warehouse it is working fine.

I am using this code logic through which available physical quantity is being filled up.

//This is used to store available physical from inventsum on basis of warehouse.   while   select   * from inventSum     where   inventSum.ItemId            == stockQuotationTmp.ItemId     && inventSum.InventLocationId       == stockQuotationTmp.WareHouse          {           stockQuotationTmp.NetAmount      += inventSum.AvailPhysical;       }

for you reference i have attached visuals.

this is working fine with quantity:

this is not working fine when i pass null (which means available physical from all the warehouses should be displayed) you can have refrence from warehouse /w6001/

any guidence?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,765 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi

you can use a query

e.g.

Query query = new Query(); QueryBuildDataSource qbds; QueryBuildRange qbrItem, qbrWareHouse; qbds = query.addDataSource(tableNum(inventSum)); if(stockQuotationTmp.ItemId ) { qbrItem = qbds.addRange(fieldNum(inventSum, ItemId)); qbrItem.value(SysQuery::value(stockQuotationTmp.ItemId)); } if(stockQuotationTmp.WareHouse) { qbrWareHouse = qbds.addRange(fieldNum(inventSum, InventLocationId)); qbrWareHouse.value(SysQuery::value(stockQuotationTmp.WareHouse)); } queryRun = new QueryRun(query); queryRun.saveUserSetup(true);

Best regards,

Mohamed Amine Mahmoudi

Was this reply helpful? Yes No
JJDunaid 226 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohamed,

you didn't got my point , i think you have suggested me query range for the parameters ! i have tried it also , it doesn't work .

I have debugged my code in debugging it is calculating correct physical quantity for all warehouses but when data on report is displayed the results are different.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Matrix report values are disturbed when I run report with a blank parameter. How to fix?

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Congratulations to our 2025 Community Spotlights

Congratulations to the December Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Matrix report values are disturbed when I run report with a blank parameter. How to fix?

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Congratulations to our 2025 Community Spotlights

Congratulations to the December Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates