How to - Store User ID into Capacity Ledger Entry Table ?

flesenne

Hello,

I'm looking for a solution to store Used Id in capacity ledger Entry Table.
I added field User ID in the Capacity Ledger Entry table. Then, i tried to get User ID from Item Register table where Capacity Ledger Entry.Entry No >= Item Register.From Capacity Entry No. and Capacity Ledger Entry.Entry No <= Item Register.To Capacity Entry No.

I set the field User ID into Capacity Ledger Entry table as following :
- Data type = Code
- Calc formula = lookup("Item Register"."User ID" WHERE (From Capacity Entry No.<=FIELD(Entry No) AND (To Capacity Entry No.>=FIELD(Entry No))

But for sure i have a problem with this formula.

Could you give me some informations to find the good formula or the way to do what i need ?

Thanks a lot
Best regards

mohana_cse06

create a process only report update the User ID field in Capacity Ledger Entry table.
Flow the User ID from register to ledger while posting for future entries.

flesenne

Thanks for reply but i would like to find good syntax for lookup or other solution without modify any codeunit.