First of all, of course, it wasn't balance, so I need to work out the variance. By digging enough, I realized that funding moving was booked into error accounts. At first glance, several payments in a different date should be withdrawn from a minor CAD account, but the entries showing that they were moved out from a major USD account in error. That means the adjusting entry needs to consider the exchange rate variance! That could be a very complicated re class booking for me. What a ****!
When I discussed the adjusting entry with my mentor, Mr. Smith, he suddenly realized something, and we went into the lines to check the original error bookings. Lucky enough, whoever booked the error entry, the currency that she applied was CAD! Even the funding was from a USD account, but since she booked them under CAD, that means aligning with SAP local currency, the currency exchange rate issue was avoided. Per my mentor, our SAP is set up in CAD as document currency, so whenever there is USD booking entry, it will automatically transfer the USD amount into CAD amount and show two different amounts for the same line item. That means if any amount booking as CAD, the system just showing the same amount, will not auto transferring.
Thanks so much for the brainstorming, we resolved the error by just one re class entry in CAD.
