【问】分店做采购收货单时提示不存在供应商和商品的对应关系，是否继续录入！但商品档案中可以查到对应供应商

【问题描述】 分店做采购收货单时提示不存在供应商和商品的对应关系，是否继续录入！但商品档案中可以查到对应供应商

 

【答】

您好， 可以通过下面这个语句处理，总部处理完毕后，分发下全部数据分店下传。 --先执行， select b.item_no       ,b.branch_no       ,b.supcust_no       ,b.appointed_price       ,b.top_price       ,b.bottom_price       ,b.last_price       ,b.sale_way       ,b.[contract_date]       ,b.[memo]       ,b.[other1]       ,b.[other2]       ,b.[other3]       ,b.[num1]       ,b.[num2]       ,b.[num3]       ,b.[pur_status]       ,b.[direct_flag]       ,b.[default_flag]       ,b.[contract_no]  into t_bd_supcust_item_2 from  t_pc_branch_price a,t_bd_supcust_item b where a.item_no = b.item_no and a.branch_no = b.branch_no and a.supcust_no = b.supcust_no --再执行 drop table t_bd_supcust_item go USE [hbposepro] GO /****** Object:  Table [dbo].[t_bd_supcust_item]    Script Date: 08/06/2020 09:18:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[t_bd_supcust_item](  [item_no] [char](20) NOT NULL,  [branch_no] [char](6) NOT NULL,  [supcust_no] [char](8) NOT NULL,  [appointed_price] [numeric](16, 4) NULL,  [top_price] [numeric](16, 4) NULL,  [bottom_price] [numeric](16, 4) NULL,  [last_price] [numeric](16, 4) NULL,  [sale_way] [char](1) NULL,  [contract_date] [dbo].[u_date] NULL,  [memo] [varchar](255) NULL,  [other1] [varchar](20) NULL,  [other2] [varchar](20) NULL,  [other3] [varchar](20) NULL,  [num1] [numeric](16, 4) NULL,  [num2] [numeric](16, 4) NULL,  [num3] [numeric](16, 4) NULL,  [pur_status] [char](1) NULL,  [direct_flag] [char](1) NULL,  [default_flag] [char](1) NULL,  [contract_no] [varchar](20) NULL,  CONSTRAINT [PK_T_BD_SUPCUST_ITEM] PRIMARY KEY CLUSTERED (  [item_no] ASC,  [branch_no] ASC,  [supcust_no] 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 ALTER TABLE [dbo].[t_bd_supcust_item] ADD  DEFAULT (0) FOR [appointed_price] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD  DEFAULT (0) FOR [top_price] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD  DEFAULT (0) FOR [bottom_price] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD  DEFAULT (0) FOR [last_price] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD  DEFAULT ('A') FOR [sale_way] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD  DEFAULT (0) FOR [num1] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD  DEFAULT (0) FOR [num2] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD  DEFAULT (0) FOR [num3] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD  DEFAULT ('1') FOR [pur_status] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD  DEFAULT ('0') FOR [direct_flag] GO ALTER TABLE [dbo].[t_bd_supcust_item] ADD  DEFAULT ('0') FOR [default_flag] GO --最后执行 insert into t_bd_supcust_item select * from t_bd_supcust_item_2 感谢您的支持。