Generate reclass journal entry records

Question

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:

Generate reclass journal entry.yxmd

Mariamfatimamirza · Answer

Hi Qiu,

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

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

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

Qiu · Answer

@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?