My Oracle Support Banner

Incorrect Tran Code 70 Posted When Units < 0 (Doc ID 2922081.1)

Last updated on JANUARY 20, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

Seeing an issue where extra Tran_code 70 is posted for a Book Transfer messages (TC31) whenever inventory is negative. The location WAC is same as transaction cost in this case, however Tran code 70 is still posted.
This is resulting in net cost to be negative at the end of month even though the location has positive units.

Item 321439273
Location 4620
Total Units at beginning of month 0
Total Cost at beginning of month 0
Total Units at End of month 2
Total Cost at End of month -21.02
WAC at End of month 11.9326
Expected Total Cost at End of month 23.8652


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Post sale at store with zero inventory so that inventory goes negative.
2. Post book transfer IN at store with same WAC as ILS. Notice that It will post TC31 and TC70

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.