Hi there,
Recently I have received a payment workbook containing 2 Sheets (USD & EUR)
and I would like to Transfer to a new workbook named purchase summary:
Here is a selection of USD payment:
[TABLE="width: 2338"]
<tbody>[TR]
[TD][TABLE="width: 2338"]
<tbody>[TR]
[TD]Course type[/TD]
[TD]Month[/TD]
[TD]Description[/TD]
[TD]Invoice No.[/TD]
[TD]Lecturer[/TD]
[TD]Book[/TD]
[TD]Description[/TD]
[TD]Gross amount[/TD]
[TD]TAX[/TD]
[TD]TAX
amount[/TD]
[TD]Net Amount[/TD]
[TD]Invoice
Date[/TD]
[TD]Due Date[/TD]
[TD]exchange[/TD]
[TD]Noted[/TD]
[TD]Recorded[/TD]
[TD]review date[/TD]
[TD]accepted[/TD]
[TD]Classification[/TD]
[TD="colspan: 2"]Type [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic [/TD]
[TD="align: right"]43191,00[/TD]
[TD]Purchase [/TD]
[TD="align: right"]89854782,00[/TD]
[TD]ARDS[/TD]
[TD]C-0122[/TD]
[TD]NIO2541[/TD]
[TD] $ 17.400,00 [/TD]
[TD="align: right"]0%[/TD]
[TD]$ - [/TD]
[TD] $ 17.400,00 [/TD]
[TD="align: right"]1-4-2018[/TD]
[TD="align: right"]1-5-2018[/TD]
[TD] $ 1,23 [/TD]
[TD][/TD]
[TD]ü[/TD]
[TD="align: right"]11-4-2018[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic [/TD]
[TD="align: right"]43191,00[/TD]
[TD]Purchase [/TD]
[TD="align: right"]5454125,00[/TD]
[TD]AAC[/TD]
[TD]C-0122[/TD]
[TD]NIO2542[/TD]
[TD] $ 500,00 [/TD]
[TD="align: right"]0%[/TD]
[TD]$ - [/TD]
[TD] $ 500,00 [/TD]
[TD="align: right"]1-4-2018[/TD]
[TD="align: right"]1-5-2018[/TD]
[TD] $ 1,23 [/TD]
[TD][/TD]
[TD]ü[/TD]
[TD="align: right"]11-4-2018[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]450,00[/TD]
[TD="align: right"]43221,00[/TD]
[TD]Purchase [/TD]
[TD="align: right"]5465213,00[/TD]
[TD]ARDS[/TD]
[TD]C-0251[/TD]
[TD]NIO2543[/TD]
[TD] $ 85.000,00 [/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0,00[/TD]
[TD] $ 85.000,00 [/TD]
[TD="align: right"]5-3-2018[/TD]
[TD="align: right"]5-4-2018[/TD]
[TD] $ 1,23 [/TD]
[TD][/TD]
[TD]ü[/TD]
[TD="align: right"]8-3-2018[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]900002,00[/TD]
[TD="align: right"]43221,00[/TD]
[TD]Purchase [/TD]
[TD="align: right"]4412154,00[/TD]
[TD]AAR[/TD]
[TD]C-0251[/TD]
[TD]NIO2544[/TD]
[TD] $ 542.563,00 [/TD]
[TD="align: right"]0%[/TD]
[TD]$ - [/TD]
[TD] $542.563,00 [/TD]
[TD="align: right"]27-3-2018[/TD]
[TD="align: right"]27-3-2018[/TD]
[TD] $ 1,24 [/TD]
[TD][/TD]
[TD]ü[/TD]
[TD="align: right"]28-3-2018[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="6"><col><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]
Here is a selection of the EURO payment:
[TABLE="width: 2338"]
<tbody>[TR]
[TD]Course type[/TD]
[TD]Month[/TD]
[TD]Description[/TD]
[TD]Invoice No.[/TD]
[TD]Lecturer[/TD]
[TD]Description[/TD]
[TD]gross amount[/TD]
[TD]TAX[/TD]
[TD]TAX
amount[/TD]
[TD]net amount[/TD]
[TD]Invoice Date[/TD]
[TD]Due Date[/TD]
[TD]exchange[/TD]
[TD]Noted[/TD]
[TD]Recorded[/TD]
[TD]review date[/TD]
[TD]accepted[/TD]
[TD]reference[/TD]
[TD="colspan: 2"]Classification[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic[/TD]
[TD="align: right"]43221,00[/TD]
[TD]Purchase[/TD]
[TD="align: right"]585433,00[/TD]
[TD]DNJK[/TD]
[TD]office supplies[/TD]
[TD="align: right"]261,15[/TD]
[TD="align: right"]23%[/TD]
[TD="align: right"]48,83[/TD]
[TD="align: right"] 212,32[/TD]
[TD="align: right"]30-4-2018[/TD]
[TD="align: right"]14-5-2018[/TD]
[TD="align: right"]1,00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11-4-2018[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic[/TD]
[TD="align: right"]43221,00[/TD]
[TD]Purchase[/TD]
[TD="align: right"]58952,00[/TD]
[TD]JHN[/TD]
[TD]service charge on site[/TD]
[TD="align: right"]1660,50[/TD]
[TD="align: right"]23%[/TD]
[TD="align: right"]310,50[/TD]
[TD="align: right"] 1.350,00[/TD]
[TD="align: right"]27-4-2018[/TD]
[TD="align: right"]27-5-2018[/TD]
[TD="align: right"]1,00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12-4-2018[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]695,00[/TD]
[TD="align: right"]43221,00[/TD]
[TD]Purchase[/TD]
[TD="align: right"]451259,00[/TD]
[TD]KIJ[/TD]
[TD]consultancy service [/TD]
[TD="align: right"]317,34[/TD]
[TD="align: right"]23%[/TD]
[TD="align: right"]59,34[/TD]
[TD="align: right"] 258,00[/TD]
[TD="align: right"]30-4-2018[/TD]
[TD="align: right"]14-5-2018[/TD]
[TD="align: right"]1,00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]13-4-2018[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="6"><col><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
End result:
so basically, I would like to Transfer match the invoice type and the respective period of the invoice date. (e.g. all the mechanic rows and the respective invoice Dates period that falls within April 2018) would Transfer to the summary sheet.
However, by only transfering specific columns which is align with the summary sheet. (USD sheet: A - summary A; USD sheet D - summary B; USD E - summary C; USD G - summary D; USD L - summary E; USD N - summary F; USD K - summary G; USD S - summary J;EUR A - summary A; EUR D - summary B; EUR E - summary C; EUR F - summary D; EUR K - summary E; EUR M - summary F; EUR J - summary H; EUR S - summary J)
Not quite sure if it is possible to use formulas if Aggregate small columns combined and just drag it down or VBA would do the tricks.
Please lend me a helping Hand
would be very much appreciated!
Thank you in advance.
[TABLE="width: 1077"]
<tbody>[TR]
[TD]Invoice type[/TD]
[TD]Invoice no.[/TD]
[TD]Supplier (Debtor)[/TD]
[TD]Description[/TD]
[TD]Invoice Date[/TD]
[TD]Exchange rate[/TD]
[TD]USD [/TD]
[TD]EUR Amount[/TD]
[TD]Change in Inventory[/TD]
[TD]Classification[/TD]
[TD]Reference[/TD]
[/TR]
[TR]
[TD]Mechanic [/TD]
[TD]89854782[/TD]
[TD]ARDS[/TD]
[TD]NIO2541[/TD]
[TD]1-4-2018[/TD]
[TD] $ 1,2321 [/TD]
[TD] $ 17.400,00 [/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic [/TD]
[TD]5454125[/TD]
[TD]AAC[/TD]
[TD]NIO2542[/TD]
[TD]1-4-2018[/TD]
[TD] $ 1,2321 [/TD]
[TD] $ 500,00 [/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]450[/TD]
[TD]5465213[/TD]
[TD]ARDS[/TD]
[TD]NIO2543[/TD]
[TD]5-3-2018[/TD]
[TD] $ 1,2307 [/TD]
[TD] $ 85.000,00 [/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]900002[/TD]
[TD]4412154[/TD]
[TD]AAR[/TD]
[TD]NIO2544[/TD]
[TD]27-3-2018[/TD]
[TD] $ 1,2376 [/TD]
[TD] $542.563,00 [/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic[/TD]
[TD]585433[/TD]
[TD]DNJK[/TD]
[TD]office supplies[/TD]
[TD]30-4-2018[/TD]
[TD]1,00[/TD]
[TD] - [/TD]
[TD]212,32 [/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic[/TD]
[TD]58952[/TD]
[TD]JHN[/TD]
[TD]service charge on site[/TD]
[TD]27-4-2018[/TD]
[TD]1,00[/TD]
[TD] - [/TD]
[TD]1.350,00 [/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]695[/TD]
[TD]451259[/TD]
[TD]KIJ[/TD]
[TD]consultancy service [/TD]
[TD]30-4-2018[/TD]
[TD]1,00[/TD]
[TD] - [/TD]
[TD]258,00 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="6"><col><col></colgroup>[/TABLE]
Recently I have received a payment workbook containing 2 Sheets (USD & EUR)
and I would like to Transfer to a new workbook named purchase summary:
Here is a selection of USD payment:
[TABLE="width: 2338"]
<tbody>[TR]
[TD][TABLE="width: 2338"]
<tbody>[TR]
[TD]Course type[/TD]
[TD]Month[/TD]
[TD]Description[/TD]
[TD]Invoice No.[/TD]
[TD]Lecturer[/TD]
[TD]Book[/TD]
[TD]Description[/TD]
[TD]Gross amount[/TD]
[TD]TAX[/TD]
[TD]TAX
amount[/TD]
[TD]Net Amount[/TD]
[TD]Invoice
Date[/TD]
[TD]Due Date[/TD]
[TD]exchange[/TD]
[TD]Noted[/TD]
[TD]Recorded[/TD]
[TD]review date[/TD]
[TD]accepted[/TD]
[TD]Classification[/TD]
[TD="colspan: 2"]Type [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic [/TD]
[TD="align: right"]43191,00[/TD]
[TD]Purchase [/TD]
[TD="align: right"]89854782,00[/TD]
[TD]ARDS[/TD]
[TD]C-0122[/TD]
[TD]NIO2541[/TD]
[TD] $ 17.400,00 [/TD]
[TD="align: right"]0%[/TD]
[TD]$ - [/TD]
[TD] $ 17.400,00 [/TD]
[TD="align: right"]1-4-2018[/TD]
[TD="align: right"]1-5-2018[/TD]
[TD] $ 1,23 [/TD]
[TD][/TD]
[TD]ü[/TD]
[TD="align: right"]11-4-2018[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic [/TD]
[TD="align: right"]43191,00[/TD]
[TD]Purchase [/TD]
[TD="align: right"]5454125,00[/TD]
[TD]AAC[/TD]
[TD]C-0122[/TD]
[TD]NIO2542[/TD]
[TD] $ 500,00 [/TD]
[TD="align: right"]0%[/TD]
[TD]$ - [/TD]
[TD] $ 500,00 [/TD]
[TD="align: right"]1-4-2018[/TD]
[TD="align: right"]1-5-2018[/TD]
[TD] $ 1,23 [/TD]
[TD][/TD]
[TD]ü[/TD]
[TD="align: right"]11-4-2018[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]450,00[/TD]
[TD="align: right"]43221,00[/TD]
[TD]Purchase [/TD]
[TD="align: right"]5465213,00[/TD]
[TD]ARDS[/TD]
[TD]C-0251[/TD]
[TD]NIO2543[/TD]
[TD] $ 85.000,00 [/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0,00[/TD]
[TD] $ 85.000,00 [/TD]
[TD="align: right"]5-3-2018[/TD]
[TD="align: right"]5-4-2018[/TD]
[TD] $ 1,23 [/TD]
[TD][/TD]
[TD]ü[/TD]
[TD="align: right"]8-3-2018[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]900002,00[/TD]
[TD="align: right"]43221,00[/TD]
[TD]Purchase [/TD]
[TD="align: right"]4412154,00[/TD]
[TD]AAR[/TD]
[TD]C-0251[/TD]
[TD]NIO2544[/TD]
[TD] $ 542.563,00 [/TD]
[TD="align: right"]0%[/TD]
[TD]$ - [/TD]
[TD] $542.563,00 [/TD]
[TD="align: right"]27-3-2018[/TD]
[TD="align: right"]27-3-2018[/TD]
[TD] $ 1,24 [/TD]
[TD][/TD]
[TD]ü[/TD]
[TD="align: right"]28-3-2018[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="6"><col><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]
Here is a selection of the EURO payment:
[TABLE="width: 2338"]
<tbody>[TR]
[TD]Course type[/TD]
[TD]Month[/TD]
[TD]Description[/TD]
[TD]Invoice No.[/TD]
[TD]Lecturer[/TD]
[TD]Description[/TD]
[TD]gross amount[/TD]
[TD]TAX[/TD]
[TD]TAX
amount[/TD]
[TD]net amount[/TD]
[TD]Invoice Date[/TD]
[TD]Due Date[/TD]
[TD]exchange[/TD]
[TD]Noted[/TD]
[TD]Recorded[/TD]
[TD]review date[/TD]
[TD]accepted[/TD]
[TD]reference[/TD]
[TD="colspan: 2"]Classification[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic[/TD]
[TD="align: right"]43221,00[/TD]
[TD]Purchase[/TD]
[TD="align: right"]585433,00[/TD]
[TD]DNJK[/TD]
[TD]office supplies[/TD]
[TD="align: right"]261,15[/TD]
[TD="align: right"]23%[/TD]
[TD="align: right"]48,83[/TD]
[TD="align: right"] 212,32[/TD]
[TD="align: right"]30-4-2018[/TD]
[TD="align: right"]14-5-2018[/TD]
[TD="align: right"]1,00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11-4-2018[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic[/TD]
[TD="align: right"]43221,00[/TD]
[TD]Purchase[/TD]
[TD="align: right"]58952,00[/TD]
[TD]JHN[/TD]
[TD]service charge on site[/TD]
[TD="align: right"]1660,50[/TD]
[TD="align: right"]23%[/TD]
[TD="align: right"]310,50[/TD]
[TD="align: right"] 1.350,00[/TD]
[TD="align: right"]27-4-2018[/TD]
[TD="align: right"]27-5-2018[/TD]
[TD="align: right"]1,00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12-4-2018[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]695,00[/TD]
[TD="align: right"]43221,00[/TD]
[TD]Purchase[/TD]
[TD="align: right"]451259,00[/TD]
[TD]KIJ[/TD]
[TD]consultancy service [/TD]
[TD="align: right"]317,34[/TD]
[TD="align: right"]23%[/TD]
[TD="align: right"]59,34[/TD]
[TD="align: right"] 258,00[/TD]
[TD="align: right"]30-4-2018[/TD]
[TD="align: right"]14-5-2018[/TD]
[TD="align: right"]1,00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]13-4-2018[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="6"><col><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
End result:
so basically, I would like to Transfer match the invoice type and the respective period of the invoice date. (e.g. all the mechanic rows and the respective invoice Dates period that falls within April 2018) would Transfer to the summary sheet.
However, by only transfering specific columns which is align with the summary sheet. (USD sheet: A - summary A; USD sheet D - summary B; USD E - summary C; USD G - summary D; USD L - summary E; USD N - summary F; USD K - summary G; USD S - summary J;EUR A - summary A; EUR D - summary B; EUR E - summary C; EUR F - summary D; EUR K - summary E; EUR M - summary F; EUR J - summary H; EUR S - summary J)
Not quite sure if it is possible to use formulas if Aggregate small columns combined and just drag it down or VBA would do the tricks.
Please lend me a helping Hand
would be very much appreciated! Thank you in advance.
[TABLE="width: 1077"]
<tbody>[TR]
[TD]Invoice type[/TD]
[TD]Invoice no.[/TD]
[TD]Supplier (Debtor)[/TD]
[TD]Description[/TD]
[TD]Invoice Date[/TD]
[TD]Exchange rate[/TD]
[TD]USD [/TD]
[TD]EUR Amount[/TD]
[TD]Change in Inventory[/TD]
[TD]Classification[/TD]
[TD]Reference[/TD]
[/TR]
[TR]
[TD]Mechanic [/TD]
[TD]89854782[/TD]
[TD]ARDS[/TD]
[TD]NIO2541[/TD]
[TD]1-4-2018[/TD]
[TD] $ 1,2321 [/TD]
[TD] $ 17.400,00 [/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic [/TD]
[TD]5454125[/TD]
[TD]AAC[/TD]
[TD]NIO2542[/TD]
[TD]1-4-2018[/TD]
[TD] $ 1,2321 [/TD]
[TD] $ 500,00 [/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]450[/TD]
[TD]5465213[/TD]
[TD]ARDS[/TD]
[TD]NIO2543[/TD]
[TD]5-3-2018[/TD]
[TD] $ 1,2307 [/TD]
[TD] $ 85.000,00 [/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]900002[/TD]
[TD]4412154[/TD]
[TD]AAR[/TD]
[TD]NIO2544[/TD]
[TD]27-3-2018[/TD]
[TD] $ 1,2376 [/TD]
[TD] $542.563,00 [/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic[/TD]
[TD]585433[/TD]
[TD]DNJK[/TD]
[TD]office supplies[/TD]
[TD]30-4-2018[/TD]
[TD]1,00[/TD]
[TD] - [/TD]
[TD]212,32 [/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mechanic[/TD]
[TD]58952[/TD]
[TD]JHN[/TD]
[TD]service charge on site[/TD]
[TD]27-4-2018[/TD]
[TD]1,00[/TD]
[TD] - [/TD]
[TD]1.350,00 [/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]695[/TD]
[TD]451259[/TD]
[TD]KIJ[/TD]
[TD]consultancy service [/TD]
[TD]30-4-2018[/TD]
[TD]1,00[/TD]
[TD] - [/TD]
[TD]258,00 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="6"><col><col></colgroup>[/TABLE]
