microsoft / microsoft/BCApps

[Bug]: Incorrect calculating of WIP for a project

Open
#9,462 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Ownership: Manual Team: SCM
Dominant language
AL
Stars
683
Forks
459
Avg merge
3d 26m
Merged PRs (30d)
633

Description

Describe the issue

When WIP is used for a project with the WIP method cost value, the calculation of the method does not show the correct WIP amount and the correct percentage of completion. In addition is the project planning line always getting the line type “both budget and billable” no matter what type is used in the project journal lines. With this is the total of the project planning line for the WIP calculation adding up the project planning lines instead of leaving the budget and calculating the WIP based on the budget.
Example:
Project with the project task type posting and the WIP method cost value

Image

The project has a project line with line type budget and quantity 10 hours.

Image

To record the usage of the project the project journal is used. The line type is billable and quantity is 2 hours.

Image

Once the entry of the project journal is posted, the project planning line gets the line type both budget and billable and the base for the calculation of the percentage of completion is changing from 10 hours to 12 hours. This is incorrect, since the base should always be the original amount of the budget.

Image Image
Expected behavior

The project line for the WIP calculation should not add up. The base for the calculation and the completion should always be the amount of the budget. In above case the expected value for the %Completed should be 20%.
The applied costs and recognized costs of the above example should be 154.

Image
Steps to reproduce
  1. Create a project with a project task and project task type Posting and WIP method cost value
  2. Create project planning lines with line type budget
  3. Open project journals and create a line with line type billable and post the line
  4. Create a sales invoice and post the invoice
  5. Calculate WIP
Additional context

No response

I will provide a fix for a bug
  • I will provide a fix for a bug

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Reproduce the issue through the listed Business Central project, project journal, sales invoice, and WIP calculation steps. Trace how billable journal usage changes the project planning line and WIP percentage base; done means the budget remains the calculation base, completion is 20% in the example, and applied and recognized costs are 154.

Written by the indexing model from the issue text.

Assessment

Domain
backend
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.