Retail Merchandising System (MOSC)

MOSC Banner

Transaction records in POSU file

edited Jul 13, 2012 12:37AM in Retail Merchandising System (MOSC) 2 commentsAnswered
Hi,
If a Item sold at same store day in 3 different transaction like :-
Transaction 1 :-
Item 10199534,
Unit Retail  :- 195
Qty 1
In-Store Disc 1 :- 34.82
In-Store Disc 2 :- 20.89
Net Retail :- 139.39

Transaction 2 :-
Item 10199534,
Unit Retail  :- 195
Qty 1
In-Store Disc :- 20.89
Net Retail :- 174.11

Transaction 3 :-
Item 10199534,
Unit Retail  :- 195
Qty 1
Net Retail :- 195.00


After running the saexprms batch, POSU file generated. In this only one record is available with sum of values of all transaction mentioned above. Instead of 3 separate records.
in Tran_data, tran_code 1,15 has sum of all 3 transaction.

What is the functional reason behind to create a POSU file with one record only instead of putting 3 records for each transaction? Why file not created with 3 separate records?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center