從請購單生成訂單時,過濾請購單選擇列表,選擇00000000221號請購單時提示:單據轉換時發生錯誤,詳細信息為:所選用于生單的數據已經被別人修改。
可通過下列語句處理解決:
use ufdata_001_2011
select invcode from bas_part group by invcode having count(invcode)>1
delete from bas_part where invcode in (select invcode from bas_part group by invcode having count(invcode)>1) and partid not in (select min(partid) from bas_part group by invcode having count(invcode)>1)
請檢查inventory_sub表、bas_part表中0308的存貨是否有重復記錄,如果沒有啟用結構性自由項,則inventory_sub表、bas_part表中存貨編碼為0308的存貨應該只有一條記錄。如有重復的,請刪除重復記錄即可。