Looking for advice regarding creation of a report to load details into Costing for Persons
Summary:
We currently have a report in place which gets run daily to load information via HDL to load into the Costing for Persons. It has been made aware the report is not working 100%. For example it's not able to load into the costing for persons if the following scenario.
Costing effective date is for example 01/12/2024. Assignment row at the time was 01/12/2024. This loaded okay. Then the assignment row was deleted and the latest effective date is 01/09/2024. Costing effective date is for example 01/12/2024. Therefore the HDL won't load as it can't load in between.
I need the report to be able to load these records. How are others using this field in your organization? And can you see how to improve the data model? Thank you.