Preparing the data model/ Defining Relationships error

[vannavada]

We are trying to set up the relations between the different kinds of tables I will be using in generating power bi reports and we are kind of stuck. Below is the relations we are using right now.

When we try to filter the visuals, there are parts where the data retrieved correct but most of the data shown is not corresponding to each other correctly.  like below.

This is the whole visual without any interactions applied.

I am pretty sure, there needs some changes to the data model level and I am hoping someone here in the community would help me. I am attaching the excel files and pbix file below.

Please help!

I am dropping all the tables down below and pbix file into a drive(it has all .xlsx files too)

BIExamplePbixFile 

AcctMstr

AcctNum	Name	Phone
123	Paul	111-1111
456	Robert	222-2222
789	Prashanthi	333-3333

RFQHdr

RFQNumber	CustAcct	Destination
1	123	England
2	456	Ireland
3	123	Germany

ProductMaster

CompPart-Seq	Description
1000-0	Wing
1000-1	Bolt
2000-0	Flange
3000-0	Wheel
4000-0	Piston
7000-1	Whistle
7000-2	Tire
7000-3	Wiper

Sales

Invoice	InvoiceItem	CustAcct	CompPart-Seq	TNum-Seq	QtyShipped	Price	Cost
1	1	123	1000-0	8-0	2	345	200
2	1	789	4000-0	9-0	3	587	210
2	2	789	2000-0	10-0	1	678	512

Stock

TNum-Seq	CompPart-Seq	Location	QtyOnHand	Condition	whLocation
2-0	1000-1	England	50	New	Z-92-X
3-0	2000-0	Ireland	7	New	H-48-4
1-0	1000-0	Memphis	2	Good	A-48-I9
4-0	3000-0	Memphis	8	Good	U-33-P0
1-1	1000-0	Memphis	1	Fair	B-00-6
5-7	7000-1	France	4	Poor	Shop
9-2	7000-2	France	6	Poor	Shop
10-4	7000-3	France	2	Poor	Shop

RFQItem

RFQNumber	RFQItem	CompPart-Seq	QtyQuoted	QtePrice
1	1	1000-0	1	1000
1	2	3000-0	2	500
2	1	1000-1	3	250
3	1	4000-0	4	375