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 / Small and medium business | Business Central, N... / Project Module
Small and medium business | Business Central, N...
Suggested Answer

Project Module

(4) ShareShare
ReportReport
Posted on by OS-20120016-0 14
Good day to everyone

Please I need help regarding the Project Module.
 
In Business Central, I posted usage, I ran WIP, then I posted sales invoice and I ran WIP. But when I checked the chart of account I saw the following result:
2231    WIP Job Costs: -436.96 (Bal. Sheet)
6620        Job Sales: -1,000.00 (P&L)
7620    Job Costs: 436.96(P&L)
2320    Customers: 1,000.00 (Bal. Sheet)
I expected 2231    WIP Job Costs -436.96 (Bal. Sheet) to have zero balance but it is still showing -436.96 balance
Below is the Project Posting group I used: 

COST SIDE
Field G/L
WIP Costs Account 2231
WIP Accrued Costs Account 2231
Project Costs Applied Account 2231
Item Costs Applied Account 2231
Resource Costs Applied Account 2231
G/L Costs Applied Account 2231
Project Costs Adjustment Account 2231
G/L Expense Acc. (Contract) 2231
Recognized Costs Account 7620
SALES SIDE
Field G/L
WIP Accrued Sales Account 6620
WIP Invoiced Sales Account 6620
Project Sales Applied Account 6620
Project Sales Adjustment Account 6620
Recognized Sales Account 6620
 
Please help me out, I have done all I could do, but I did not get right.
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,774 Super User 2025 Season 2 on at
    The costs most likely come from the Resource costs. Check the Resource ledger entries that have been registered to the project.
    Or if some items are used for the project.
    As You can see - You have many costs indicated to be posted to 2231, so could be any of them.

    And why would You like to have it 0? 
    In this case You can calculate profit for the project = 563,04. If there are no costs, then all 1000 would be considered a profit.
  • OS-20120016-0 Profile Picture
    OS-20120016-0 14 on at
    Thanks for your response, I really appreciate it.

    On the Project planning lines, I entered three items, one resource and one G/L, then I created Project Journal lines and I posted the usage, which gave me the following entries- item ledger entry (3); Project  ledger entry (5); Res. ledger entry (1); Value entry (3). After that I ran WIP and posted WIP to G/L. Then I created and posted Sales Invoice and I changed status to COMPLETE and I ran WIP to complete the process.
    After all these, I expected to see:
    2231    WIP Job Costs: 0 (Bal. Sheet). expecting the cost to move entirely to Job cost(7620) account after running WIP, but WIP still has the cost sitting there
    6620        Job Sales: -1,000.00 (P&L)
    7620    Job Costs: 436.96(P&L)
    2320    Customers: 1,000.00 (Bal. Sheet)
    BC_PRO.png
    BC_PROJ_3.png
    BC PROj_2.png
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 6,268 on at
    Hello,
     
    This is expected with your setup. The issue is that you mapped all WIP, applied, and adjustment cost fields to the same G/L account (2231). When BC runs WIP and then invoices, it needs different accounts to move costs from WIP (Balance Sheet) to Recognized Costs (P&L). Since everything points to 2231, the balance can’t clear and stays there. Fix is to use separate WIP vs applied/adjustment accounts; then rerun WIP and the WIP balance will go to zero after invoicing.
     
    Regards, 
    Oussama Sabbouh 
  • OS-20120016-0 Profile Picture
    OS-20120016-0 14 on at

    Thanks for your contribution sir.
    I used separate WIP vs applied/adjustment accounts as you advised; then I rerun WIP and the WIP balance  goes to zero after invoicing. But the profit is not correct. Below is the final result on the Char of account:
    2231    WIP Job Costs: 0 (Bal. Sheet).
    6620        Job Sales: -2,000.00 (P&L)
    6190        Job Sales Applied 1,000.00 (P&L) 
    7620    Job Costs: 436.96(P&L)
    7180    Job Costs Applied: - 436.96(P&L)
    2320    Customers: 1,000.00 (Bal. Sheet)
     
    So the profit is 1000 instead of 563.04 as the cost is netted out.

    Below is the new posting group used
     
     
     
    Code Description WIP Costs Account WIP Accrued Costs Account Project Costs Applied Account Item Costs Applied Account Resource Costs Applied Account G/L Costs Applied Account Project Costs Adjustment Account G/L Expense Acc. (Contract) WIP Accrued Sales Account WIP Invoiced Sales Account Project Sales Applied Account Project Sales Adjustment Account Recognized Costs Account Recognized Sales Account
    SETTING Setting up  2231 2232 7180 7180 7180 7180 7181 6610 2211 2212 6190 6191 7620 6620
  • OS-20120016-0 Profile Picture
    OS-20120016-0 14 on at
    Sorry, the Job Sales is :   6620  Job Sales: -2,000.00 (P&L), and not -1000 as it is mistakenly stated above
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,714 Super User 2025 Season 2 on at

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans