Relationship between value entries and G/L entry

RachelSoon

Hi All,
I am looking for the linkage between the value entry and G/L entry.

Knowing that the system will only keep track the G/L entry no at Value Entry (as G/L Entry No. (Account)), however, it's only keep track for shipement/receipt, but not invoices.

is there any method/table that provide me the information?

Thank you.

Regards
Rachel

kine

Sorry, I do not understand your problem. Each Value entry is connected to some G/L Entry... What do you need?

RachelSoon

Hi Kine,
Thank you for replying.
Here is the step and the information that i am looking for :

1) a purchase invoice (PurchInv0001) with multiple items at the purchase line, say ItemA, ItemB.
2) Select on the Item Ledger Entry for the ItemA for the PurchInv0001.
3) then go to the Value entry for the Item Ledger entry selected.
4) select the value entry for ItemA (say the there is cost posted to G/L for this entry).
5) do the navigate.
6) will see the G/L entry under the "Table Name" column at the Navigate screen. Click "Show".
7) there will be a list of G/L entries. The list of G/L entry includes the G/L entry (eg direct cost entry) for ItemA and ItemB.

what i am looking for is : only the entries for ItemA.

I can not find any unique key to retrive the G/L entry for ItemA only.

TQ.

Regards
Rachel

Marije_Brummel

I do not think there is a link between Item entries and gl entries.

The gl entries are created using the posting groups.

If you want this to be you need to change the posting buffer in codeunit 80 and 90.

kine

It is not possible, because Navigate is searching only for Document No. and Posting date (if entered). You are not able to filter it only for some item in easy way. It means you need to change whole Navigate functionality to pass through the filter for item and be able to select G/L entries for only some item. And this is not possible, because G/L entries are not depending on Items etc. G/L entries are only financials entries...

Marije_Brummel

You can simply add the item no. to the g/l entries

You can populate this field via the posting buffer in codeunit 80/90

kine

Yes, but you need to be sure that the g/l entries will be crated 1:1 and will be not grouped whe the posting groups are same...

Marije_Brummel

Most of our customer want the description of the salesline in the g/l entries. Basicly the same thing, add this to the buffer and the bufferkey and you're done. Very simple customisation.

kine

I know, I made this customization too... :-)

Marije_Brummel

Wow! I love the christmas emoticons

gri

maybe you should take a closer look to the "value entry no." field from the g/l entry table.
:roll:

Marije_Brummel

gri wrote:

maybe you should take a closer look to the "value entry no." field from the g/l entry table.
:roll:

This is blank at my testposting... Am I doing something wrong?

Marije_Brummel

From Navision "Help"

Value Entry No. Field
The G/L Entry Table


The program automatically fills in this field.

If the entry has a corresponding entry in the Value Entry table, the number is copied from the Entry No. field. Otherwise, the field is blank.

Marije_Brummel

It is not possible to have a 1:n relation with just one field like this.... :?

gri

in cronus, with automatic cost posting checked, when i post two item journal lines (let's say two purchases), i'll get two value entries and four g/l entries.
each value entry number is written in the corresponding g/l entries.
it's a 1:2 relationship

of course, if you do not post automaticly the cost in the accounting and use post inventory cost to gl batch job with the posting method switched to "per posting group", then you will have a 1:many relationship and the "value entry number" field will remain blank.

did you testpost in cronus?

Marije_Brummel

Yes, I've tested this and you are correct about this.

If you use this option more g/l entries are created. But the orriginal kost entry that is also created when this option is not used also remains blank.

gri

you have to decide at some point what is more important to you: to be able to track gl entries for each item movement or to have a smaller and more robust database.
such is life, everything has a cost :twisted:

since rachel mentioned that she finds a "list" of gl entries, i presume that, in her configuration, the cost is posted per entry.