Hi,
We have some issue regarding how the project is consumed. To explain this I will need to explain how this happen, because I don't think it's a common issue. This is the story :
We have a project that sell our inventory to a customer. Therefore we create a Project and an Item requirement related to it. also we allocated some Project Budget to it based on the value of that inventory. After that, we proceed to execute the project, and everything goes smoothly.
Then the issue began when we are about to close the project. The PM required to submit a report of Project Statement. And turns out the cost of the inventory is not reflected there. After some investigation turns out this is the history of the transaction :
1. October 1st. We received the items from PO. We haven't received the invoicing from Vendor
2. October 6th. We ship the items to Customer (from SO). At the same day we issue an Invoice Proposal to Customer
3. October 15th. We received an Invoice from Vendor and register it into DAX.
4. October 25th. the PM must close the project, therefore he generated Project Statement report
From that history it is clear that the cost is not reflected because of the shipping inventory before PO invoicing. Therefore I told them to do Inventory recalculation. and it works as intended. now the cost is reflected as it should be.
Next the PM is required to generate the project budget report (using cost control). and this is where My issue is. The budget is not consumed as it should be, I assume this happen because of the same reason as above (shipping inventory before PO invoicing).
My query is :
Is there any way to fix it ? if not the is there a way for Project budget to use Physical value when it consume the Project budget ?
Very sorry for the long post. I hope this doesn't confuse you.
BR,
Satria WS