web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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!

I have the same question (0)
  • Mark E Profile Picture
    6,451 on at

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

  • MARC_ Profile Picture
    626 on at

    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

  • Suggested answer
    CFROTON Profile Picture
    4,710 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 420 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans