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] [decimal](20, 4) NOT NULL,
[FEntryTax] [decimal](20, 4) NOT NULL,
[FItemType] [nvarchar](100) NOT NULL,
[FSourceInterId] [int] NOT NULL,
[FEntryID_SRC] [int] NOT NULL,
[FClassID_SRC] [int] NOT NULL,
[FBillNo_SRC] [nvarchar](1000) NOT NULL,
CONSTRAINT [PK_IC_InvoiceEntry] PRIMARY KEY NONCLUSTERED
(
[FEntryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
[/code]
原地址:https://wenku.my7c.com/questions/43093783198892181
{:6_156:}
5.0PT120107-ic_invoiceentry无效
本文2024-09-16 21:53:17发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-44546.html