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