发票保存时提示：单据索引不唯一，单据保存失败问题现象：在销售模块做销售发票，单据保存时提示：单据索引不唯一，单据保存失败问题原因：表SaleBillVouchSaleBillVouchs和表UA_Identity最大单据号不一致解决方案：useufdata_999_2003selectmax（sbvid）fromSaleBillVouchaselectmax（autoid）fromSaleBillVouchsbupdateUA_Identitysetifatherid=aichildid=bwherecVouchType=‘billvouch’andcAcc_Id=‘999‘注意：这种现象在恢复物理数据后经常出现在做此操作前请备份好帐套数据下面是UA_Identity表格字段名称对照表字段标识描述主表字段子表字段Rd收发记录主子表Rdrecord.idRdrecords.autoidBILLVOUCH销售发票主子表SaleBillVouch.SBVIDSaleBillVouchs.autoidDISPATCH发货退货单主子表DispatchList.dlidDispatchLists.autoidPOMain采购订单主子表PO_Pomain.POIDPO_Podetails.idSOMain销售订单主子表SO_SOMain.idSO_SODetails.autoidPURBILL采购发票主子表PurBillVouch.PBVIDPurBillVouchs.IDPURSTID采购结算单主子表PurSettleVouch.PSVIDPurSettleVouchs.IDSETTLEVOUCH委托代销结算单主子表SA_SettleVouch.IDSA_SettleVouchs.AutoidJu出入库调整单主子表JustInVouch.IDJustInVouch.AutoidPUAPP采购请购单主子表PU_AppVouch.IDPU_AppVouchs.AutoidPUARRIVAL采购到货单主子表PU_ArrivalVouch.IDPU_ArrivalVouchs.AutoidTr库存调拨单主子表TransVouch.IdTransVouchs.AutoidEXPENSE代垫费用单主子表ExpenseVouch.IDExpenseVouchs.AutoidCh盘点单主子表CheckVouch.IDCheckVouchs.AutoidMa限额领料单主子表MatchVouch.IDMatchVouchs.AutoidSALEPAY销售支出单主子表SalePayVouch.IDSalePayVouchs.AutoidQUOMAIN销售报价单主子表SA_QuoMain.IDSA_QuoDetails.AutoidXJ收付款单主子表(销售现结使用)Ap_CloseBill.iIDAp_CloseBills.IDSK收付款单主子表(收款cCancelNoisnull)Ap_CloseBill.iIDAp_CloseBills.ID
