Skip to content

AP exchange Revaluation with final impact

Reading Time: 3 minutes

What is Revaluation?

Revaluation is adjustment of the value of a currency in relation to other currencies.

AP revaluation process is used to change the exchange rates used in foreign currency transactions for specific year and period.

With the sage 300 ERP we can evaluate multicurrency transactions at fresh exchange rate so that we can determine current value on specific date.

 

Let’s find out how to do final revaluation in Sage 300 ERP:

Navigate to, Accounts Payable à A/P Periodic Processing à Revaluation.

A/P Revaluation

Above screen represents details to be filled for revaluating currencies at new exchange rate.

For doing final revaluation we need to make sure that Provisional Revaluation checkbox is unchecked.

In the currency column in above screenshot we need to enter currency code which will be revaluated with fresh exchange rate.

Then we have to decide revaluation date up to which we have to revaluate transactions with new rate.

In Rate Type column, select an appropriate rate type from dropdown list.

In the exchange rate column, specify new exchange rate with which currencies will be revaluated.

In optional field column we need to set values for required optional field if any to proceed ahead for revaluation.

After clicking on Process button, system will revaluate all open documents with new exchange rate mentioned up to mentioned date.

 

After Final revaluation we have to see final impact of revaluation process.

On successful revaluation process, GL batch is created from AP sub-ledger with all entries which revaluate all open documents with new exchange rate.

To see final impact of AP revaluation process i.e. GL batch created in system follow below steps:

Navigate to, General Ledger à G/L Transactions à Batch List.

G/L Batch List

Select Batch and click on Open button to see the entry details. Below screen displays all the entries in batch with details such as customers details, account details which got debited/credited with the debit credit details.

Refer below screenshots for reference.

G/L Journal Entry

 

Sage 300 screen demo

After verifying entries in batch, we can post the same by setting batch ‘Ready to Post’, and clicking POST button. On successful batch posting we have to see final effect of all AP transactions.

 

To see effect of AP revaluation, navigate to,

General Ledger à G/L Reports à Posting Journals

G/L Posting Journals

 

In G/L Posting Journals screen, select journal as “Posting Journal”.

Enter Posting sequence number of GL batch in “From Posting Sequence” and “To Posting Sequence” fields.

Click on Print button.

As we can see in below screen shot, system has revaluated AP documents with new exchange rate and passed amount in exchange gain (Loss) Account. Similarly, we can find all the revaluated entry details in this report.

G/L Posting Example

 

 

 

 

Related Post

Contact Us

Fill in the details below and we would be glad to help you.