Link Between value Entry and G/L Entry???

Silva

Hi,

I have a question regarding the connection or the Link of value entry to G/L entry?? What is there link?? it is document no. or Transaction No?? hoping for your reply??

Thanks

reema

In 4.0 sP3 -
In value entry u have two field s
1. G/L entry no ( Account No)
2. G/L entry No ( bal Account No)


When it comes to Nav 5.0 & 2009

U don’t have direct relation in Value entry table.
But in G/L entry u can find the following fields

Document No = U have the Posted Invoice No.
External document no. = Vendor Invoice no

Deep

The document number is used as a link between G/L entry and Value entries.

bbrown

In versions 5.0 and above the relation is established by table 5823 "G/L - Item Ledger Relation".

In versions prior to 5.0 the relation is established by the "Value Entry No." on table 17 "G/L Entry".

itinkiam

I'm checking this out in V2009Sp1 and am finding that at least here, the only time this relation is made is when the Source is the INVTPCOST as per the "Source Code Setup". I'm looking at a Cronus Database in US. Is there a setup or something that would make the relationship 1 - 1 similar to what we had available in 4.0?

Anybody know why the direct link on the Value Entry table got dumped? I don't get it.

](*,) DOH!! :oops:
From the Value Entry, there is a function button to show plainly the relation. I'll look a little harder next time before posting

ara3n

There relationship is stored in G/L - Item Ledger Relation.

The reason is that you can have manu GL Entry per value entry.
Especially when you have post the invoice entry. This reverses the expected entry and posts the actual.


You can also post Many value entry to one GL entry when you are summarizing per posting group.

amphysvena

ara3n wrote:

There relationship is stored in G/L - Item Ledger Relation.

The reason is that you can have manu GL Entry per value entry.
Especially when you have post the invoice entry. This reverses the expected entry and posts the actual.


You can also post Many value entry to one GL entry when you are summarizing per posting group.

Hi ara3n,
i'm interested in what you said, that one GL Entry can have many value entries when you are summarizing per posting group.
How to do this?
Many thanks for the assistance.

Regards

ara3n

You turn off automatic cost posting to GL in Inventory setup.

Then week or monthly run the POST Inventory Cost to GL report with option per posting group instead of detail