Sort and Validate Exported Data
Voucher-
PO No.
P01011
P01051
P01045
P01012
P01012
P01012
P01012
P01012
P01012
P01000
P01000
P01000
P01000
P01000
P01002
P01001
P01005
P01511
P01512
P01513
P01517
P01517
P00495
P00495
P00495
P00410
P00410
P00400
P00415
P00497
P00411
P00411
P01000
P01511
P01503
P01511
P01022
P01022
P01022
P01022
P01056
P01056
P01056
P01056
P01112
P01112
Unit
CA011
CA011
CA011
CA013
CA013
CA202
CA202
CA202
CA202
CA213
CA213
CA213
CA215
CA215
CA215
CA215
CA215
EU006
EU006
EU006
EU008
EU008
GB200
GB200
GB200
GB200
GB200
GB203
GB203
GB203
GB203
GB203
US001
US001
US001
US001
US002
US002
US002
US002
US002
US002
US002
US002
US002
US002
Account-
Department-
Foreign
Amount
5,-,-,-,-,-,-,-,-,-,368.19
4,023.01
7,485.34
4,-,586.00
7,-,465.01
7,584.00
5,147.11
5,-,769.00
6,-,756.00
6,365.00
3,-,-,-,-,-,879.00
7,375.00
Currency
CAD
CAD
CAD
USD
USD
CAD
CAD
CAD
CAD
CAD
CAD
CAD
CAD
CAD
CAD
USD
USD
EUR
EUR
EUR
EUR
EUR
GBP
GBP
GBP
GBP
GBP
GBP
GBP
GBP
GBP
GBP
USD
USD
USD
USD
USD
USD
USD
USD
USD
USD
USD
USD
USD
USD
Monetary
Amount
5,-,-,-,-,-,-,-,-,-,758.00
5,355.51
7,485.34
4,-,586.00
7,-,465.01
7,584.00
5,147.11
5,-,769.00
6,-,756.00
6,365.00
3,-,-,-,-,-,879.00
7,375.00
Acctg Date
03/10/2019
03/10/2019
03/10/2019
03/10/2019
03/10/2019
03/10/2019
03/10/2019
03/10/2019
03/10/2019
03/11/2019
03/11/2019
03/11/2019
03/11/2019
03/11/2019
03/12/2019
03/12/2019
03/12/2019
03/05/2019
03/05/2019
03/05/2019
03/05/2019
03/05/2019
03/15/2019
03/15/2019
03/15/2019
03/15/2019
03/15/2019
03/15/2019
03/15/2019
03/15/2019
03/15/2019
03/17/2019
03/12/2019
03/12/2019
03/12/2019
03/12/2019
03/12/2019
03/12/2019
03/12/2019
03/12/2019
03/12/2019
03/12/2019
03/12/2019
03/12/2019
03/12/2019
03/12/2019
Period
Year-
-
AM Unit
CA011
CA011
CA011
CA013
CA013
CA202
CA202
CA202
CA202
CA213
CA213
CA213
CA215
CA215
CA215
CA215
CA215
EU006
EU006
EU006
EU008
EU008
GB200
GB200
GB200
GB200
GB200
GB203
GB203
GB203
GB203
GB203
US001
US001
US001
US001
US002
US002
US002
US002
US002
US002
US002
US002
US002
US002
Asset Category Code
14001_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_05
Project
0000CA-CA-
-GB-GB-GB-GB-GB-GB-GB-GB-GB-
-
Invoice
101
11
INV--IN--IN--IN--IN--IN
23
23
23
INV#-
LARS-108
LARS-108
LARS-
IN000012
IN--BI
2034
P12679
P12679
P12679
P12679
P12679
P12679
P12679
P12679
P12679
P12679
FX Rate-
Converted to
CAD
5,-,-,-,-,-,-,-,-,-,758.00
5,-,942.59
6,-,-,-,-,454.98
8,452.94
8,-,-,636.80
1,227.88
1,078.97
1,-,904.88
8,474.68
4,-,-,-,-,-,159.04
9,819.44
Concatenate
Group
Notes
-CA-_-
Direct-CA-_-
Direct-CA-_-
Expense
below threshold - prepare journal entry-CA-_-CA-
Direct-CA-_-CA-
Direct-CA-_-
Direct-CA-_-
Direct-CA-_-
Direct-CA-_-
Direct-CA-_-
Expense
below threshold - prepare journal entry-CA-_-
Expense
below threshold - prepare journal entry-CA-_-
Expense
below threshold - prepare journal entry-CA-_-
Direct-CA-_-
Direct-CA-_-
Direct-CA-_-
Direct-CA-_-
Direct-EU-_-
Direct-EU-_-
Direct-EU-_-
Direct-EU-_-
Direct-EU-_-
Expense
below threshold - prepare journal entry-GB-_-GB-
Direct-GB-_-GB-
Direct-GB-_-GB-
Direct-GB-_-GB-
Direct-GB-_-GB-
Direct-GB-_-GB-
Direct-GB-_-
Direct-GB-_-GB-
Expense
below threshold - prepare journal entry-GB-_-GB-
Expense
below threshold - prepare journal entry-GB-_-GB-
Expense
below threshold - prepare journal entry-US-_-
Direct-US-_-
Direct-US-_-
Direct-US-_-
Expense
below threshold - prepare journal entry-US-_-
Direct-US-_-
Direct-US-_-
Direct-US-_-
Direct-US-_-
Direct-US-_-
Direct-US-_-
Direct-US-_-
Direct-US-_-
Direct-US-_-
Direct