Description

...

The SQL statement is rather specific. While using it you need to replace the fields according to your setup for the Travel Expense transfer to Payroll under APM > Organization Properties. See the field description below.

...

The view mainly selects records from APP > Transportation and APM > Payroll history that match each other based on the following columns: PIN, Document ID, Payroll Period, Amount, and Vessel.

It is possible that you would have persons with several same records that have all of those values matching, then the script would have duplicates. There is no way to avoid it since we don’t have a unique ID for separate Transportation records. But is ok. Usually, those records have the same description (e.g. buss fees are the same). Just look through the select results to make sure it is ok.

SQL statement

To check and verify the data

...