Dynamics Community Forum Thread Details

Project Module - WIP and COS Computation by department

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.

Quick Links

Leaderboard