5.0PT120107-ic_invoiceentry无效

旗舰版5.0打了PT120107补丁。后所有账套的销售发票审核或反审核不了。
提示原因:对象名'ic_invoiceentry无效'
解决办法:建表,
语句如下:
执行语句前请备份账套
[code]
/****** Object: Table [dbo].[IC_InvoiceEntry] Script Date: 08/13/2018 13:41:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[IC_InvoiceEntry](
[FEntryID] [int] IDENTITY(1,1) NOT NULL,
[FID] [int] NOT NULL,
[FIndex] [int] NOT NULL,
[FItemID] [int] NOT NULL,
[FPackagedGoods] [int] NOT NULL,
[FUnitID] [int] NOT NULL,
[FInvName] [nvarchar](500) NULL,
[FInvUnitID] [varchar](40) NOT NULL,
[FQty] [decimal](28, 10) NOT NULL,
[FPrice] [decimal](28, 10) NOT NULL,
[FNotTaxPrice] [decimal](28, 10) NOT NULL,
[FNotTaxAmount] [decimal](20, 4) NOT NULL,
[FEntryTaxAmount] [decimal](20, 4) NOT NULL,
[FAfterDiscountAmount] [decimal](20, 4) NOT NULL,
[FTaxRate] [de
5.0PT120107-ic_invoiceentry无效
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



