赠品毛利为负直接处理但是7月已有结转并且直接改毛利会出现红帐页(主要是因为改splsk结存金额)需要先更新明细再对明细进行合计(防止同一单据开出其它品种)update spls_ck set chkje=0,ml=0,chbdj=0,jcje=85.47,hwjcer=85.47 where spid='SPH00005569' and rq>='2015-08-01'update pf_c
限制验收入库只能将赠品入库到赠品库 SBP_mx_zdjy限制销售为中包装的整数倍cast(shl/jlgg1 int)<>shl/jlgg1
GSP入库验收单删除操作界面无法删除,因明细部分数据的is_zx<>否为以后查清原因只对汇总表进行更新update jzorder_hz_ysd set is_zx = '清' where djbh ='JYTYMA00000852 'update jzorder_hz_ysd set is_zx = '清' where djbh ='JYTYMA00000855 '
在调整效期时发现数量会变多,另外数量调整时应当进行数量存盘校验!SPH00005239
select a.*,d.dwmch from fr_spkfk0819 a join spkfk b on a.商品编号=b.spbhleft join (select dwbh,spid,row_number() over (PARTITION BY spid order by plh) row from spls_rk) c on b.spid=c.spid and c.row=1
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号