Update Item Ledger Entry when posting Sales Order

liizz · 2012-07-26

Hi all,

I have a Sales Order which I need to post, by doing Ship only.

I want to know where does the Item Ledger Entry got updated? In which codeunits,trigger does it fire an entry in the Item Ledger Entry.

Thanks to reply...

Liizz

mohana_cse06 · 2012-07-26

Check InitItemLedgEntry function in Codeunit 22

KYDutchie · 2012-07-26

Hi,

This happens in codeunits 80 and 22. This is pretty easy to find, did you try to find it?

Thanks,

Willy

liizz · 2012-07-26

Yes on the codeunit 22.

Infact, I want to populate a customised field in the Item Ledger Entry table on Posting a Sales Order, i.e only doing Ship.

The field is flowing fine on the Sales Shipment Header as I am using it on the Sales Line part.

Please help where I can add this code?

Thanks
Liizz

mohana_cse06 · 2012-07-26

liizz wrote:

Please help where I can add this code?

Is the task given to you or to us?
Cant you try by adding the code in above function?

liizz · 2012-07-26

But I have added the code in the function you mentioned.
The field is not getting updated in Item Ledger Entry table.

Thanks
Liizz

mohana_cse06 · 2012-07-26

Did you assign field to ItemJnlLine in PostItemJnlLine function Codeunit 80?

liizz · 2012-07-26

Hi.

But why do I have to use ItemJnlLine too?

Coz I want to update a field in Item Ledger Entry as that field is already flowing in the Sales Shipment Line.

Thanks to clarify me. Am a bit confused on it.

Liizz

Alex_Chow · 2012-07-26

It needs to go to the journal first before it goes to the ledger. This is how any accounting system can guarantee the integrity of the transactions.

You should probably get a senior person to help you with this. The forum is not a place to teach you how to program or how an accounting system is suppose to work.

dans · 2012-07-26

Document -> Journal -> Ledger. The system needs to follow this flow.

liizz · 2012-07-31

Ok.

Thanks a lot for your help.

The functional consultant did not explain me the concepts of how the data finally got into the Item Ledger Entry.

Liizz

Alex_Chow · 2012-07-31

liizz wrote:

Ok.

Thanks a lot for your help.

The functional consultant did not explain me the concepts of how the data finally got into the Item Ledger Entry.

Liizz

Hmm.. I thought that was your job?

liizz · 2012-08-01

Alex Chow wrote:

liizz wrote:

Hmm.. I thought that was your job?

Am just a junior developer.

Update Item Ledger Entry when posting Sales Order

Comments

Categories