:::tip{title="打印小票"}
字体"Tirnes New Roman"不支持样式"Regular”。
:::




![image.png](/static/img/3c6efa894345f679df63d9fe2509e585.image.webp)

回答：这个问题是因为系统权限问题。
找到易神的系统图标--点右键---属性---兼容性---以管理员身份允许此程序

![image.png](/static/img/72a849b9cc15b5fd6295dfb12f33399f.image.webp)

字体"Tirnes New Roman"不支持样式"Regular”。

:::tip{title="会员"}
店铺注册会员
:::



回答：

![319aa12825de5d99c7f2686e05cd8fc.png](/static/img/62a956f736d3cd0543c95725ad32b5bf.319aa12825de5d99c7f2686e05cd8fc.webp)


![image.png](/static/img/9a58ba851d90a9cff55771aefaab674f.image.webp)

注册会员

:::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)

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