Pervasive SQL V11 Connection ODBC failed,Pastel Partner

[Riandwelm]

Morning Everyone

So i need some help with reports I'm writing . I'm currently using power bi desktop to write visual reports for our business . Firstly my database is from pastel partner and as you all know its a pervasive database . Well we have created warehouses for all our trucks and products . So for each truck their will be an inventory code with the extension the product . for example
JKL919-50 PPM
JKL919-10 PPM
JKL919-IP
JKL919-93ULP
JKL919-95ULP

These inventory codes are linked to certain GL CODES that represent branches and their products like :

Sales Brandvlei Diesel - 1005/101
Sales Brandvlei IP -1005/102
Sales Brandvlei ULPPETROL -1005/103

Now I would like to now how do i link the two tables together so that when i create a report i can see the total sales as per income statement and then next to it i have the quantity and then i have the average selling price per litre as all clients have their own unique prices .

I know this is possible because i can do this on a monthly basis using excel .

So basically i would like to link the following two tables together History Lines and the Ledger transactions with a formula .

If anyone could assist that would be awesome !!!

Warm Regards
Rian Smith

[v-ljerr-msft]

Hi @Riandwelm,

So basically i would like to link the following two tables together History Lines and the Ledger transactions with a formula .

---

I cannot see the two tables from your original post. Could you re-post the two tables with some sample data? So that we can better assist on your issue.

Regards