Icon

Tax Audit Workflow_​BERMQ.knwf 1

IDEA RFBILA Check

IDEA RFBILA Check

Automatically data analysis process for tax audit solution.

Input Source Folder Current Status of ChecksCompleteness- Missing Tables- Missing ColumnsCorrectness- All booking periods are available- Missing or double-booking periods- Comparable booking periods- Total amout of all bookings- Total amout of single accounting documents Own Balance Sheet SAP Balance Sheet Take Data fromRow 8 upChoose Period 1Change ValueRows intoNumberGroup byAccount noJoin BBACCwith FI_POSSum BBACCwith FI_POSvaluesJoinBBACC/FI_POSwith Balance SheetCalcualteDifferencesDelete Rowswith no valuesInsert valuewhere no valueis filled inInsert valuewhere no valueis filled inRename 2value ColumnsFI_POSNode 35Summen checkmust be 0Sum checkdifferencesmust be 0Choose FolderLocation ofBSETBSETDelete First8 RowsAD_POSLocation ofAD_POSDelete First8 RowsBewertungsbereicheSum checkmust be 0Group byBELNRShould be emtyLocation ofTAXCODDelete First8 RowsTAXCODOnly TAXDLocation ofRF011QLocation ofRF011ZRF011QRF011ZDelete First8 RowsDelete First8 RowsLocation ofBalance SheetStart LoopBalance SheetEnd LoopTake Data fromRow 10 upDelete allColumn w/loany valueTake only DataSets withCompany valueDelete notnecessary RowsRenamenecessarycolumnsCreate newAccount Columnswith 10 digitsGroup byAccouting No.RenameColumnsSum checkmust be 0Node 98Node 110Save result asBalance SheetNode 112Rename HeadersCreate new columnwith BBACCaccountComplete newcolumn withFI_POS accountNode 119Take only1 RowRename HeadersRename HeadersRename HeadersRename HeadersRename HeadersNode 130Node 131Choose onlyCompanyColumnNode 139Node 148Create new Columnwith Account No.Node 150Create new Columnwith Account No.Same result asJava SnippetLocation ofFI_POSGroup byAccountRename 2value ColumnsChange ValueRows intoNumberSelection of7 ColumnsTake Data fromRow 8 upSum checkmust be 0Rename HeadersMeta NodeLocation ofBBACCMeta NodeBBACCMeta NodeMeta NodeMeda NodeMeta NodeMeta NodeNode 201Meta NodeMeta NodeMeta NodeNode 215Node 216Group by MONATNode 236Node 246Node 247 Row Filter Row Filter String To Number GroupBy Joiner Math Formula Joiner Math Formula Row Filter Missing Value Missing Value Column Rename File Reader Row Filter GroupBy GroupBy List Files Row Filter File Reader Row Filter File Reader Row Filter Row Filter GroupBy GroupBy GroupBy Row Filter Row Filter Row Filter File Reader Row Filter Row Filter Row Filter File Reader File Reader Row Filter Row Filter Row Filter Table Row ToVariable Loop Start Excel Reader (XLS) Loop End Row Filter Row Filter Joiner Row Filter Column Rename Java Snippet GroupBy Column Rename GroupBy Joiner Excel SheetAppender (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Column Rename(Regex) String Manipulation String Manipulation GroupBy Row Filter Column Rename(Regex) Column Rename(Regex) Column Rename(Regex) Column Rename(Regex) Column Rename(Regex) Row Filter Row Filter Column Filter Create File Name Missing Value Java Snippet RowID Java Snippet Rule Engine Row Filter GroupBy Column Rename String To Number Column Filter Row Filter GroupBy Column Rename(Regex) Reading File Name Row Filter Reading File Name File Reader Reading File Name Reading File Name Reading File Name Reading File Name Reading File Name Timer Info Columns Counter Read StandardViews Metadata Columns Counter Joiner String Manipulation GroupBy Regex Split Views Counter Excel Writer (XLS) Input Source Folder Current Status of ChecksCompleteness- Missing Tables- Missing ColumnsCorrectness- All booking periods are available- Missing or double-booking periods- Comparable booking periods- Total amout of all bookings- Total amout of single accounting documents Own Balance Sheet SAP Balance Sheet Take Data fromRow 8 upChoose Period 1Change ValueRows intoNumberGroup byAccount noJoin BBACCwith FI_POSSum BBACCwith FI_POSvaluesJoinBBACC/FI_POSwith Balance SheetCalcualteDifferencesDelete Rowswith no valuesInsert valuewhere no valueis filled inInsert valuewhere no valueis filled inRename 2value ColumnsFI_POSNode 35Summen checkmust be 0Sum checkdifferencesmust be 0Choose FolderLocation ofBSETBSETDelete First8 RowsAD_POSLocation ofAD_POSDelete First8 RowsBewertungsbereicheSum checkmust be 0Group byBELNRShould be emtyLocation ofTAXCODDelete First8 RowsTAXCODOnly TAXDLocation ofRF011QLocation ofRF011ZRF011QRF011ZDelete First8 RowsDelete First8 RowsLocation ofBalance SheetStart LoopBalance SheetEnd LoopTake Data fromRow 10 upDelete allColumn w/loany valueTake only DataSets withCompany valueDelete notnecessary RowsRenamenecessarycolumnsCreate newAccount Columnswith 10 digitsGroup byAccouting No.RenameColumnsSum checkmust be 0Node 98Node 110Save result asBalance SheetNode 112Rename HeadersCreate new columnwith BBACCaccountComplete newcolumn withFI_POS accountNode 119Take only1 RowRename HeadersRename HeadersRename HeadersRename HeadersRename HeadersNode 130Node 131Choose onlyCompanyColumnNode 139Node 148Create new Columnwith Account No.Node 150Create new Columnwith Account No.Same result asJava SnippetLocation ofFI_POSGroup byAccountRename 2value ColumnsChange ValueRows intoNumberSelection of7 ColumnsTake Data fromRow 8 upSum checkmust be 0Rename HeadersMeta NodeLocation ofBBACCMeta NodeBBACCMeta NodeMeta NodeMeda NodeMeta NodeMeta NodeNode 201Meta NodeMeta NodeMeta NodeNode 215Node 216Group by MONATNode 236Node 246Node 247 Row Filter Row Filter String To Number GroupBy Joiner Math Formula Joiner Math Formula Row Filter Missing Value Missing Value Column Rename File Reader Row Filter GroupBy GroupBy List Files Row Filter File Reader Row Filter File Reader Row Filter Row Filter GroupBy GroupBy GroupBy Row Filter Row Filter Row Filter File Reader Row Filter Row Filter Row Filter File Reader File Reader Row Filter Row Filter Row Filter Table Row ToVariable Loop Start Excel Reader (XLS) Loop End Row Filter Row Filter Joiner Row Filter Column Rename Java Snippet GroupBy Column Rename GroupBy Joiner Excel SheetAppender (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Column Rename(Regex) String Manipulation String Manipulation GroupBy Row Filter Column Rename(Regex) Column Rename(Regex) Column Rename(Regex) Column Rename(Regex) Column Rename(Regex) Row Filter Row Filter Column Filter Create File Name Missing Value Java Snippet RowID Java Snippet Rule Engine Row Filter GroupBy Column Rename String To Number Column Filter Row Filter GroupBy Column Rename(Regex) Reading File Name Row Filter Reading File Name File Reader Reading File Name Reading File Name Reading File Name Reading File Name Reading File Name Timer Info Columns Counter Read StandardViews Metadata Columns Counter Joiner String Manipulation GroupBy Regex Split Views Counter Excel Writer (XLS)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: KFZIR
Created at: 2020-03-12
On NodePit since: 2020-07-09
Last update: 2024-04-23
Created with KNIME version: v4.1.3

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!