Table View not showing data. Relation Issue?

[Anonymous]

Hi There, 

Please advise on the following.
For a customer  I am building a report that shows:

Location - Item - Quantity - Date Last shipped from location - Quantity Last shipped from Location - Date Next Shipment for Item - Quantity Next Shipment for Item

I am using 3 Tables which are structured as followed:

Location
Code	Item	Quantity	Key
A	123	1000	A-123
A	456	2000	A-456
B	123	500	B-123
B	789	150	B-789
B	456	5000	B-456
C	XY123	500	C -XY123
C	XY555	1500	C-XY555

Outgoing
Code	Item	Quantity	Order	Date	Key
A	123	100	ORD_001	6-12-2021	A-123
A	456	50	ORD_002	11-11-2021	A-456
B	789	25	ORD_003	10-11-2021	B-789
B	789	25	ORD_005	6-7-2021	B-789
B	456	100	ORD_005	6-7-2021	B-456
C	XY123	75	ORD_006	6-12-2021	C -XY123
B	456	500	ORD_006	11-12-2021	B-456

Future Sales
Item	Quantity	Order	Date
123	100	S.ORD_001	3-3-2021
456	50	S.ORD_002	1-5-2021
789	25	S.ORD_003	1-5-2021
XY123	75	S.ORD_006	7-6-2022

The tables are related:
Location [Key] - Outgoing [Key] 
Location [Item] - Future Sales [Item] 

I've made a "Key" column because I only want to find the last outgoing date for the specific location + item not the item in general. With the Future sales date we want to find the date for an item so there we can use the Item relation.

Now the problem that occurs is that some of the future sales are not showing:

We do however have a next sale for this item:

There is no outgoing shipments for this item. When I remove these columns the Sales entry does however show:

I can't help but feel there is somehow a relation between the Outgoing and Sales tables but there shouldn't be. 

Anyone have any ideas perhaps? 
Thanks in advance,

Koen

[Anonymous]

Hi,

Thanks for the response! Let me try to clarify.

We have Locations where items are stored. (BinContents Table). Items can be stored on multiple locations. 
Then we have outgoing transactions (Warehouse Simplified Table) this table is linked by a key Location + Item. 

Then we have future sales (Future Sales Line Table) This is a table that consist of the first that we are going to ship an item. This sales is however not linked to a specific location (yet). 

In my report I want to show current stock at locations. Then I want to show the next outgoing transaction and the first future sale. 

Now the problem is that when I select item Treefix-6. You can see it is present at location 251E with 35 pieces without an outgoing transaction. That is all correct. 

But looking at the first sales date there is none. however looking at the data in my model I can see that there is a sale for this item. There are no filters on the visual/page that impact the visual. 
What also interests me is that in the table when I remove the outgoing transaction date field the date for first sales does appear. 

Hope that clarifies it a bit. If more info is needed let me know!

[v-easonf-msft]

Hi, @Anonymous 

Sorry, I still haven't figured out your question.

Can you briefly describe your expected result based on the sample data you provided?

Best Regards,
Community Support Team _ Eason