Quantity not showing in combined model but is there in table

[rpinxt]

The situation :

4 Sources here. 0 - Material Master, 1- Delivery Date, 2- Addendum/IFU data, 3 Inventory Data

Fields Ship to, Delivery and DelQ come from table 1 - All fields correct

Field addendum Part No -Display coming from table 2 - All correct

Now from table 3 I need to get InvQ (a measure based on Total Qty of table 3) in.

But as you see it will not do it. However in the visual to the right you can see there is a quantity in table 3.

Below the link to the file.

https://drive.google.com/file/d/1LGYN5yySX03_0X2DxxLe6r-jSQyUun-t/view?usp=sharing

Maybe somebody of you guys can get it to work.

[HotChilli]

Have you got relationships linked by the correct field?

The table on the left shows 'Addendum Part No - Display' and the table on the right is 'Material'.

The relationships in the model are all on Material fields.

[rpinxt]

Yes this should be correct.

The thing is here that Addendum part is also a 'material'.

The material master holds all materials being Finished Good and Raw Material.

Bit background:

The Delivery contains a Material (Finished Good) and for some of these a "booklet" needs to be packed with the Material in a certain language.

This booklet is also a Material number but a Raw Material.

So to big line is:

- Delivery gives Material

- IFU Data checks which Addendum Part (raw material) needs to go with the material (Finished Good)

- Inv (entory) Data tells us how many booklets (addendum parts) there still are

Inv Data is taylored to only give the material numbers for the raw materials.

And in table IFU data these are the addendum parts. Not the Material.