PJC Revenue recognition

[Zak2009]

Hi All,

We are developing a different logic of revenue recognition using macros. We want it to recognize revenue partially from the amount billed i.e if the amount billed is 2000 then we can recognize 100 every month for 20 months based on this.

We are having challenges in that if the total amount billed is 2000 then we use our macro to run lets say 100 it does but you cant run it again to recognize another 100. Its like there is a status in a table we haven't found that dictates that we have already run. Could anyone have an idea which table or status we are not affecting.

This are the tables we are affecting in pjc

PMRWD RR Worksheet Detail
PMRWDD RR Worksheet Accounts
PMRWDO RR Detail Optional Field
PMRWH Revenue Recognition Worksheet

version Sage 300 erp
sp 1
Msql database

Thanks.

Thanks

 

[DjangMan]

IIRC the PMCATGT table holds the amount recognized to date and when the revenue <> recognized to date that triggers the update of the REv. Rec. Worksheet. When you post the worksheet the recognized to date value is updated.