Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

GP2018R3 Year-End Update error create view EmployeeTimecardPending

(0) ShareShare
ReportReport
Posted on by 2

Installing YE update for GP 18R3 and getting an error on one company during utilities.  

The following SQL statement produced an error: Create View [dbo].[EmployeeTimeCardPending].......

Followed by Invalid column name "Workflow_Action_Date".  

This is on a company that used to run payroll but hasn't for years.  

Has anyone seen this error and have a workaround?

Thanks,

Cindy

Categories:
  • Suggested answer
    Derek Albaugh Profile Picture
    on at
    RE: GP2018R3 Year-End Update error create view EmployeeTimecardPending

    Good to hear, have a great day.

  • Cindy Joseph-Sandau Profile Picture
    2 on at
    RE: GP2018R3 Year-End Update error create view EmployeeTimecardPending

    Exactly what I needed!  All companies are updated.  

    Thanks for your help!

  • Verified answer
    Derek Albaugh Profile Picture
    on at
    RE: GP2018R3 Year-End Update error create view EmployeeTimecardPending

    First, if any UPR10500 tables have data in them, you'll want to make a backup such as using this script:

        Select * into UPR10500BAK from UPR10500

    The script for the UPR10500 table with the Workflow_Action_Date column you can then use is here:

    /*Begin_UPR10500*/

    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UPR10500]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

    drop table [dbo].[UPR10500]

    GO

    CREATE TABLE [dbo].[UPR10500] (

    [EMPLOYID] [char] (15) NOT NULL ,

    [Pay_Schedule] [char] (15) NOT NULL ,

    [YEAR1] [smallint] NOT NULL ,

    [PERIODID] [smallint] NOT NULL ,

    [Workflow_Status] [smallint] NOT NULL ,

    [SupervisorADLogin] [char](85) NOT NULL,

    [Workflow_Action_Date] [datetime] NOT NULL,

    [DEX_ROW_ID] [int] IDENTITY (1, 1) NOT NULL ,

    CONSTRAINT [PKUPR10500] PRIMARY KEY  NONCLUSTERED

    (

    [EMPLOYID],

    [Pay_Schedule],

    [YEAR1],

    [PERIODID]

    )  ON [PRIMARY],

    CHECK (datepart(hour,[Workflow_Action_Date])=(0) AND datepart(minute,[Workflow_Action_Date])=(0) AND datepart(second,[Workflow_Action_Date])=(0) AND datepart(millisecond,[Workflow_Action_Date])=(0))

    ) ON [PRIMARY]

    GO

    setuser

    GO

    EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[UPR10500].[EMPLOYID]'

    GO

    EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[UPR10500].[PERIODID]'

    GO

    EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[UPR10500].[Pay_Schedule]'

    GO

    EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[UPR10500].[Workflow_Status]'

    GO

    EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[UPR10500].[YEAR1]'

    GO

    EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[UPR10500].[SupervisorADLogin]'

    GO

    EXEC sp_bindefault N'[dbo].[GPS_DATE]', N'[UPR10500].[Workflow_Action_Date]'

    GO

    setuser

    GO

    GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[UPR10500]  TO [DYNGRP]

    GO

    /*End_UPR10500*/

    After that, you'll need to move any data from the UPR10500BAK table to the UPR10500 table again, then continue with the upgrade.

    If you need further assistance with the upgrade, we'd need to open a support case so an engineer can work with you.

    Thanks,

  • Cindy Joseph-Sandau Profile Picture
    2 on at
    RE: GP2018R3 Year-End Update error create view EmployeeTimecardPending

    I'm sure that is the problem but not sure how to resolve.  There are 3 companies being upgraded.  I got an error on UPR10500 on the first company but got past it and it seems to be OK.  Of the two that are failing, one hasn't run payroll for years, the 2nd is a copy of the one that succeeded and is just a test company.

    UPR42101 has Workflow_Action_Date on all 3 companies.  None of them have that column in UPR10500.  How can I resolve?

    Thanks!

  • Suggested answer
    Derek Albaugh Profile Picture
    on at
    RE: GP2018R3 Year-End Update error create view EmployeeTimecardPending

    Look at the UPR42101 and UPR10500 tables, they both should have this Workflow_Action_Date column in them.

    These new columns get added into 18.3 and are what we most commonly see with this view failing due to this missing column.

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Product updates

Dynamics 365 release plans