Hi Alpha,

We have seen lots of situations as you and Steve have discussed where the method for revenue recognition struggles to work properly. You could say we are experts to install, configure, train and support client sites using Adagio Job Cost. Job Costing revenue/cost recognition struggled in Accpac Plus and even in Adagio Job Cost, the situation is much the same.

If you are lucky enough to get the stars to align, with estimates, billings, overhead setups, then you might be able to make the WIP entries work but not with enough reliability that myself as a professional accountant would want to interface and produce financial statements. I have seen situations where it is close for some jobs but for other jobs, no one can figure out why the numbers are what they are.

And if you are looking for support for this opinion, you might ask why there is no WIP report in Adagio Job Costing (or in ACCPAC Plus) that supports the calculations of the revenue recognition? And why many JC users basically create another month end job just to do the WIP and Deferred Revenue Analysis on spreadsheets, to attempt to support the WIP and Deferred amounts in the GL.

And for that very reason, we developed Link2SimpleCosting that relies on the date sensitive data in Job Costing which is usually very good, and then that lets you choose your revenue recognition method (outside of Adagio). Your choice of revenue recognition method is used by Link2SimpleCosting that creates accrual entries to calculate your WIP and your deferred revenue entries by job. And this add-on Link2 module will calculate correctly your WIP, your Deferred revenue, and is completely based upon the date of the transactions posted in your Job Costing database without having to wait for some magic date when all data for the previous month has been entered and posted (while holding out all job data from being posted until the WIP is calculated). The current Adagio Job Costing method of holding out the next month's entries from being posted is so reminiscent of ACCPAC Plus 6.0 when you kept your next month's entries in piles waiting to be entered after month end was complete.

So you can get these results using the Link2SimpleCosting (from Link2Systems) or you can get your Adagio consultant to create a series of Gridviews to calculate the month end values for WIP and Deferred Revenue using the transaction date of each entry, but to use what is really limited reporting within Job Costing is really playing with fire by hoping to get the right answer by choosing one of the revenue recognition methods and reporting in the existing module.

So this answers your question, why does this happen? Sorry, it is the reality but there is a resolution.

Best,
Brian