Creating a JE from data

[tiverson]

I have some journal entries that I need to create from a data file:

Data:

Output:

 JE:/

I would like to have a journal entry on a separate tab for each Co code and contract type.

I will be using a text input template, then populate it from the data.

The JE will need to lookup the co code from the data and create a line for each profit center and each GL account combination.

The Amount entered onto the JE for the lookup GL account would be the opposite sign from the data.

The offset account would be the 0044118000 account.

I hope I have been able to explain this clearly. 

Thanks,

Todd

[gaoa · Accepted solution]

Hi @tiverson 

Attached workflow for your review. Let me know if it works as expected.

Thanks! 🙂