:::tip{title="错误"}
列名'Sys invalid'无效。异常ID:40057dbc-05b6-4671-b24d-eab3e63e235b
:::



![image.png](/static/img/592454e50a506903758b0d3da489a4a4.image.webp)

回答：执行以下脚本


```
--- 2024-01-24 零售调价单新添加作废标记
---- 添加作废字段 Sys_invalid 作废标记  非作废标记  Sys_invalid <1


IF NOT EXISTS(SELECT 1 FROM SYSCOLUMNS WHERE id=OBJECT_ID('DAT_LSTJ') AND name='Sys_invalid')
BEGIN
	ALTER TABLE DAT_LSTJ ADD Sys_invalid  bit DEFAULT(0)   -- 作废标记
END
GO

IF NOT EXISTS(SELECT 1 FROM SYSCOLUMNS WHERE id=OBJECT_ID('DAT_LSTJ') AND name='Sys_invalidDate_Server')
BEGIN
	ALTER TABLE DAT_LSTJ ADD Sys_invalidDate_Server  datetime  -- 作废时间
END
GO

IF NOT EXISTS(SELECT 1 FROM SYSCOLUMNS WHERE id=OBJECT_ID('DAT_LSTJ') AND name='Sys_invalid_emp_id')
BEGIN
	ALTER TABLE DAT_LSTJ ADD  Sys_invalid_emp_id varchar(50) -- 作废人
END
GO


--- 更改试图
if exists(select 1 from sysobjects where id=OBJECT_ID('N_BILL_LIST_DAT_LSTJ') and type='V')
drop view N_BILL_LIST_DAT_LSTJ
GO

CREATE VIEW [dbo].[N_BILL_LIST_DAT_LSTJ]
AS
SELECT DISTINCT 
                      a.id AS 流水单号, ISNULL(a.id2, '') AS 手工单号, ISNULL(a.idz, '') AS 流水单号2, 
                      CASE a.tj_kind WHEN 1 THEN '打折' WHEN 2 THEN '调价' WHEN 3 THEN '调价*打折' WHEN 4 THEN '无' END AS 调价方式, a.dis_mode AS 余数处理, 
                      a.dec_digits AS 小数位数, a.cause AS 调价原因, a.beg_date AS 开始日期, a.end_date AS 结束日期, a.sys_ipt_emp_id AS 制单员, CONVERT(char(10), a.sys_date, 120) 
                      AS 制单日期, a.sys_chk_emp_id AS 审核员, a.sys_sure_emp_id AS 确认员, a.sys_chk AS 审核, a.sys_sure AS 确认, CONVERT(char(10), a.sys_locdate, 120) 
                      AS 确认日期, RTRIM(a.sys_memo) AS 备注, CASE WHEN ISNULL(a.prt_nums, 0) > 0 THEN '是' ELSE '否' END AS 打印, a.Sys_Date_Server AS 制单时间, 
                      a.Sys_ChkDate_Server AS 审核时间, a.Sys_SureDate_Server AS 确认时间, isnull(Sys_invalid,0) 已作废
FROM         dbo.DAT_LSTJ AS a LEFT OUTER JOIN
                      dbo.DAT_LSTJ_DTL8 AS b ON a.id = b.id
GO
```

列名'Sys invalid'无效。

:::tip{title="提示"}
列名'POSOnlySelectOneEmp'无效。异常ID:c51331d0-d3a3-4fa2-a3f4-f6080a562636
:::




![image.png](/static/img/2535c2f191dae4412c192da6ef74fb99.image.webp)

回答：执行脚本


```
--2014-03-05店铺资料添加选项POS收银只能选一个销售员
IF NOT EXISTS(SELECT * FROM syscolumns WHERE [ID] = object_id(N'BAS_SHP') AND [NAME] = N'POSOnlySelectOneEmp')
begin
	alter table BAS_SHP add  POSOnlySelectOneEmp bit  CONSTRAINT [DF_BAS_SHP_POSOnlySelectOneEmp]  DEFAULT (0) ; -- POS收银只能选一个销售员
	EXEC dbo.sp_executesql N'update BAS_SHP set POSOnlySelectOneEmp=0' 
end



```

列名'POSOnlySelectOneEmp'无效。

:::tip{title="盘点"}
此单据盘点类型错误
:::




![image.png](/static/img/445cdbfc1ddf4955dd14e5e5909bf759.image.webp)

![image.png](/static/img/6b56e8819491466ebc079d69cdd0670e.image.webp)

回答：
这个是盘点类型 错误，选择全局盘点和局部盘点

此单据盘点类型错误

:::tip{title="提示"}
SqlDateTime 溢出。必须介于 1/1/1753 12:00:00 AM 和 12/31/9999 11:59:59 PM 之间.
:::




    
![image.png](/static/img/38c0665c865f4bd44404b4e3e896b4e2.image.webp)

回答：这个是因为盘点单 入账日期 或者实际盘点日期错误了，调整一下即可


![image.png](/static/img/793487cab1a134cfc2194670f695680f.image.webp)

SqlDateTime 溢出。必须介于 1/1/1753 12:00:00 AM 和

:::tip{title="提示"}
允许店铺负库存销售
:::



回答： 资料--营销机构资料---成品店仓资料---选项控制

9.0 

![7746b6c308c56d7de73338ce3ac98ca.png](/static/img/a17bde75ce8fa1fe06cf4a53a8864558.7746b6c308c56d7de73338ce3ac98ca.webp)



10.0系统

![image.png](/static/img/5f9ad1a2fe895d89ce7b674ca663511d.image.webp)