Can I build a journal entry table using Alteryx?

[bui195]

I was able to build a workflow to calculate the amounts needed to be post. Now, I'm wondering if I can actually build a table in Alteryx so that those amounts will go to journal entry table. Below is the current output I have:

Here is the journal entry table I want to build (the company code, account, description will be the same all the time). The only thing changed would be the debit and credit amounts based on the calculation. Thank you!

[ShankerV · Accepted solution]

Hi @bui195 

As this query was not addressed yet from yesterday, wanted to support you on this.

Can I build a journal entry table using Alteryx? Yes, based on your requirement.

I do not know the Ledger entries rules/regulation.

I tried to mirrors the output from the input given.

Kindly check whether this is what you are expecting.

I also don't know how company code and Account came into picture in output. Please let me know on that.

Input was: 

Output after run:

Please free to ask if you have more questions.....

Many thanks

Shanker V

[bui195]

thank you so much for your help! it works really well. 

[ShankerV]

Hi @bui195 

Glad that it worked!!! Happy to help!!!!