Car Mileage over 5000KM

[Karthikhemadri]

Team,

Can you confirm  if we have any reporting shows the mileage distance 5000Km and over 5000 KM for Taxation purpose. This is required for one of our Australian customer.

where i can find the highlighted field in Cognos to build report

[KevinD]

@Karthikhemadri I don't believe that specific data item exists in the data warehouse. 

You would need to build a report with these data items:

Employee Name

Report Name

Expense Type (filter this to only show Personal Car Mileage or whatever your mileage expense type is called)

Transaction Date (create a filter to only show mileage expenses for the specified time period)

Business Distance

You could then group the report by Employee and Report Name. This would accumulate a total for the KMs for you. That is if you use Query Studio to build the report.

[Karthikhemadri]

Hi @KevinD 

I tried this report, which give me accumulated miles for an employee without adding the Initial distance loaded in user profile.

is there a data object to get initial distance from user profile?

[KevinD]

@Karthikhemadri I do not believe the initial starting odometer reading entered by the employee is in the data warehouse. In my opinion, that really shouldn't have any bearing on reporting. The most important thing is the mileage/kilometers the employee is asking to be reimbursed for. The starting reading shouldn't really matter since the system is accumulating the employees' totals as they go.

[Karthikhemadri]

@KevinD  yes you are right if we are starting at the 1st day of financial year.

however, we are importing initial distance for a new client to concur. The initial distance is not the actual odometer however it the year to date distance of business travel. So we need these details to accumulate the mileage distance to check if it is over 5000 KM or not.

The filed I highlighted in the screen shot provided will gives you the information, however i need those details in a report to extract on periodically.

[KevinD]

@Karthikhemadri so to make sure I understand...you have a client who has somehow recorded their employees' starting odometer reading and you are going to import that initial reading into user profiles? Then you want to be able to use Cognos to see what the odometer initial reading that was imported in to all the user profiles? 

Did I get that right?

[Karthikhemadri]

@KevinD Yes. We have a client onboarding in mod of the financial year where we need to enter distance to date (claimed form other expense solution) as initial distance in Concur.

we need a Cognos report to validate that all the initial distance is updated as expected also the same report (modified) will be used to check if the mileage distance is over 5000 KM or not for the current FY.

[KevinD]

@Karthikhemadri I did a search in the Data Warehouse and there isn't any data item for Initial Distance. 

[Karthikhemadri]

@KevinD thank you we are on same page then.

do you have any idea if we have a standard report on downloading car mileage expenses over certain KM's.

[KevinD]

@Karthikhemadri I have not seen a standard report of this type. It isn't a difficult report to build. From the accumulated mileage report you built, just do a filter to only show greater than 5000KM. That will show only those that have gone over 5000km for this year or whatever year you are looking at.