Skip to Content
avatar image
Former Member

2LIS_06_INV and DSO

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 13, 2016 at 07:57 AM

    there are a number of OSS notes explaining this behavior and how to handle. I suggest you search for them.

    M.

    Add comment
    10|10000 characters needed characters exceeded