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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Amounts are posted to ...
Microsoft Dynamics GP (Archived)

Amounts are posted to the Unbilled Accounts Receivable and Unbilled Project Revenue accounts when you process a purchasing invoice transaction for a project in Microsoft Dynamics GP 11

(0) ShareShare
ReportReport
Posted on by Community Member

We use GP2010 SP2. We recently found Amounts are posted to the Unbilled Accounts Receivable and Unbilled Project Revenue accounts when we process a purchasing invoice transaction for a project in Microsoft Dynamics GP 2010. This problem occurs on all projects when When Performed is selected in the Accounting Method list in the Project Maintenance window.

Question: This issue should be fixed in GP9.0 SP1 according to Microsoft Dynamics support Article ID: 918541 , why now GP2010 SP1 still have same issue?

*This post is locked for comments

I have the same question (0)
  • DavidMO Profile Picture
    DavidMO 1,030 on at
    Re: Amounts are posted to the Unbilled Accounts Receivable and Unbilled Project Revenue accounts when you process a purchasing invoice transaction for a project in Microsoft Dynamics GP 11

    I checked with my Accounting people, and they say they must use “Markup %”. But they want amounts posting to unbilled not when Rec, but when Invoiced instead. Not sure how to make that happen.

    It is for Freight & Tax going through Project Accounting. Any suggestions?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: Amounts are posted to the Unbilled Accounts Receivable and Unbilled Project Revenue accounts when you process a purchasing invoice transaction for a project in Microsoft Dynamics GP 11

    The SQL SP control the behavior. I can not see your client system, but GP PA will 'look for' GL account setup from different levels. so it is normal if you have all Transaction Types set to Source from the Cost Category and no Account Numbers are set for any of them.

    I do not think any MS user manual mentioned it.

  • DavidMO Profile Picture
    DavidMO 1,030 on at
    Re: Amounts are posted to the Unbilled Accounts Receivable and Unbilled Project Revenue accounts when you process a purchasing invoice transaction for a project in Microsoft Dynamics GP 11

    Interesting. I just checked on one sample cost cat # and my users have it set to

                   "Profit Type TM"  =  “Markup %” also. The "Markup Percent - TM" is set to 0 %

    What controls the behavior change to use those two GL accounts or not when you change the Profit Type to “Billing Rate” vs “Markup %” ?

    Is it the setup in Tools -> Setup -> Project -> Project, Accounts button? We have all Transaction Types set to Source from the Cost Category and no Account Numbers are set for any of them.

    Is it documented anywhere that you have seen? I checked these 3 docs without a clear answer.

    - ProjAcctAccountingControl.pdf

    - ProjAcctBilling.pdf

    - ProjAcctCostManagement.pdf

    I appreciate the help! This could end up fixing a "big one" for my users.

  • Community Member Profile Picture
    Community Member on at
    Re: Amounts are posted to the Unbilled Accounts Receivable and Unbilled Project Revenue accounts when you process a purchasing invoice transaction for a project in Microsoft Dynamics GP 11

    Hi David,

    I found the reason why GP hit those two accounts, it because related cost catagory's setup wrong. To change‘ TM profit Type’ setting should be “Billing Rate”, if it was setup to “Markup %”, then GP will use those two GL accounts.

    Wei Chen, MCT

  • DavidMO Profile Picture
    DavidMO 1,030 on at
    Re: Amounts are posted to the Unbilled Accounts Receivable and Unbilled Project Revenue accounts when you process a purchasing invoice transaction for a project in Microsoft Dynamics GP 11

    I am curious about this subject also. My users recently brought up this subject and would like to make changes.

    Is this normal GP or is there a config option to change the behavior?

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans