Passing a Item card field to the Item Ledger Entries Table

rico1931

Hi Everyone,

I have a field on the Item card called Inventory Posting group that I would like to show on the Item Ledger Entries page. It's been a while since I've had to do this so I'm asking for a quick refresher.

I went to the Item Ledger Entry table in the development environment and put in the new field into my range of 50000 with the exact name of the field from the Item Card " Item Category Code " Data Type = code and length is 10 the same as the item card... after this I forgot what to do lol.

Any guidance from this point will help tendentiously to just populate the table.. I can modify the page so users can see it on my own.

Thank you!

postsaurav

Hi,

Ok so for the First one is -

1. the Field that you added in Item Ledger Entries - Navigate to its properties and change these -
FieldClass = FlowField
CalcFormula = Lookup(Item."Item Category Code" WHERE (No.=FIELD(Item No.)))

Add Field to page.

** With this if you change item category at item, the item ledger entry will show the new value even the posting would have happened with some other value in item category code.

postsaurav

Hi,

Do you want to show the current item category code in Ledger Entries.
OR

Do you want to Update existing data on item ledger entries with value in New Field

OR

You want to data to be posted when the item is being used in say sales document / purchase document / journals / manufacturing e.t.c

rico1931

Hi,

Thanks and great question... Which ever is easiest! I'm thinking the easiest would be to show the current item category code in the ledger entries from the item card. Ideally though I'm thinking the 3rd.. to post the data when the transaction for sales/purchase/journals/mfg orders are posted. At this point I'm willing to take whatever is easiest/fastest to implement

Thank you

postsaurav

Hi,

Ok so for the First one is -

1. the Field that you added in Item Ledger Entries - Navigate to its properties and change these -
FieldClass = FlowField
CalcFormula = Lookup(Item."Item Category Code" WHERE (No.=FIELD(Item No.)))

Add Field to page.

** With this if you change item category at item, the item ledger entry will show the new value even the posting would have happened with some other value in item category code.

rico1931

Thank you!!!