Hi <#C29HKGM6J|> Hoping someone can assist with my...
# accounting
j
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?
c
So hopefully I get the scenario.....why not override the FX rate on the new document used to credit? If it matches there should be no gain or loss
j
Thank you @C_Billings. If i am right saying then when a negative payment is applied against the bill credit, the system should post a realised gain or loss between the base currency value using the FX rate on the date the refund was received in the bank and the rate the bill credit was booked using ( i.e. the original deposit rate). However would the bill credit entry and the original deposit vendor bill still remain open when it came to month end open item revaluations? or would they be deemed both closed and so not be revalued at the month end FX rate?
c
I was simply thinking about 2 documents. Gains and Losses are based on the difference in exchange rate. Typically when I ran accounts payable vendors in Canada would pay a refund based on the spot rate of the original transaction. If you simply match the rates of the original document you should incur not change