Can I build a journal entry table using Alteryx?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Best Practices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you so much for your help! it works really well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
