Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Moving Project costs
Finance | Project Operations, Human Resources, ...
Suggested answer

Moving Project costs

(0) ShareShare
ReportReport
Posted on by CPeterson 40

We have a project that was incorrectly classified under the wrong sub-account.  There are 9 months of associated expenses, no revenue.  We changed the sub-account in Project Set up and that seems to have moved the related expenses to the correct place in project.  However, there are still expenses in our general ledger showing up under the old/incorrect sub account.  How do I get my general ledger expenses to be the same as the project expenses?  If I do a journal entry, it seems like it will record the expenses to the project again since the expense accounts require you to enter the project.  And, the journal entry would be huge as there are 9 months of expenses to reclassify.  Any help on how to do this would be greatly appreciated!  

Also, if you are or have a reliable Dynamics SL contact or support person, I would be grateful for their contact information.  We are in need of someone that would be available for phone calls or e-mail support.

Thanks in advance!

  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Moving Project costs

    Dear Mark,

    Well I have two answers

    1. Use your NON post project in the Journal entry.

    This will not update project again.

    2. Enter the batch using the projectid to reverse out the Expense entries (do not release it)

    open up query analyzer and on the gltran records for the batch, update the pc_status to a 2

    a 2 indicates the batch has already gone over, and no need to transfer.

    update gltran set pc_status = '2' where batnbr = 'XXXXXX'

    then you can go and release the batch.

    Although I don't quite understand what you mean "We changed the sub-account in Project Set up and that seems to have moved the related expenses to the correct place in project." as I don't see that changing the project subaccounts will impact any already released expenses in the system. In other words, changing the project subaccount on its master record doesn't change the subaccount previously used by the project in the pjtran table.

    However, I can see allocator backing out the allocation from the sub to the new sub if you ran a recalculation.

    Jana MacDonald

    Microsoft SL Support

  • MARC_ Profile Picture
    MARC_ 620 on at
    RE: Moving Project costs

    I am an end user at a professional services (project heavy) company in the pacific NW -  we have used The ERP Group for 20+ years and they are great.  Very deep knowledge of SL. 

    https://www.theerpgroup.com/

    Mark E (responded already) is also very active in the community and knows a bunch about SL. 

    Thanks,

    Marc

  • Mark E Profile Picture
    Mark E 6,405 on at
    RE: Moving Project costs

    I sent you a friend request within the Community portal.  Feel free to contact me for assistance.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans