PTE Expense Header and Lines having differences

(0) Share

Report

Posted on by Irfan.Rasheed

717

Hi,

We recently upgraded to GP2016R2 (16.00.675) from GP2010R2 (11.0.2390).

We were using PDK earlier for project expense claims in GP2010R2, where in GP2016R2, it has been replaced with PTE Expense Reports.

We encounter an error while claiming expense in PTE, that once an employee submit expense for approval in PTE (using desktop or client). Total Expense amount not matched with totals of expense lines amount. I have share results from GP and from back end via SQL query, that expense lines and distribution totals are not matched.

02.-SQL-Results.png

01.-GP-Window.png

Is this any bug, or should i ran system utilities, as i have not found any specific utilities for PTE Expenses.

Best Regards.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

kdd281 469 on at

Like (0)

Report

RE: PTE Expense Header and Lines having differences

We have had these issues since PTE has been released. Basically, the issue is related to Session timeouts and the headers not being updated since the header updates on the save of the expense report and not upon entry of each line for either the desktop or web interface.

Also we see even more issues on Expense Reports using another currency. Fixing these are manual updates on the SQL table for each line item and header.

We monitor for Expense Reports for headers not matching the sum of the lines and adjust manually (We just created a SP to do this, but you need to confirm to make sure nothing else is an issue)

If you didn't catch the issues in PTE then you need to correct on the PA and PTE side.

Tables:

• PTE10500

• PTE10501

• PTE30500

• PTE30501

• PA10500

• PA10501

• PA10504

I have spoke to Microsoft several times on this issue, I have not heard of any improvements coming soon. Please create a ticket with them to document the issue so they take action on it.