Our finance folks have realised that in february a couple of invoices were posted with incorrect exchange rate .They were payed and posted but in the books they look bad.
Of course we need to clean them up .
I understand that there is a batch job for adjusting the exchange rates for these items, so I wanted to use that .Before trying to do this we had to unapply entries since they wouldn’t show up for the batch.
However when I try to run this job , I see some strange results (runnign in test mode ):
We want to clear Vendor items that have got booking date of feb 11. so I set 01.01 for staring date and feb. 11. for ending date and posting date also jan.30 This brings up nothing ! (even if the starting date is empty) (what date is it looking at then ?)
So I started to play with the starting date and the end date and increased the end date . this case it picks up the invoices even before the ones I need. But the exchange rate can be used is only the one from the posting date .
- How do i narrow down the window of adjustment to the documents I need ? Because one set of documents can have one exhange rate.
- Do I have to look for each combination of exhange rate to run the batch for ? Sound a bit cumbersome.
Hope this makes sense , does it ?
thanks in advance,