Description
This programm creates a list of all receipts resulting frominternational trips, for which the company can possibly claim a refundof paid sales tax. The receipts can be selected according to timeinterval, country, currency and expense type.
In the first list, all receipts from transferred international tripsthat include a selected country as main destination or stopover. Sincethe exact assignment of receipts to a country is not possible, the usermust go through the entire list and remove all receipts that did notoriginate in the relevant country (exception: in Austrian companies,company code country 'AT', not only international trips, but all tripsare selected because there all trips lasting less than 5 hours areconsidered domestic trips). The user can either select all receipts inthe displayed list and create a second list with the selected receiptsvia the button 'selected receipts' or the entire list can be placed inan Excel table and then be further processed. Authorization checks arenot performed in the report because the report is used as a rule onlyto evaluate mass data and not for individual selection.

Output
Output is limited by the entries made in the selection options. Threegroups can be distinguished, which are presented on the selectionscreen in boxes.
The first box is created from the logical database PNP and allowsselection via personnel numbers.
The second refers to a limitation of the time period in which the tripstook place. In addition, selections can be made according to country(main destination / stopover, see above), receipt currency, tripexpense type and VAT indicator. The 'File' parameter is a specialfeature. It specifies the name of the PC file or the Word or Exceldocument.
The last box specifications can be made via a minimum receipt amount.The currency field specifies the currency for the receipt to be enteredbelow it. The user usually enters the house currency of his company. Inthe program, each receipt amount is converted to this currency andcompared to see if it is larger than or equal to the parameter amountentered. (See examples below.)

Example
Selection screen: limitation according to personnel number
All of the employee's receipts that were entered for internationaltrips are displayed.
Selection screen: limitation according to personnel number, country,currency and trip expense type
All of the employee's receipts for international trips which had theselected country as main destination or stopover, which were paid inthe specified currency and which have the expense code that is to beselected are displayed.
Additional selection via minimum amount in specified currency
The converted receipt amounts must be larger than or equal to theminimum amount. (Receipt amount 95 FRF, minimum amount 30 DEM, exchangerate 1 DM = 3 FRF => 30 * 3 = 90, receipt is selected. Receipt amount85 FRF => amount too small, receipt is not selected.)