Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Project Module - WIP and COS Computation by department

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans