on 04-13-2016 7:15 AM
Hi All,
I'm using 2LIS_06_INV extractor for my report. I want to display INV, INV ITEM, NET PRICE, QTY in the report.
In my DSO, Keys are INV NUMBER, INV ITEM NUMBER, FISCAL YEAR
I have noticed that from the extractor i'm getting 2 records for the same invoice.
INV INV ITEM NET PRICE QTY
1001 10 410 0
1001 10 0 8
Ideally i need to display as below. All details in one line.
INV INV ITEM NET PRICE QTY
1001 10 410 8
As you can see with the keys i have set new record will over write the other.
1. Why is this datasource is giving multiple records for same INV/LI ?
2. How do i achieve my goal in the report?
Regards,
DTD
there are a number of OSS notes explaining this behavior and how to handle. I suggest you search for them.
M.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
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.