Hi,
Could You advice how to solve below BI issue, please?
1. We key in currency rate once a month. In August 2021 instead EUR-DKK= 7,4379 somebody keyed in 74379 by mistake.
2. As we use System date as pricing method, customer orders keyed before such mistake in EUR had right calculation, but unfortunately after invoice creation they inherited wrong currency rate – so in EUR everything looked ok but in DKK we had incredible amounts.
3. All of problematic invoices were credited in 2021. Unfortunately by mistake one of the invoice date was keyed in in AUGUST 2022 instead AUGUST 2022, so again this year we had a wrong invoice – this time credit invoice
4. As we did not find a functionality allowing to correct already Printed Credit invoice, our finance dep used instant invoice to correct the figures in IFS. This however does not have an impact to our Profitability BI statistics- as they include transactions generated through customer orders. So now in BI we have incredible amounts in “-“ because of that wrong credit invoice.
We discussed that with our IT person taking care of BI statistics, however he couldn’t exclude problematic credit invoice from BI, as he mentioned that data come from IFS. Is there any way to exclude this credit invoice that it does not appear in BI statistics?
Best regards,
Bernadeta