Multicurrency Revaluations

(0) Share

Report

Posted on by Community Member

Does anyone know a way round month end revaluations on AR and AP when there are outstanding applied documents Example: we have invoices that have been partially applied and the payment has been fully applied and moved to history in AP and it wont let us run the revaluation. There is a list of about 40 so voiding the payment to run and re entering isnt an option !

Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Alvaro Rodríguez Ochoa 2,395 on at

Like (0)

Report

I'm not sure if it's the same issue, but when we have an invoice on a currency, and a receivable in another, sometimes there's a few cents that don't match, so the invoice appears as it has some outstanding balance, what we do is go into the database tables and on tables (depending) RM30201 (historical) or RM20201 and adjust the difference there, we have never had more tan 1 cent difference (our currency is setup for 4 decimals) and then concile the client and never has an issue.

You could run this script te verify if this is your case:

select aptodcnm AS INVOICE,ORTRXAMT, sum(ORAPTOAM) AS ORAPTOAM,sum(APPTOAMT) AS APPTOAMT,(ORTRXAMT-sum(ORAPTOAM)) AS DIFFERENCE from rm20101 F

INNER JOIN RM20201 A ON (F.DOCNUMBR=A.APTODCNM)

WHERE F.CUSTNMBR ='INT-001'

AND RMDTYPAL=1

GROUP BY A.aptodcnm,ORTRXAMT

having ORTRXAMT-sum(ORAPTOAM)<> 0

ORDER BY A.aptodcnm

Was this reply helpful? Yes No
Alvaro Rodríguez Ochoa 2,395 on at

Like (0)

Report

you should change the f.custnmbr = to you customer id, or delete it to display all transactions with difference

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi thanks - the problem isnt with Receivables (at the moment) its with payables. These are MC transactions where the payment has gone to history and the invoice is in open - it wont let you run the reval with partially applied documents, we have a currency that only had a couple so wasnt so difficult - the other has over 40 payments and invoices so not an option.

Was this reply helpful? Yes No
Suggested answer

MG-16101311-0 26,225 on at

Like (1)

Report

I don't think there's a way around this more than to revalue the actual GL account and book any manual journals needed with the proper reversing dates

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hey Mr Gomez ;-) agreed for the large number I think thats their only option. For the databases where there are just a couple of transactions then we are voiding the payments to unapply then reentering after the valuation.

Was this reply helpful? Yes No