Please run the following fix
Update ra_interface_lines_all
set Request_id = Null
where NVL(INTERFACE_STATUS, '~') != 'P'
AND (REQUEST_ID IS NOT NULL)
AND BATCH_SOURCE_NAME = 'Order Entry' ;
COMMIT
After this rerun Autoinvoice Program and it will process all records.
A problem about Autoinvoice
最新推荐文章于 2025-08-17 11:46:17 发布
本文提供了一个SQL脚本,用于更新数据库中特定状态的记录,并清空请求ID字段。执行此脚本后,需重新运行自动开票程序以处理所有受影响的记录。
17万+

被折叠的 条评论
为什么被折叠?



