5
Due to changes made on the Employee Expense tables in recent years with PTE, the document number field is now 31 characters instead of 17 in dexterity, which is fine in the application, but with this change users can no longer join the PA30501 table to the PA Billing ITEM TEMP table in Project Accounting. In previous versions users could pull the description of their employee expense history lines onto their billing invoices for visibility.

Now if you attempt to do this, you cannot join the PA Cost Document No. on the PA Billing ITEM TEMP to the PA Empl Expense Document No. field, even though they hold the exact same values in SQL.

I also tried to create this table relationship directly in DEX, and I could not. Something changed that will no longer let us join the PA Cost Document Number in the PA Billing ITEM TEMP table to the Employee Expense History table.

From what I can tell when PTE came out, the number of characters in the PA Employee Expense Detail History for the PA Empl Expense Document Number was updated to 31 characters (used to be 17 in previous versions) since it was updated there but not in the billing tables, Dex will no longer let us join.

STATUS DETAILS
Needs Votes