G/L Entries - Purch. Inv. Lines Relationship

marson

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.

ssingla

You can also have a alternative approach. G/L account is assigned by NAV from table "General Posting Setup" field "Purch. Account" based on the combination of "Gen. Bus. Posting Group" and "Gen. Prod. Posting Group" in the purchase line.
You can use the same in determining the purchase account in the report.