Does anyone know of any way using any combination of Project Controller, Flexible Billings and Allocator to automatically clear WIP to COS when batches of projects are completed at the end of the month?
Using Flexible Billings alone, there is a way to do it but you have to enter COS budgets for each project, and at project completion if there's a variance between actual and budget, you have to manually make an entry to clear it. This is more labor intensive than to clear WIP manually.
Using Allocator, there probably is a way to calculate and hold, then when project is completed, run allocator to post an entry to clear WIP and offset COS. However, I can't think of a way to do this in month-end batches. If they have to run allocator for the individual projects as they are completed, it would be more labor intensive than to clear WIP manually.
Let me know if anyone has any clever ideas.
*This post is locked for comments
I have the same question (0)