on 2023 Dec 28 5:18 PM
Hello experts. I have created a canvas report using Employment, Global Job Information. The report generates duplicates but only for some records, and I am unable to determine the reason for these duplicates or how to eliminate them. Can someone point me in the right direction?
Request clarification before answering.
Well that is quite the challenge, because it could be due to a lot of things (the main reason is at least one of the tables i.e. job info) containing multiple records and thereby causing the line that looks like a duplicate for you.
Your best shot is taking 1 employee (filter for that) that has one of those duplicate lines and one that does not. Then based on that determine what records you are seeing (sequence, effective date etc. help) and start comparing and contrasting the amount of records in the report vs. on employee level. Often times it's sequences in job info, multiple pay components, concurrent employments, pay ranges that take the entire table on top of the employee record etc., but comparing and contrasting is the only way to get to the bottom of it with sample cases.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.