Data redundant VendPackingSlipTrans on Report ?

Finance and Operations/AX Developer Forum
1

Hii Master,

This’s my Datasource relation :

GR_Query.png

This’s my Report :

Gr.png
Gr.png1194×365 323 KB

This’s my code :

query.png
query.png1065×375 9.77 KB

Heloo guys, I have a problem

In my VendPackingSlipTrans, Item id 2108 , 2111 & 2097 only have one line but if I generate my report, the report show the redundant item id & purchid.

How can i resolve this problem ?

Regards,

2

We don’t know about your query in full? How they are joined? what data sources it has? etc…
Look at the debugger, how does the query looks like after applying all ranges?

3

Hello Kranthi

This’s my table relation,

joinTBL.png

4

But in you code i can see other tables, packing slip jour, item group tables…
Were you able to find the end query after applying all ranges?

5

this’s my code for Insert to table temp :

InsertTBL.png

This’s my code when process :

query.png
query.png1065×375 9.77 KB

Can you suggest, what should i do ?

6

Still not sure, what is your total query is?
But you can check if the data source has a new value before inserting data into temp table
if (queryRun.changed(tableNum(VendPackingSlipTrans)))

7

On VendPackingSlipTrans I just took the qty value. Does this create redundant data ?

And when I can use this code, is it like this?

if(queryRun.changed(tableNum(VendPackingSlipTrans)))
{
This.InsertTmpTable(inventTable, invemtDim)
}

Please, correct me if i wrong?

8

What does that mean?

Yes.

9

Ok, Thanks Kranthi for your advice. this code work fine.