Kingdee EAS "general ledger" system calls "de posting" button

Steps need to be executed in sections

1、 Step one

Check whether there are control parameters

SELECT 1 FROM T_BAS_Param WHERE FNUMBER ='GL_VCH_POST_CONTROL'

If there is no query result in the previous sentence, execute this sentence to insert control parameters

insert into t_bas_param(FID, FDEFAULTVAL_L1, FDEFAULTVAL_L2, FDEFAULTVAL_L3, FVALUEALIAS_L1, FVALUEALIAS_L2, FVALUEALIAS_L3, FDESC_L1, FDESC_L2, FDESC_L3, FISUSERDEFINED, FNAME_L1, FNAME_L2, FNAME_L3, FNUMBER, FISGROUPCONTROL, FCANBEMODIFIED, FDEFAULTVAL, FORGTYPE, FCREATORID, FCREATETIME, FLASTUPDATEUSERID, FLASTUPDATETIME, FVALUERANGE, FDATATYPE, FSUBSYSID, FBASETYPE, FUSEREDIT, FUSERCLASS, FVALUEALIAS, FCONTROLUNITID)
 values 
('iQnWfWlzS+uX+spJ8zwdOKiB8+c=', N'true', N'true', N'true', N'true', N'true', N'true', N' Controls posting in order , Voucher anti posting is not allowed ', N' Controls posting in order , Voucher anti posting is not allowed ', N' Controls posting in order , Voucher anti posting is not allowed ', 0, N' GL voucher posting control ', N' GL voucher posting control ', N' GL voucher posting control ', N'GL_VCH_POST_CONTROL', 1, 1, null, -1, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2014-02-25 11:06:58'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2014-02-25 11:06:58'}, 'nU+qN8+OSpOoKJELcC0hhhsoUZM=', 3, N'com.kingdee.eas.fi.gl.gl', null, 0, null, null, '00000000-0000-0000-0000-000000000000CCE7AED4');

2、 Step two

Judge whether there is a parameter value

select  1 from t_bas_paramitem where fkeyid =(select fid from T_BAS_Param WHERE FNUMBER ='GL_VCH_POST_CONTROL'

If there is no query result in the previous sentence, execute this sentence

insert into t_bas_paramitem(FID, FVALUE_L1, FVALUE_L2, FVALUE_L3, FVALUEALIAS_L1, FVALUEALIAS_L2, FVALUEALIAS_L3, FISCONTROLSUB, FISMODIFY, FVALUE, FCREATORID, FCREATETIME, FLASTUPDATEUSERID, FLASTUPDATETIME, FKEYID, FORGUNITID, FORGTREEID, FVALUEALIAS, FCONTROLUNITID)
 values 
('gNUJEJa+Rm6fKwKSYuBUdu0ql5o=', N'false', N'false', N'false', N'false', N'false', N'false', 0, 0, null, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2014-02-25 11:06:58'}, '00000000-0000-0000-0000-00000000000013B7DE7F', {ts'2014-02-25 11:06:58'}, 'iQnWfWlzS+uX+spJ8zwdOKiB8+c=', null, null, null, '00000000-0000-0000-0000-000000000000CCE7AED4');

3、 Step three

Modify parameter value

Update t_bas_paramitem set fvalue_l1 = 'false',fvalue_l2='false',fvalue_l3 = 'false',FVALUEALIAS_L1='false',FVALUEALIAS_L2='false',FVALUEALIAS_L3='false' where fkeyid = (select fid from T_BAS_Param WHERE FNUMBER ='GL_VCH_POST_CONTROL');

You need to restart after modification EAS service , Otherwise it doesn't work .

This solution comes from the network .