Revenue Recognition

Adaxa documentation of the improvements can be found at:
http://www.adempiere.com/Revenue_Recognition

I noticed there is an additional improvement not documented - added the field "Fixed recognition day" to the Revenue Recognition definition when is time based.

On top of the Adaxa improvements I made some additional things:

• enabled the process to run also for AP Invoices - in original just work for AR Invoices - however - AR/AP are using the same account BP Group - Unearned Revenue, so it would be needed to define different groups for vendors and customer to setup the proper "unspent expense" in the case of AP.

• also I changed it to generate just journal - adaxa original generated additionally a journal batch that is not necessary

• and made a fix to make it work with the organization of the revenue recognition - it was throwing an error when the user executed the process with * org at login

Regards,

Carlos Ruiz

FWIW attaching here

Open

- a first basic version of a java program I made to convert Adaxa xml migration steps to SQL.

For this ticket I ran the following script:

Thanks @Hiep Lq, fixed at 61c770a

hi mr @Carlos Ruiz migrate sql have out of date range value

UPDATE AD_Field SET IsDisplayed='Y', IsDisplayedGrid='Y',Updated=TO_TIMESTAMP('2018-11-37 23:06:14','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=11767
;

UPDATE AD_Field SET IsDisplayed='Y', IsDisplayedGrid='Y',Updated=TO_TIMESTAMP('2018-11-37 23:06:14','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=5529
;

UPDATE AD_Field SET IsDisplayed='Y', IsDisplayedGrid='Y',Updated=TO_TIMESTAMP('2018-11-37 23:06:14','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=5431
;

UPDATE AD_Field SET IsDisplayed='Y', IsDisplayedGrid='Y',Updated=TO_TIMESTAMP('2018-11-37 23:06:14','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=3079
;

UPDATE AD_Field SET IsDisplayed='Y', IsDisplayedGrid='Y',Updated=TO_TIMESTAMP('2018-11-37 23:06:14','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=53577
;

UPDATE AD_Field SET IsDisplayed='Y', IsDisplayedGrid='Y',Updated=TO_TIMESTAMP('2018-11-37 23:06:14','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=4821
;

UPDATE AD_Field SET IsDisplayed='Y', IsDisplayedGrid='Y',Updated=TO_TIMESTAMP('2018-11-37 23:06:14','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=53875
;