Note Upgrade 8.2

IDEMPIERE-4474

202009251357_IDEMPIERE-4474.sql

UPDATE C_AcctSchema SET C_Period_ID=200104,Updated=TO_DATE('2020-09-25 13:30:34','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE C_AcctSchema_ID=101

Issue: MPeriod on gardenworld normal create by idempiere on each release in case you start from 6.1 and manual create calendar 2020 then you haven't C_Period_ID=200104 so get issue with this migrate script

Solution: comment out this line

IDEMPIERE-4297

202010031628_IDEMPIERE-4297.sql

Insert new schema

INSERT INTO C_AcctSchema (C_AcctSchema_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,Name,GAAP,IsAccrual,CostingMethod,C_Currency_ID,AutoPeriodControl,C_Period_ID,Period_OpenHistory,Period_OpenFuture,Separator,HasAlias,HasCombination,IsTradeDiscountPosted,IsDiscountCorrectsTax,M_CostType_ID,CostingLevel,IsAdjustCOGS,IsPostServices,IsExplicitCostAdjustment,CommitmentType,Processing,TaxCorrectionType,IsAllowNegativePosting,IsPostIfClearingEqual,C_AcctSchema_UU) VALUES (200000,11,0,'Y',TO_DATE('2020-10-03 15:53:24','YYYY-MM-DD HH24:MI:SS'),100,TO_DATE('2020-10-03 15:53:24','YYYY-MM-DD HH24:MI:SS'),100,'GardenWorld Euro','UN','Y','A',102,'Y',200104,10000,100,'-','Y','N','N','N',100,'C','N','N','N','N','N','N','Y','Y','546a277d-0ad3-4935-bf2a-7eb6d348b978')

Issue:same reason of #202009251357_IDEMPIERE-4474.sql C_Period_ID=200104 not exists

Solution: get C_Period_ID from old schema, do replace this line by bellow

INSERT INTO C_AcctSchema (C_AcctSchema_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,Name,GAAP,IsAccrual,CostingMethod,C_Currency_ID,AutoPeriodControl,C_Period_ID,Period_OpenHistory,Period_OpenFuture,Separator,HasAlias,HasCombination,IsTradeDiscountPosted,IsDiscountCorrectsTax,M_CostType_ID,CostingLevel,IsAdjustCOGS,IsPostServices,IsExplicitCostAdjustment,CommitmentType,Processing,TaxCorrectionType,IsAllowNegativePosting,IsPostIfClearingEqual,C_AcctSchema_UU) SELECT 200000,11,0,'Y',TO_DATE('2020-10-03 15:53:24','YYYY-MM-DD HH24:MI:SS'),100,TO_DATE('2020-10-03 15:53:24','YYYY-MM-DD HH24:MI:SS'),100,'GardenWorld Euro','UN','Y','A',102,'Y',c_period_id,10000,100,'-','Y','N','N','N',100,'C','N','N','N','N','N','N','Y','Y','546a277d-0ad3-4935-bf2a-7eb6d348b978' FROM C_AcctSchema WHERE C_AcctSchema_ID=101

M_StorageReservation

INSERT INTO M_StorageReservation (AD_Client_ID,AD_Org_ID,Created,CreatedBy,IsActive,M_AttributeSetInstance_ID,M_Warehouse_ID,M_Product_ID,Qty,Updated,UpdatedBy,IsSOTrx,M_StorageReservation_UU) VALUES (11,11,TO_DATE('2020-10-03 17:20:23','YYYY-MM-DD HH24:MI:SS'),100,'Y',0,103,123,0.0,TO_DATE('2020-10-03 17:20:23','YYYY-MM-DD HH24:MI:SS'),100,'N','202ee7de-9839-41fa-ac05-caf4a740442b')

and

INSERT INTO M_StorageReservation (AD_Client_ID,AD_Org_ID,Created,CreatedBy,IsActive,M_AttributeSetInstance_ID,M_Warehouse_ID,M_Product_ID,Qty,Updated,UpdatedBy,IsSOTrx,M_StorageReservation_UU) VALUES (11,11,TO_DATE('2020-10-03 17:20:23','YYYY-MM-DD HH24:MI:SS'),100,'Y',0,103,130,0.0,TO_DATE('2020-10-03 17:20:23','YYYY-MM-DD HH24:MI:SS'),100,'N','6fc62202-3ef5-4a18-b4c9-bc09f9198689')

Issue: this two line can be make error in case your instance also has reservation for product_id 123 and 130 on warehouse 103 with asi null and IsSOTrx = N

Solution: comment out this line run process "Recreate Storage Reservation" after migrate success

Fact_Acct

DELETE FROM Fact_Acct WHERE AD_Client_ID=11

Issue: this line make issue when has data on other table reference to it, my case is Fact_Reconciliation Solution: before this line add command to delete dependency data this is my case

DELETE FROM Fact_Reconciliation WHERE AD_Client_ID=11