Generate reclass journal entry records

[Mariamfatimamirza]

Hi,

I am trying to create a reclass journal entry based on an existing journal entry. I am attaching a sample input dataset and expected output for the same. Can somebody please help me out on how to generate the reclass entry rows? Thank you

Input:

Expected Output:

[Qiu]

@Mariamfatimamirza 
What is the logic behind this?

I can see the new value for Cost center, Account, and other columns, are we supposed to just assign the value or there is some sort of logic?

[Mariamfatimamirza]

Hi Qiu,

New values for cost center, account, other columns are based on a combination.For example:

1. Cost Center: if cost center is "abc" then replace it by "xyz"
2. Account: This will concatenation of 2 and reversing company code
3. Project Code: This will be "ced"
4. Other fields: "0000"

I can hard code the logic if I understand how to create the new rows.