Load InventSum.PhysicalInvent after posting inventory adjustment

Finance and Operations/AX Developer Forum
1

Hi guys,

I have this table:

  • Pallets_Table (with 4 fields)
  1. palletId
  2. ItemId
  3. InventBachId
  4. Quantity

I want to refresh the Quantity field with the current value of InventSum.PhysicalInvent after post invent adjustment.

¿Where is the best place to do the update? ¿Any example?

Thanks for advance.