How to download ALL attachments of a type to ALL expense reports for a period in iexpenses
Example:
Period: 1 April 2017 to 31 March 2018 (inclusive) [Period: Period of review is based on the Expense Report Submitted Date (EXPPENSE_SUBMITTED_DATE)]
We basically would like only the documents relating to below (Based on "EXPENSE_LINE_TYPE_DESCRIPTION")
I will use 1 example to demonstrate. For Report EXP-482925 ("EXPENSE_REPORT_NUMBER"), I would like to obtain PDF receipts that support Meal - Employee Travelling ( "EXPENSE_LINE_TYPE_DESCRIPTION") which is 52 ("LINE_AMOUNT").
To do this in a mass scale, would it be easier if I provided you with:
a) the expense report numbers and you extract all PDF data ? EXP-482925 ("EXPENSE_REPORT_NUMBER"),