SM7311期初库存是负值，做个盘点入库单调到0

 

手动的sql语句

INSERT INTO SM_KC_CKRKB_TB
  (ID,
   RKRQ,
   SSSL,
   BZ,
   HSBL,
   DJBH,
   ZDSJ,
   ZDR,
   JYB,
   JKCK,
   JKCGY,
   PCID,
   HSDJ,
   SL,
   CKYKBOID,
   RKLSH,
   MZ,
   XS,
   ZX,
   ZXGGXH,
   RKTJ,
   DJ,
   DDBH,   
   YPZL,
   KWMC,
   JE,
   GYSID,
   XSR,
   BZ_CLKC,
   HLBZ,
   DJLX,
   RKBM,
   JKR,
   WLBZ,
   CKMC,
   CGY,
   BZID,
   JTID,
   ZTZD,
   JYY,
   JYRQ,
   BC,
   QRSL,
   DDID,
   WLID,
   CGID,
   SCDDZXID,
   SSKG)
  select 114,
         sysdate,
         20,
         '平库存用',
         HSBL,
         DJBH,
         ZDSJ,
         ZDR,
         JYB,
         JKCK,
         JKCGY,
         PCID,
         HSDJ,
         SL,
         CKYKBOID,
         RKLSH,
         MZ,
         XS,
         ZX,
         ZXGGXH,
         RKTJ,
         DJ,
         DDBH,   YPZL,
         KWMC, JE,
         GYSID,    XSR,
         BZ_CLKC,HLBZ,
         DJLX,
         RKBM,
         JKR,
         WLBZ,
         CKMC,
         CGY,
         BZID,
         JTID,
         ZTZD,
         JYY,
         JYRQ,
         BC,
         QRSL,
         DDID,
         WLID,
         CGID,
         SCDDZXID,
         SSKG
    from SM_KC_CKRKB_TB
   where id = (select max(id) from sm_kc_ckrkb_tb 
   where wlid=79951 and ckmc=39);
commit;