Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Project Module - WIP and COS Computation by department

(0) ShareShare
ReportReport
Posted on by 5

Hello Dynamics BC Community,

Module - JOB Costing

Method used - Cost of sales

Sales recognition method- COS

I have a customer which has defined a project and they have 2-3 different departments (Dimension) on the same project.  When computing the sales invoice, the revenue is allocated by department. This is working fine.

They have use the cost on 2 depart (Usage) has been on 2 tasks line (1 tasks line is one dept).  So the Usage consumption costs is allocated on the 2 lines on the 2 department.  When computing the WIP the cost is per WIP per Department.  This is ok.

Now if the revenue recognition for only  for 1 department - (1 tasks line is one department).  The revenue is transfered to the gL turnonver account correctly.   However, my client was to recognised the COS only for that department in the GL and not transfer the WIP for the other department if there are no revenue recognised against this line.

Example

Task 

1010 = Depart A1   -  Budget cost = 10,000  Usage ocst = 5000 and Budget Price = 20,000 , invoiced Amount = 12,000 

2020 = Department B1 Budget cost = 6000  Usage cost = 3000 and budget price = 12,000 and invoiced amut = 0

Total WIP = 5000 + 3000 = Rs 8000

Once you recognised revenue the 12,000 for Dept A1 they want only the cost portion for Depat A1 to be transferred to the COS account.

In Dynamics i know it is by overall project amount % invoiced. 

Right now the posting to  cost of sales also has the cost incurred on the  Dept B1.

Any solution to have the COST of sales posted for only Dept A1 to the GL as only the revenue for this dept is recognised.

Thank you.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Project Module - WIP and COS Computation by department

    Hello,

    This is a typical setup question for partners. However, if you do not get further traction from the community, feel free to raise this issue to Microsoft via your partner or CSP.

    Thanks.

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

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans