TRAN_OUT_BAL Flagged for Catch Weight Item
(Doc ID 2827582.1)
Last updated on DECEMBER 13, 2021
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.
Getting TRAN_OUT_BAL errors when there WEIGHTABLE ITEMS transactions in RTLOG.
1. Send an RTLOG with mix of catchweight and regular items. All with the RTLOG catchweight indicator set to N (position 377 on TITEM line)
2. After running saimptlogi, TRAN_OUT_BAL error occurs even though the thetotal sales value is equal to the Tender Line amount.
3. Issue occurs because the rounding on RESA makes use of the store's retail decimal precision (usually set as 2) , instead of 4.
For example for Catweight item 1 = Unit retail is 1.7897 whilst Qty is 13.46 with Selling UOM of LB - The total retail for this item should be 24.0894 but saimptlogi was computing it as 24.09.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document