I need a solution to populate the WHS_Movements table in the database of my application. This table has the following fields:
- Input (Number)
- ItemID (Items)
- Location (WHS_Locations)
The data source would come from a set state (repeating group).
The idea is to create a stock movement for a warehouse. When the warehouse associate moves one or more items from one location to another. For example, they take a pallet from a rack and transport it to another location. But this pallet can contain several items, and the associate needs to select the items they are moving and the quantity of each one.