Dealing with Muliple Date Fields and Dealing with multiple stock Files

[morenasm]

Hi All

Im a bit new to Qlik sense Enterprise.

I need to build a Data Model for an FMCG Company.

The company does Sales with Field Reps,

I have Multiple Source's of Data with Multiple Dates an Stock items.

Heres the Flow:

Rep Has Call Cycle-->Rep Calls on Client (Call Made)-->Rep has a Target-->Rep Places Order-->Order Gets Invoice'd-->Order gets Delivered.

I have a Call Date,Order Date,Invoice Date and a delivery date. I want to build most of my reports using AutoCalendar so i Used a Comoncalender to Link Date with a Comon Calendar.(This Works)

The problem is the Stock items does not link in my tables.

Below is a view of the Data Model.

Account Number Field Links most of the Columns

What is the Best way to deal with this

Thanks