Having trouble acquiring all cost data using MIMSVu/CORVu.
Projects Data resides in Database 3660 and Work Order Data resides in 3620. Actual Costs appears in tables 665, 666, and 668 under 3660, and table 620 in 3620. However, these two databases cannot be joined by the end user and the detail cost in the 3620/620 Work Order table is needed also. I do not see Work Order being accessible in the 3660 tables.
Has anyone else had this type of problem? Why is Work Order data, that are children of a project, not part of the 3660 data nor accessible for an all inclusive query access capability?
Thanks
Projects Data resides in Database 3660 and Work Order Data resides in 3620. Actual Costs appears in tables 665, 666, and 668 under 3660, and table 620 in 3620. However, these two databases cannot be joined by the end user and the detail cost in the 3620/620 Work Order table is needed also. I do not see Work Order being accessible in the 3660 tables.
Has anyone else had this type of problem? Why is Work Order data, that are children of a project, not part of the 3660 data nor accessible for an all inclusive query access capability?
Thanks