Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have a workflow that takes data from one system and transforms it into a template that will create multiple journal entries for importing into a financial software. I need to ensure that each entry balances (debits = credits) by date. Each entry will have a minimum of 2 lines but no maximum. All entries will be on a single csv file. In my example screenshot, the entry for 1/1/24 is 4 lines, while the entry for 1/5/24 is 9 lines. What is the best way to filter out all lines for a date that does not balance?
I have a workflow that takes data from one system and transforms it into a template that will create multiple journal entries for importing into a financial software. I need to ensure that each entry balances (debits = credits) by date. Each entry will have a minimum of 2 lines but no maximum. All entries will be on a single csv file. In my example screenshot, the entry for 1/1/24 is 4 lines, while the entry for 1/5/24 is 9 lines. What is the best way to filter out all lines for a date that does not balance?
I created this workflow (also attached as a packaged workflow) based on the screenshot of the GL data that you had posted. Let me know if this is what you were looking for and if you have any questions about the workflow. Thanks!
