Open Forum

PC_Flag is N in Project controller in Microsft Dynamics SL

  • 1.  PC_Flag is N in Project controller in Microsft Dynamics SL

    SILVER CONTRIBUTOR
    Posted Jan 11, 2021 06:33 PM
    This GL transaction is not making it over to Projects even though we checked task, accounts, setup, transfer errors (none)

    The GL_tran table PC_status is 1 but the PC_Flag is N.

    How can I get this record to move over?

    ------------------------------
    Mackenzie Platten
    Crestwood Associates L.L.C.
    Schaumburg IL
    ------------------------------


  • 2.  RE: PC_Flag is N in Project controller in Microsft Dynamics SL

    GOLD CONTRIBUTOR
    Posted Jan 11, 2021 06:55 PM
    Does your period to post in GL align with what you have on the FTT screen?

    ------------------------------
    Marc DeLozier
    Finance SysAdmin
    David Evans and Associates Inc.
    Portland OR
    ------------------------------



  • 3.  RE: PC_Flag is N in Project controller in Microsft Dynamics SL

    SILVER CONTRIBUTOR
    Posted Jan 11, 2021 07:44 PM
    Thanks for your reply!!
    FTT
    this is the sample from the table
    gltran table sample


    ------------------------------
    Mackenzie Platten
    Crestwood Associates L.L.C.
    Schaumburg IL
    ------------------------------



  • 4.  RE: PC_Flag is N in Project controller in Microsft Dynamics SL

    GOLD CONTRIBUTOR
    Posted Jan 11, 2021 11:48 PM
    So, I think your issue is that the period to post is 2019-12 and FTT is 2020-02; if I remember correctly, you can post prior months (if the 'Allow Posting to prior period' is checked) but once you get into a new fiscal year, I think you have to roll the project year back to properly transfer this; then you would need to recalc the project for proper summary table numbers.   As it's non-billable anyway (the PC_Flag = 'n') perhaps someone else has a workaround for this.

    Marc

    ------------------------------
    Marc DeLozier
    Finance SysAdmin
    David Evans and Associates Inc.
    Portland OR
    ------------------------------