SRN Receiving Failure

来源:互联网 发布:音乐播放软件知乎 编辑:程序博客网 时间:2024/06/05 06:44

User reported that they fail to receive goods into inventory from a SRN order. 




Since the error message is "No cost of goods sold account is defined for the sales order", we check the Transaction Type setup. But the COGS Account is already maintained.



Solution:

When generating MTL material transactions, a workflow INVFLXWF/DEFAULT_ACCOUNT_GENERATION is created by the inventory transaction manager to validate the COGS account combination.

In this case, the core code is as below:

fnd_flex_keyval.validate_segs('CHECK_COMBINATION',

             'SQLGL', 'GL#', '101',
             'XXX-XXXX-XXXX-XXXX-XXXX',--account combination
             'V',
             sysdate,
             'ALL', NULL, NULL, NULL, NULL,
             false,
             false, NULL, NULL, NULL);

Unfortunately, this function return false cause our COGS Account is expired. As a result, the process is interrupted, but the error message is quite confusing.

0 0
原创粉丝点击