@dhisss
Your trouble comes from the item_code=item_code. This will always return a true and thus you will get the first record in item_col all the time.
Consider the following formula to replace yours:
Clear(nd6_stockReport);
With({_user: LookUp(user, email=User().Email},
ForAll(
nd6_standart as _nd6,
Patch(nd6_stockReport,
Defaults(nd6_stockReport),
{
month:Text(_nd6.month_stockcount),
region: _user.region,
ship_to: _user.code,
distributor: _user.name,
return: _user.return,
item_code: LookUp(item_col, item_code = _nd6.item_code, return),
item_name: _nd6.item_name,
main_stokSistem: Value(_nd6.mainstokSistem)
}
)
)
);
Navigate(distributor_home)
I hope this is helpful for you.
