Odd problem reading data via ODBC link

Hey v-diye-msft ,

Thanks for replying to my question.

Below you can see the first row of my report. The issue I was mentioning before is to do with the report reading Ordered Quantity and Despatch Quantity incorrectly. These are just fields in a table, however to get them you need to make sure the relationships are correct as it requires an Account Code which comes from a different table.

First Row of my report

Below is the same row but in Crystal Reports (the report I'm trying to migrate to Power BI). As you can see, the ordered Quantity and Despatch Quantity are different. In this case, I was lucky in that the Value and Outstanding columns still came out the same due to the arithmatic involved.

First Row of the Crystal Report I'm m

Here are the relationships currently on the Power BI Report. They match the relationships that Crystal has. You can ignore the LastRefresh_Local table as I'm using that for a card.

Power BI Relationships #1Power BI Relationships #2

Below is how Outstanding is calculated. A simple formula.

How Outstanding is calculated

I'll look into providing a dummy report shortly, but for now will that do? Is there any other pictures that could help you?

Thanks again.