Hi #C29HKGM6J Hoping someone can assist with my scenario
We previously paid a vendor deposit in a foreign currency where AP had entered one of their vendor bills but the vendor deposit function was not used, instead the line item was just debited to a balance sheet deposit account. The same bill had other line items also, some went to P&L and some went to other bal sheet accounts.
Upon receiving a bill credit from the vendor 9 months later to refund us the same exact foreign currency amount - How can we enter this such that the realised gain/loss resulting from the movement in the FX rates between the two dates hits the P&L?
I am aware that if these were the only two transactions in the balance sheet GL account that the system would mpost a Matching base currency adjustment at the next month end and clear this realised gain/loss to P&L but in our case the bal Sheet GL account has other things in it and so will never be nil in foreign currency obver a month end
Someone has suggested we could do something via SuiteGL (I am not familiar with this function at all) to match the original depsoit debit with the deposit credit entry and then book the difference in base currency to the P&L and the system would then no longer see these two transactions as open foreign currency items. Could this work or does anyone have any other suggestions?