Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Moving Project costs

(0) ShareShare
ReportReport
Posted on by 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
    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
    626 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
    6,451 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

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