Icon

XML invoice-specifications M-drive

Select projectcode (needs work)

START FLOW

END FLOW

Select supplier

Select administration

Decision: spec or no spec?

Connect error + processed + no spec

Comment processed

File connector

Check: everything okay?

XML-ify the specifications

Check: netamount = lineamount?

Put spec XML together

XML-ify the general info

Building based on address

Asset based on description

Join all projectcodes

Specification period

Description + codes

Cost unit based on license plate

Building based on description

Move file input -> archive

Comment Check projectcode

Rapportagedatum

Put all XML together

GBR

Write XML per administration

Write invoice status

Creditline

Line-amount per GBR

FreeNumbers
Column to XML
if only one choice
Expression Row Filter
FreeTexts
Column to XML
if multiple choice
Expression Row Filter
Column to XML
End IF
FreeFields
XML Column Combiner
Cross Joiner
Column to XML
Math Formula
FreeFields
XML Column Combiner
GBR
Column to XML
GBR
Column to XML
linedate
Column to XML
String Manipulation
Expression Row Filter
String Cleaner
Joiner
input ->archive
Transfer Files (Table)
Expression Row Filter
String to Number
Empty Table Switch
Cell Splitter
GroupBy
XPath
Ungroup
Overzicht KD
Excel Reader
Cross Joiner
sort invoice-XMLper admin
Group Loop Start
choose excel pagebased on admin
Table Column to Variable
GLEntries
XML Row Combiner
Rule-based Row Filter
String Manipulation
eExact
Column to XML
Joiner
Column Filter
anchorspec ID
XPath
Duplicate Row Filter
String Manipulation
Expression Row Filter
XML Writer
Joiner
Duplicate Row Filter
Joiner
CommentCheck projectcode
Expression
String Manipulation (Variable)
Joiner
Expression Row Filter
Loop End
Table Row to Variable
description
XPath
spec period
XPath
Column Appender
inv period
XPath
Row Filter
Row Filter
Expression
Sorter
adres?
Cross Joiner
Column Filter
Column Filter
Expression
GroupBy
choose availableprojectcode
Rule Engine
Expression
Joiner
Cross Joiner
Column Filter
Cell Splitter
Column Filter
pick mostrelevant
Rule Engine
Column Filter
Group Loop Start
if not basedon desc
Expression Row Filter
IF Switch
Column Filter
Ungroup
if basedon desc
Expression Row Filter
GroupBy
Cross Joiner
Rule-based Row Filter
End IF
archive
List Files/Folders
Column Appender
String Manipulation
Column Resorter
GroupBy
periode!
String Manipulation
String to Number
String to Date&Time
Loop End
Column Filter
String Manipulation
Joiner
RowID
Joiner
Path to String
String Manipulation
CSV Writer
Math Formula
Column Filter
Cross Joiner
Concatenate
String Manipulation
String to Number
Joiner
End IF
Row Filter
Rule-based Row Splitter
String Manipulation
Duplicate Row Filter
Debit
Column to XML
Column Appender
Duplicate Row Filter
Math Formula
String Manipulation
Rule Engine
Column Filter
Math Formula
currencycode
Column to XML
End IF
Rule-based Row Splitter
Credit
Column to XML
'niet bijzondere'specificatie info
XPath
Column Filter
End IF
CostUnit
Column to XML
Debit
Column to XML
costunit
Column to XML
End IF
Joiner
Commentnot equal
Constant Value Column Appender
Expression Row Filter
Expression Row Filter
End IF
Expression Row Filter
String to Date&Time
Column Filter
Sorter
Expression Row Filter
End IF
costcenter
Column to XML
Rule Engine
Column Appender
projectcode
Column to XML
Column Appender
journal code
Column Filter
Column Filter
Description
Column to XML
Rule Engine
String to Path (Variable)
Rule Engine
String Manipulation (Variable)
Joiner
Rule Engine
Date&Time Configuration
document info
Column Filter
Cross Joiner
Rule Engine
filter ->input=archive
Expression Row Filter
Path to String
Cross Joiner
Path to String
(inv)date
Column to XML
Column Resorter
delivery
Column to XML
Column Appender
Cross Joiner
documentdate
Column to XML
String Cleaner
amount
XML Column Combiner
String Manipulation
Duplicate Row Filter
String to Number
Expression Row Filter
Column Filter
Empty Table Switch
CommentProjectcode not found
Expression
XPath
Column Filter
End IF
GroupBy
End IF
Rule-based Row Filter
String to Number
Expression
Column Appender
Wait...
Column Filter
Table Row to Variable Loop Start
stuur lege tabel (bij wel gelijk) naar xml (dan komendaar niet tig tabellen samen)
Empty Table Switch
Date&Time Configuration
input
List Files/Folders
als niet gelijk is ->behoud tabel
Expression Row Filter
error reason
Constant Value Column Appender
Column Appender
description
Column to XML
collect invoice-XML
Loop End
Column Appender
error reason
Constant Value Column Appender
date
Column to XML
error reason
Constant Value Column Appender
foreign amount
Column to XML
Constant Value Row Appender
currency
Column to XML
Constant Value Row Appender
journal
Column to XML
Expression Row Filter
String Manipulation
Column Appender
herschrijf naaralgemene vorm
XSLT
End IF
Empty Table Switch
Column Filter
Column Resorter
schrijf status+ sla op
CSV Writer
Column Filter
FinEntryLine
XML Column Combiner
Column Filter
Column to XML
LOOPfactuur
XML Reader
End IF
xslt schema
XML Reader
flow + no flow
End IF
no flow + errors
End IF
End IF
Column Appender
general
XPath
String Manipulation
Date&Time Configuration
Column Filter
supplier
XPath
file path
Table Creator
specificaties
XPath
Table Row to Variable
String Manipulation
decision_basissuppl_mapping
Excel Reader
receiver
XPath
Column Appender
Cross Joiner
Column Filter
String to Path (Variable)
decision_basisadm_mapping
Excel Reader
status no spec
Constant Value Column Appender
Expression Row Filter
Column Appender
Expression Row Filter
Excel Reader
koppeling aan mapmet 'alles'
Local File System Connector
koppel XMLreader
Column Filter
project nr?
Joiner
invoicenumberinvoicedatecurrencycode
XPath
status error
Constant Value Column Appender
String Manipulation
Cross Joiner
Constant Value Column Appender
supplier# + admin#
Column Filter
XPath
Column Appender
IF Switch
decision_basisspec_yes_no
Excel Reader
Column Filter
match?
Expression Row Filter
String Manipulation
Cross Joiner
String Cleaner
String Manipulation
project_codes
Excel Reader
IF Switch
Column Combiner
Column Filter
select project codebased on address
Joiner
geen match =geen flow
Empty Table Switch
Sorter
String Manipulation
Duplicate Row Filter
XPath
ID + address
Joiner
niet herkend= error
Empty Table Switch
niet herkend= error
Empty Table Switch
String Cleaner
Variable to Table Row
Row Filter
Date Shifter
String Manipulation
String to Date&Time
String to Date&Time
String Manipulation
String Cleaner
delivery address
XPath
String Cleaner
file name
String Manipulation
Column Filter
Column Renamer
Joiner
Column Filter
XML Reader
Column Filter
Expression Row Filter
Cross Joiner
Row Filter
Date
Column to XML
Unpivot
CostCenter
Column to XML
Description
Column to XML
Concatenate
Currency
Column to XML
ProjectCode
Column to XML
GLEntry
XML Row Combiner
Amount
XML Column Combiner
Credit
Column to XML
Row Filter
FinReferences
Column to XML
Delivery
Column to XML
extra_BookingDays
Excel Reader
Empty Table Switch
Expression Row Filter
Column Filter
Column Appender
Joiner
DocumentDate
Column to XML
IF Switch
Expression

Nodes

Extensions

Links