Copy amount to many different combination
Summary:
Hi,
I need some ideas for my case. So, in my case, I want to copy the amount from the specific combination to many combinations (Entity-Division-Account level), currently, I'm using calc script with the DATACOPY function, but it takes so many rows to create this calc script (I map each pair of the entity-div-account) and I don't want to make this too hardcoding, because probably in the future, my client might be updating the entity/div/account that will be used.
Also, this amount will be copied with the scheduled job (probably hourly), not just one time.
Please check the table below to make it clearer the source and target combination: