flow one field to item ledger entry.

Hi,

Ho to flow one field to item ledger entry table from purchase line & sales line at posting time. Means the new field is common field for both tables.

Ex: Entries are need to update with new field in Item ledger entry.


Entry No

Entry Type

Posting Date

item

New Field

1

Purchase

2014-11-29

It0001

xxxxxxxx

2

Sales

2014-11-29

It0001

xxxxxxxx

3

Transfer Shipment

2014-11-29

It0001

xxxxxxxx

Can any one please help me.

You may find the answer you’re looking for in c_10201 Transfer Custom Fields. You’ll probably also need to add your new custom field to one of the Journal Line records, and populate it in posting codeunits, probably c_80 and c_90.

Hello Srinivas,

  1. First you may add the field ‘New Field’ in Tables: Sales Line, Item Journal Line, Item Ledger Entry, and Purchase Line.
  2. Add code in Codeunit: Item Jnl.-PostLine(22)->Function: InitItemLedgerEntry()->ItemLedgEntry.“New Field” := “New Field”; and Codeunit: Sales-Post(80)-> Function: PostItemJnlLine()-> ItemJnlLine.“New Field” := “New Field”; and
    Codeunit: Purch.-Post(90)-> Function: PostItemJnlLine()-> ItemJnlLine.“New Field” := “New Field”;

Good luck!!!
Regards