Open Forum

Expand all | Collapse all

Fixed Asset Error

  • 1.  Fixed Asset Error

    GOLD CONTRIBUTOR
    Posted 9 days ago
    ​​I am having an issue with Running depreciation for Jan 2019

    I am not picking up anything ---- there should a lot of transactions ---

    When I first looked at this -- the depreciation said we were in Fiscal Year 2022 -
    this suggests to me that the year end process was run multiple times

    I reset the Fiscal period field in Fa table FA40200

    This happened a while ago --- therefore a Company restore is not viable

    Are there particular table - or procedures I can run to resolve this

    my goal is to re-run     depreciation for all assets as of  01/31/2019

    any help is greatly appreciated

    ------------------------------
    Douglas Hart
    Dynamics Administrator
    Forex Capital Markets
    New York City NY
    (646) 432-2703
    ------------------------------


  • 2.  RE: Fixed Asset Error

    TOP CONTRIBUTOR
    Posted 9 days ago
    Hi @Douglas Hart

    I'm not sure it's all this simple, but the Current Year for each book is also held at the Book Setup Level.  So just changing it in that table won't cut it.

    I would do a SQL Search in the FA Tables to find where the current year is held and make sure they are all set to this year.

    I know you will find it in the FA40200 AND FA41000  The field you are looking for is YEAR1

    ------------------------------
    Jo deRuiter, MCP, DCP
    "That GP Red Head"
    AISLING DYNAMICS CONSULTING, LLC
    WEBSITE: https://aislingdynamics.com/
    BLOG: https://community.dynamics.com/gp/b/gplife
    770-906-4504 (Cell)

    ------------------------------



  • 3.  RE: Fixed Asset Error

    GOLD CONTRIBUTOR
    Posted 9 days ago
    ​Thanks Jo

    I will check other tables

    I only have 1 book ---

    will let you know

    thanks again

    ------------------------------
    Douglas Hart
    Dynamics Administrator
    Forex Capital Markets
    New York City NY
    (646) 432-2703
    ------------------------------