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
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.
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
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.
you should change the f.custnmbr = to you customer id, or delete it to display all transactions with difference
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (