G/L Entries - Purch. Inv. Lines Relationship

Hi Guys,

I'm creating a report that base on particular G/L Account number. Basically I already have the amount since it is readily available in the G/L Entries. Then I have identified as well the Item No. and Quantity based on Value Entries.

My problem now is, how can I link the G/L Entries with the Purc. Inv. Lines so that I can get the quantity from this table?

Sample G/L Entry:
Entry No Document No G/L Account Amount Quantity
10001 PPI-1000001 44090 1,000.00 <Blank>
10002 PPI-1000001 44090 2,000.00 <Blank>
10003 PPI-1000001 44090 3,000.00 <Blank>
10004 PPI-1000001 44090 4,000.00 <Blank>

Purch. Inv. Line
Document No. Type No. Quantity
PPI-1000001 G/L Account 44090 10
PPI-1000001 G/L Account 44090 20
PPI-1000001 G/L Account 44090 30
PPI-1000001 G/L Account 44090 40

With the above data:
Since it is using a G/L Account that pertains to different "item" in reality how can identify which line from the Purch. Inv. Line is related to which line from the G/L Entry?

My output should look like this:

Outputb]
Entry No Document No G/L Account Amount Quantity
10001 PPI-1000001 44090 1,000.00 10
10002 PPI-1000001 44090 2,000.00 20
10003 PPI-1000001 44090 3,000.00 30
10004 PPI-1000001 44090 4,000.00 40


Like some sort of G/L - Item Ledger Relation that diretly gives me the Value Entry No and th G/L Entry No.

Thanks and I hope explained myself properly.