My Oracle Support Banner

Why Tran Data 15 Is Posted Twice With Tran Code 1 ? (Doc ID 2627280.1)

Last updated on JUNE 12, 2021

Applies to:

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

Goal

Why tran code 15 (Promotional Markdown) is being posted twice for same item with tran code 1 (Net Sales) in TRAN_DATA table.

ITEM                  LOCATION  TRAN_DATE   TRAN_CODE   UNITS   TOTAL_RETAIL
400021256712   13802923   07-NOV-19    1                 50        750
400021256712   13802923   07-NOV-19    15               50        -749.5
400021256712   13802923   07-NOV-19    15               50        749.5

Reference POSU File:

FHEAD0000000001POSU2019110801302213802923 N10 USD2
THEAD000000001220191107000000ITM400021256712 S 000000500000EA P00000000000007500000 N 00000000000000000000R
TDETL00000000131004 0000005000000000000000000750000000000000000007495000
TTAIL0000000014000001
FTAIL00000000420000000040

Solution

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
Goal
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.