topic Quantity not showing in combined model but is there in table in Desktop

Quantity not showing in combined model but is there in table

rpinxt — Wed, 08 Nov 2023 13:46:10 GMT

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.

Maybe somebody of you guys can get it to work.

HotChilli — Wed, 08 Nov 2023 14:52:37 GMT

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 — Wed, 08 Nov 2023 15:06:02 GMT

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.