Link of G/L Entry - With Value Entry or other Table

qlikering

Hi Guys,

I have this requirement from our finance group to indicate the Item No. for G/L entries.
I'm trying to get the item number from the Value Entry using the link

G/L Entry > Value Entry
Doc. No. = Doc. No.
Amount = Cost Amount Posted to G/L

However when there are two lines in Value Entry that has the same DOC NO. and Amount it is creating two entries in my output table.

Can you recommend solution regarding this matter?

Flow should be :

1. Get all entries from G/L Entry (filtering only two G/L accounts)
2. Get corresponding ITEM for each line of G/L entry

Thank you for any help you may give me.

~skip

vijay_g

Have you look at table "G/L - Item Ledger Relation"(5823); This is in nav 6.0 varsion.

qlikering

Hi Vijay,

I'm using Nav 5.1

chengalasettyvsrao

qlikering wrote:

Hi Vijay,

I'm using Nav 5.1

Above NAV > 5.0 onwards you can use "G/L - Item Ledger Relation" Table ID -5823 to track the G/L entry relation with Value entry.

vijay_g

If you are using 5 or less, then there are four fields in value entry table you can go through these fields.

1. G/L Entry No. (Account)
2. G/L Entry No. (Bal. Account)
3. G/L Entry No. (Interim Acc.)
4. G/L Entry No. (Int. Bal. Acc.)

chengalasettyvsrao

vijay_g wrote:

If you are using 5 or less, then there are four fields in value entry table you can go through these fields.

1. G/L Entry No. (Account)
2. G/L Entry No. (Bal. Account)
3. G/L Entry No. (Interim Acc.)
4. G/L Entry No. (Int. Bal. Acc.)

Beginning in Microsoft Dynamics NAV 5.0, the program uses a relation table, G/L – Item Ledger Relation, to store the relation between value entries and general ledger entries. you cannot find the above fields in NAV >= 5.0 onwards in Value entry table.

vijay_g

Yes i checked.It was only till 4.0 sp3.

qlikering

HI Vijay and chengalasettyvsrao (don't know what your name here.),

Thanks for both yourhelp, I was able to use he G/L - Item Ledger Relation table.
This is what I am looking for since I first work with Navision several years ago.

Regards,

~skip

vijay_g

Your welcome..!!!
Please mark this post as Solved.

qlikering

vijay_g wrote:

Your welcome..!!!
Please mark this post as Solved.

Hi Vijay... I'm new to mibuso and can't find the link for me to mark this post as solved.

I hope you don't mind helping me.... can't really see the link or button.

Thanks again.

chengalasettyvsrao

qlikering wrote:

Hi Vijay... I'm new to mibuso and can't find the link for me to mark this post as solved.

I hope you don't mind helping me.... can't really see the link or button.

Thanks again.

To mark a thread "SOLVED".

1.The Original Poster has to go back to the Origin of the thread.
2.Click on "Edit" button.
3. Attribute field will appear with drop-down default value "None".
4. Originator has to select "Solved' form the drop-down and Submit.

tdata

Hello. Need an answer. Table 5823 is not full, i mean there are not all relation between GL entry and Value entry. Couple quarters are empty, there are no relations. If it is deleted, how to restore table 5823?
Thank you.