on 09-19-2008 2:29 PM
Hi, I'm struggling with some values being incorrect in my ODS. I have a current order with 1 order qty and 1 confirmed qty. The order was created back in the beginning of the year and just recently got confirmed.
In BW ODS it shows 1 order qty and 0 confirmed qty. Which is incorrect.
From everything I have read about ABR the Before Image Values in the change log should all be negative. This is the sales item LIS extractor 2LIS_11_VAITM.
When I look at the Before Image Record I see the order qty as negative 1(fine), but the confirmed qty is positive 1? ( I would have thought the confirmed value should be zero in the before image). How can the
Before image record have a positive value?
When I look at the After Image Records I see the order qty as pos 1 (fine) and confirmed qty is 0( I thought this should be 1).
Can anyone help me out with this scenario?
1. Why would the Before Image have a positive 1 for a confirmed qty?
2. Why would the After Image have a 0 confirmed qty if the confirmation generated these records?
Change Log Records
Order Qty Confirmed Qty
Before Image -1 1
After Image 1 0
Thanks!
will revisit later
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Confirmed quantity can be negative in case of return I think.
Before images are the opposite sign not necessarily negative values.
So this does make sense.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.