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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Project Accounting ign...
Microsoft Dynamics GP (Archived)

Project Accounting ignoring Sub Account Format Settings

(0) ShareShare
ReportReport
Posted on by Bill Campbell 12

We have a situation with a client where the Time and Materials Billing cycle is working correctly and sending the GL transactions to the correct GL accounts and is following the Sub Account Format selected in the Project Maintenance screen.

The situation is with the Fixed Price projects.

Here the Revenue Recognition and the Billing Entry are both 'acting correctly' not generating any errors but they are ignoring the Sub Account Format for each of the Projects and sending the GL transaction off to the account parent - without the sub account mask being applied.

Example

Project 1 - should be sending the Billing to 2-10-01-4000

instead it is sending the billing to 2-00-00-4000

the sub account mask for the project is 2-10-01-XXXX

Question

What are we missing?  We do have the accounts in the Posting Account window configured by default to 2-00-00-4000 (Revenue) could this be the source of the problem?

It is not just one project - it was for all projects - all cost categories - of ALL Fixed Price work.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Bill,

    Have you ticked the Override Segment on Fixed Price/Cost Plus Accounts in the account segment overrides windows.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Here is a clip of the Account Segment Override window for a Fixed Price project - what do we need to change?

    Thanks for assistance.

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Bill,

    the screen shot is not clear, have you filled the segment 1 with 2 if so you can remove the same since you are overriding only 2nd and 3rd and try again.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Sorry but we have some projects that still point to 1 in the first segment and then others that point to 2 in the first segment.

    So I think we still need these.

    I notice in this window that not many of the selection buttons are pushed for the xxxx-fee only options?

    Is that where you are suggesting we need to make a change?

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Bill,

    Sorry since the screen shot is not clear I was not able to read the same properly or may be  becoming old :-).

    On this window the Default Format everything should have ???? and not any number which is why the overriding not work.  Please change the same to ?? and try again.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Babu, when you select the Segment 1/2/3 in the other screen of this window, it populates the answer into the Default format - so the ??? all get replaced with what you select in this space.

    As to the screen shot - what can we expect for 48KB file - not much in the way of size options.

    Thanks for the assistance.

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Bill,

    you are correct.  I think you have total 4 segments if I am correct.  so you wanted to over ride only 3 segments and 1 segment remain same.  If that is the case please include only 3 segments on this windows and fill values where required.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    That is what we have done.  We grew from 3 segments to 4 segments and that is why we had to push the segments down as we have.

    I am wondering if any one has a clear explanation of the use of the selection buttons running down the side under Fixed Price / Cost Plus Accounts.

    The selection under the FP is different than that for a T&M project.

    Anyone any thoughts

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Bill,

    Sorry for not clarifying properly, can you please confirm where did you given the default account for revenue as per your original post 2-00-00-4000 (Revenue)

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at

    That is set in the Administration >> Posting >> Posting Account - select Project and enter the default accounts for all different options.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans