修改了这几个字段的值,然后报错,报错后修改回去,还是报错,报错内容如下
出现不可修复的错误,MRP计算操作已终止,可查看MRP日志或系统日志确认原因!
错误信息:不可预料的MRP计算错误!source:SELECT DISTINCT '95a98e0ab62880e111e879eb1696501a' computeid, ((t2.FSTOCKBASEQTY - t2_E.FSTOCKBASESTOCKOUTQTY) + t2_E.FSTOCKBASEREBACKQTY) baseorderqty, ((t2.FSTOCKBASEQTY - t2_E.FSTOCKBASESTOCKOUTQTY) + t2_E.FSTOCKBASEREBACKQTY) basedemandqty, t0.FSALEORGID demandorgid_id, t2.F_AI_PLANFINISHTIME demanddate, 0 demanddayid, 0 extendcontrol, t2.FMATERIALID materialid_id, t2.FPRIORITY priority, t0.FBILLNO relationbillno, t2.FENTRYID relationentryid, t0.FOBJECTTYPEID relationformid_id, t0.FID relationinterid, t0.FBILLNO srcbillno, t2.FENTRYID srcentryid, t0.FOBJECTTYPEID srcformid_id, t0.FID srcinterid, ((t2.FSTOCKBASEQTY - t2_E.FSTOCKBASESTOCKOUTQTY) + t2_E.FSTOCKBASEREBACKQTY) basegrossqty, t2.FSTOCKORGID instockorgid_id, '' mergerowid, t2.FMTONO mtono, t2.FOWNERID ownerid_id, t2.FOWNERTYPEID ownertypeid, t2.F_AI_PLANFINISHTIME planfinishdate, t2.F_AI_PLANFINISHTIME planstartdate, t2.FSUPPLYORGID supplyorgid_id, t2.FRESERVETYPE reservetype, t2.FAUXPROPID auxpropid_id, 1 basedenominator, t2_E.FSTOCKBASESTOCKOUTQTY baseexecqty, 1 basenumerator, t2.FBOMID bomid_id, 0 execqty, 0 grossqty, t2.FLOT_TEXT lot_text, t2.FLOT lot_id, 0 orderqty, t2_R.FREMAINOUTQTY qty, t2.FSTOCKUNITID unitid_id, t2.FSTOCKBASEQTY baseqty, t2.FBASEUNITID baseunitid_id, t0.FDATE billdate, 0 demandqty, t0.FSALEORGID orgid_id, t2.FSeq relationentryseq, t0.FID saleorderid, t2.FENTRYID saleorderentryid, t0.FBILLNO saleorderno, t2.FSeq saleorderentryseq, '1' demandtype, t2.FSeq srcentryseq FROM T_SAL_ORDER t0 LEFT OUTER JOIN T_SAL_ORDERENTRY t2 ON t0.FID = t2.FID LEFT OUTER JOIN T_SAL_ORDERENTRY_R t2_R ON t2.FENTRYID = t2_R.FENTRYID LEFT OUTER JOIN T_SAL_ORDERENTRY_E t2_E ON t2.FENTRYID = t2_E.FENTRYID INNER JOIN T_MRP_COMPUTEDATA2 ON (((T_MRP_COMPUTEDATA2.FRelationInterId = t2.fid AND T_MRP_COMPUTEDATA2.FRelationEntryId = t2.fentryid) AND T_MRP_COMPUTEDATA2.FRelationFormId = 'SAL_SaleOrder') AND T_MRP_COMPUTEDATA2.FComputeId = '95a98e0ab
推荐阅读