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

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Project Invoice Propos...
Finance | Project Operations, Human Resources, ...
Unanswered

Project Invoice Proposals Posting error

(1) ShareShare
ReportReport
Posted on by Ramon L 159

Hi Guys

I'm having an issue with Posting a Project invoice proposal. I get the following error :

pastedimage1620674757524v2.png

pastedimage1620674773338v3.png

Discrepancy between account 5637146150 and setup of the group for invoicing Balance.

I have checked the WIP accounts but everything seems to be fine, I can not seem to find why this will not post. I have checked the ledge posting setup and find nothing amiss at all. I have reviewed the revenue account setup for WIP but can not find anything that works with the setups at all.

Does anyone know how to correct this? I have no issues in my other companies when I post, however, this is a new company we created. i think there is a setting missing or an config we missed

I have the same question (0)
  • Ramon L Profile Picture
    Ramon L 159 on at

    hi there

    I think I may have found the solution to this problem. I have checked the system end to end, If you happen to get this error check the following:

    Step 1 : Project management and Accounting > Setup> Posting> Project groups

    Check the project group types listed. Look at the Ledger tab and ensure that for all project types the Post-Costs all reflect the correct  GL type. This error usually occurs when the On-Account Invoicing GL type is set incorrectly.

    You need to make sure that all Ledger types are set to Profit and Loss. If not you will need to create a new Project Group and amend it as you will not be able to change it once it's been created and Saved.

    Step 2: Find the projects that use the affected project group and switch them to the new Project Group by using the simple process:

    Step 3 : go to Project management and Accounting > All Projects> ##select the project having the issue##> open the project, > select the maintain Project Group tab and change from the current project costing to the new one

    Once completed and all projects have been moved to the new Project group you can delete the faulty one without having to change any unposted project invoice proposal projects

  • MarkB45 Profile Picture
    MarkB45 755 on at

    Hi Ramon,

    Have you checked the Project cost and revenue profiles where you set the main account type for each project transaction type (below)? If you have set up the ledger posting to go to a P&L account but the Profile setting says "Balance" you will get a posting error and Vice Versa.

    pastedimage1621499805986v1.png

    KR

    Mark

  • Ramon L Profile Picture
    Ramon L 159 on at

    Hi Mark

    Yip, I spotted it finally after looking at it over and over again for more than a day, eventually, I spotted the on-account invoicing was set to balance sheet while everything else is set to P&L. one could look at it for days and keep missing it ... The error code is what caused the biggest headache!!! it just did not help much at all. But thanks for reaching out... I found the error and posted the fix, but you are spot on, the only way to fix it after the fact is to create a new costing type, transfer all projects over to the new posting profile and delete the incorrect one .. You cant change the on-account invoicing, which is sad, cause that would have made my life so much easier ...

    Thanks again!!!

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

Introducing our New Video Series: Community Spotlight

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 721 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 280 Super User 2026 Season 1

#3
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 255

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans