Skip to Content
0
Former Member
Feb 23, 2011 at 08:36 AM

data comming twice in 2lis_13_vditm

47 Views

Dear Friends,

We are using datasource 2LIS_13_VDITM for Billing data.

Its working fine.

Today i checked that sales figure is not matching with R/3 Sales means its not reconciling.

So after Some analysis i came to know that there are some invoices which came twice in the BI system.

Example:

Invoice # 10000001 created on 31.01.2011

So BI system extract this information

than user changed the date of invoice from 31.01.2011 to 01.02.2011.

Now

Invoice # 10000001 created on 01.02.2011

So BI system extract this information again with new record.

now we have two records

Invoice # 10000001 with two date

31.01.2011

01.02.2011

and obvious thing this is not right . Now we have doble figure.

Can anyone tell me how to aviod this duplication.

Regards

Naeem