You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!