on 03-20-2010 7:16 AM
用DTW更新物料价格清单报错
主表:Items
RecordKey ItemCode
RecordKey ItemCode
151 01.0065
副表:Items_Prices
RecordKey PriceList Currency Price
RecordKey PriceList Currency Price
151 1 RMB 91000.490000
Source Date Type:Tab
勾选了:
Update Existing Object
Test Run
运行后出现如下错误:
This entry already exists in the following tables(ODBC-2035)Aplication-defined or object-defined error 65171
请大侠帮我看看,先谢谢了。急,今天就要更新3万多条物料主数据的采购价和销售价。help me!
最后检查了一下,是DTW的版本没升级的原因。还有就是用了DTW得默认字段linenum,而不用pricelist字段。就可以导入成功。谢谢Gordon的解答。
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
也许答的太晚了,好像你不只勾了Update Existing Object。否则不会得到This entry already exists in the following tables错误。
你的PriceList 如果是在OPLN表中的第二行才对。
DTW前,用文本编辑器查看一下,任何有问题的数据都容易发现。
谢谢,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.