EBS WEBADI导入报错,无法选择分类账

操作步骤

总账-日记账-日记账向导,下载WEBADI模板。打开后,选择分类账报错。

报错截图

1231.png


错误原因

只要总账名字和数据访问权限集的名字不一样,就会出现这种问题。

常见于多平衡段的帐套。(这种帐套会按照职责限制能使用的平衡段,于是会新定义数据访问权限集,名字必然不同于原本的)


解决方式

实践中存在一种思路来解决这个问题:

修改WEBADI的Template,将分类账字段写上自己要的值(使用的时候不要点开值集校验,肯定还是报错,但是实际不影响使用)

此方法的缺点:会扩大可选范围(原本定义的小范围数据访问权限集没有用了)


下文是Metalink提供的解答:

CAUSE

This is explained in Bug 20808270 - WEBADI NOT VALIDATING LEDGER and in Bug 20765340 - WEB ADI SPREADSHEET RESPONSIBILITY - RESTRICT LEDGER BY DATA ACCESS SET AND COA. 
When attempting to upload journals thru WebADI, one of the users changed (hand typed) the Ledger name into the WebADI template, then added journals, selected upload, and the journals were successfully uploaded - to the incorrect ledger that was typed in.
The validation between the DAS and the Ledger did not occur.

SOLUTION

This is the expected functionality.
It is not feasible to refresh the value of "Data Access Set" field as it is in context section of the excel sheet.
Adding an additional check and throwing error message for the scenario where user is selecting a different data access set with same COA and selecting a different ledger will limit the flexibility and restrict the functionality that application provides currently.
Though the data access set field is not refreshed in the excel sheet, internally application is honoring all the security aspects related to data access set.


报错的英文版本

ERROR
-------------
"Please resolve the following error to continue.
The Data Access Set assigned to your responsibility uses a different Chart of Accounts than the one used when creating this spreadsheet.
To continue working on this spreadsheet, please relogin. Your responsibility must be associated with a Data Access Set that uses the original Chart of Accounts. " 

本文标题:EBS WEBADI导入报错,无法选择分类账

本文链接:http://catonisland.cn/post/224.html

本文版权归作者所有,欢迎转载,转载请以文字链接的形式注明文章出处。

相关文章