【问题】: (FAQ)销售订单新增带出基本价格报错
版本: 7.5
模块: 销售政策
【答复】:
原因分析：物料基本分类在分类明细表中没有记录导致取价异常。 解决方法：提供下面修复KSQL脚本。 --备份物料分类明细 SELECT * INTO bak0529_MaterialGroupDetial FROM T_BD_MaterialGroupDetial; --删除基本分类明细 DELETE T_BD_MaterialGroupDetial　WHERE FMaterialGroupStandardID = 'dR8lnQEPEADgAAWKwKgSxZeb4R8='; --重建基本分类明细 INSERT INTO T_BD_MaterialGroupDetial (FID, FMaterialID, FMaterialGroupStandardID, FMaterialGroupID) SELECT Newbosid('B9B5052C') AS fid, fid AS fmaterialid, 'dR8lnQEPEADgAAWKwKgSxZeb4R8=' AS FMaterialGroupStandardID, FMaterialGroupID FROM T_BD_Material;

原因分析：物料基本分类在分类明细表中没有记录导致取价异常。 解决方法：提供下面修复KSQL脚本。 --备份物料分类明细 SELECT * INTO bak0529_MaterialGroupDetial FROM T_BD_MaterialGroupDetial; --删除基本分类明细 DELETE T_BD_MaterialGroupDetial　WHERE FMaterialGroupStandardID = 'dR8lnQEPEADgAAWKwKgSxZeb4R8='; --重建基本分类明细 INSERT INTO T_BD_MaterialGroupDetial (FID, FMaterialID, FMaterialGroupStandardID, FMaterialGroupID) SELECT Newbosid('B9B5052C') AS fid, fid AS fmaterialid, 'dR8lnQEPEADgAAWKwKgSxZeb4R8=' AS FMaterialGroupStandardID, FMaterialGroupID FROM T_BD_Material;