INTERNET APPLICATION DEVELOPMENT
MID MARKET ERP DEVELOPMENT
By Sheila Zhang
Have you noticed the Recognized columns on the Contract Maintenance screen?
It recently came to my attention when I worked on a Crystal Report based on the PJC module. I couldn’t figure out the numbers on any existing analytical report in the module. So, I started researching, based on my understanding of the process in PJC module. After you create and post the Revenue Recognition Worksheet of a contract or a project, some numbers are shown in the Recognized column on Contract Total or Project Total tab. In the backend, if you look at the database, the field "RRCOMPLETE" in table "PMTRAN" (Project Transaction History table) change its value from 1 to 3. Using the 2 fields “COSTREV” and “RRCOMPLETE” in table “PMTRAN”, you can get what the recognized numbers come from.
It seems that the first several projects made perfect sense. You can see one of them in below image.
However, when I went down to project "1012", I found my assumption really wasn't correct. The values of field "RRCOMPLETE" of all records were still 1, but some numbers were shown in the recognized column on Project Total tab as on the below image. I tried to run Revenue Recognition of project “1012” but no worksheet was created. What happened?
The answer is the Accounting Method of project "1012" is "Accrual-Basis". It is “Billings and Costs” in project “1002”.
After looking at more contracts and their projects, I am pretty sure my understanding is correct now.
In a summary, for the "Accrual-Basis" projects, even though you don't run the Revenue Recognition function, Sage Accpac still considers the actual amounts as recognized revenue or cost. That explained why no Revenue Recognition Worksheet was created when I tried to project “2012”. For other accounting method projects, you need to run Revenue Recognition function to convert all actual amounts into the recognized numbers.