Option to revalue AR/AP control accounts

Hi Everyone,

I am not sure if this functionality already exists in M3 as I'm relatively new to M3.. However, can someone please let me know if there is an option to revalue AP and AR Control Accounts ( at present these only have invoices and payments and not journals). Although, it is getting revalued through the GLS160 process which connects to an accounting rule event GL20 which is for any unrealised currency gains or losses but this gets posted to a different account and I have to add the two accounts together to get the correct balance.

Is there any way of posting the revaluation to the control accounts directly at the AP/AR control accounts level?

Find more posts tagged with

Accepted answers

All comments

Terje Fageras

Not sure what you mean about Control Accounts but the accounts being subject to revaluation is decided with the AT06-parameter in CRS630/E (left second bottom parameter in Cloud Edition). If combined with a AR-ledger account (AT03) or AP-ledger account (AT11) it is considered AR or AP and is subjet to a specific accounting rule and thus a specific revaluation account different from your AR/AP ledger account.

Any other accounts set to revaluation account (AT06) will book the revaluation directly on to the same GL-account as set as AT06.

harriet-vaz

Thanks Terje. My question relates exactly to the point that the revaluation account is different from the AR/AP ledger account. To get the correct balance at Month end rate , I have to add the two accounts together. Is there any way the revaluation can hit the Actual AR/AP account rather than it having to go to a seperate account?

Terje Fageras

No I do not think that is possible.

The fact that the account that is subject to revaluation is a AR/AP sub-ledger account triggers the GL21/GL22 accounting events and those events have separate accounting types for adjustment of balance account. Further, as the GL21/GL22 accounting event is considered a GL-transaction it is not possible to book directly to a AR/AP subledger account. Therefore, AR/AP adjustments must be held on separate accounts. I believe this is quite normal in other ERP systems as well.

harriet-vaz

How can I show the Correct Aging in the converted currency as The Aging can only be run for the AP Subledger account and it doesn't take into account the separate account for revaluation. I guess some ERP systems have the functionality to book the revaluation directly to the subledger account.

Copyright © 2025 Infor. All rights reserved.