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.