SOS，在线求助！未发现此辅项类别：‘4N’

缺氧的鱼

单位新建一百多个帐套，有行政，事业的。昨天会计开始输入会计科目余额，事业单位账套出现问题！
未发现此辅项类别：‘4N’
请检查此辅项类别是否已成功设置！

jh4617233

gl_fzxlb  gl_fzxzl 有问题 真不行执行下收支分类脚本

◇◆丶淡忘

if not exists(select top 1 lbdm from gl_fzxlb where lbdm='4' and gsdm='' )
  Insert Into gl_fzxlb(lbdm,gsdm,lbmc,lbname,lbfj,sflx,syzt,sfqy)
  VALUES('4','','功能分类','功能分类','3-2-2-2',0,0,1)      

  if not exists(select top 1 lbdm from gl_fzxlb where lbdm='5' and gsdm='' )
  Insert Into gl_fzxlb(lbdm,gsdm,lbmc,lbname,lbfj,sflx,syzt,sfqy)
  VALUES('5','','经济分类','经济分类','3-2-2',0,0,0)      

  if not exists(select top 1 lbdm from gl_fzxlb where lbdm='6' and gsdm='' )
  Insert Into gl_fzxlb(lbdm,gsdm,lbmc,lbname,lbfj,sflx,syzt,sfqy)
  VALUES('6','','固定6','固定项目6','3-2-2',1,0,0)      

  if not exists(select top 1 lbdm from gl_fzxlb where lbdm='7' and gsdm='' )
  Insert Into gl_fzxlb(lbdm,gsdm,lbmc,lbname,lbfj,sflx,syzt,sfqy)
  VALUES('7','','固定7','固定项目7','3-2-2',1,0,0)      

  if not exists(select top 1 lbdm from gl_fzxlb where lbdm='8' and gsdm='' )
  Insert Into gl_fzxlb(lbdm,gsdm,lbmc,lbname,lbfj,sflx,syzt,sfqy)
  VALUES('8','','固定8','固定项目8','3-2-2',1,0,0)      

  if not exists(select top 1 lbdm from gl_fzxlb where lbdm='9' and gsdm='' )
  Insert Into gl_fzxlb(lbdm,gsdm,lbmc,lbname,lbfj,sflx,syzt,sfqy)
  VALUES('9','','固定9','固定项目9','3-2-2',1,0,0)

  if not exists(select top 1 lbdm from gl_fzxlb where lbdm='A' and gsdm='' )
  Insert Into gl_fzxlb(lbdm,gsdm,lbmc,lbname,lbfj,sflx,syzt,sfqy)
  VALUES('A','','固定10','固定项目10','3-2-2',1,0,0)      

  if not exists(select top 1 lbdm from gl_fzxlb where lbdm='Z1' and gsdm='' )
  Insert Into gl_fzxlb(lbdm,gsdm,lbmc,lbname,lbfj,sflx,syzt,sfqy)
  VALUES('Z1','','自定义1','自定义1','3-2-2',1,0,0)      

  
  if not exists(select top 1 lbdm from gl_fzxlb where lbdm='Z2' and gsdm='' )
  Insert Into gl_fzxlb(lbdm,gsdm,lbmc,lbname,lbfj,sflx,syzt,sfqy)
  VALUES('Z2','','自定义2','自定义2','3-2-2',1,0,0)      

  if not exists(select top 1 lbdm from gl_fzxlb where lbdm='Z3' and gsdm='' )
  Insert Into gl_fzxlb(lbdm,gsdm,lbmc,lbname,lbfj,sflx,syzt,sfqy)
  VALUES('Z3','','自定义3','自定义3','3-2-2',1,0,0)      

  
  if not exists(select top 1 lbdm from gl_fzxlb where lbdm='Z4' and gsdm='' )
  Insert Into gl_fzxlb(lbdm,gsdm,lbmc,lbname,lbfj,sflx,syzt,sfqy)
  VALUES('Z4','','自定义4','自定义4','3-2-2',1,0,0)