Can I build a journal entry table using Alteryx?

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!

Best Practices

Accepted answers

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

Can I build a journal entry table using Alteryx.yxmd

All comments

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

Can I build a journal entry table using Alteryx.yxmd

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703