Prolecto Labs

Prolecto Labs' mission is to drive continuous innovation to solve NetSuite.

Our mission is to drive continuous innovation to solve NetSuite.

Prolecto Accelerator Templates are pre-built to solve tough NetSuite problems. Our consultants tailor them to fit your business - bridging gaps, streaming workflows, and enhancing system capabilities.

Prolecto Currency Revaluation Enhancer

The Currency Revaluation Enhancer provides a detailed breakdown of currency revaluation amounts by Customer and Vendor. This tool is designed for NetSuite environments that utilize account types other than Accounts Receivable and Accounts Payable and would like to see the entities that make up the unrealized gain or loss in a particular period. The tool runs automatically and stores a custom transaction (PRI Currency Revaluation) in a custom record (PRI Currency Control Record) for reviewing and comparison of native revaluations to the custom revaluations.


 
 

Request Accelerator Template ⟶

https://840889.app.netsuite.com/core/media/media.nl?id=7306629&c=840889&h=Q4NxnX2ft7J3J9-NiJuPFpf-Y8PsOLKCtuL9zMKt5oOxam8G&_xt=.svg-Prolecto Currency Revaluation Enhancer


What It Does

The Prolecto Currency Revaluation Enhancer provides a detailed breakdown of currency revaluation amounts by Customer and Vendor. This tool is designed for NetSuite environments that utilize account types other than Accounts Receivable and Accounts Payable and would like to see the entities that make up the unrealized gain or loss in a particular period. The tool runs automatically and stores a custom transaction (PRI Currency Revaluation) in a custom record (PRI Currency Control Record) for reviewing and comparison of native revaluations to the custom revaluations.

Why It Matters

One World customers with multi-currency configurations may be using alternative configurations to drive accounting and bookkeeping. In doing so, additional insight is needed to explain currency revaluations. The tool is offered without transaction or recurring license charges.

Implementation Details

Led by practice: Accounting

Other Data

Build ID 167

Accelerator Versions

Version: 20250404.RC

  • Made the identification of currency revaluation transactions to mirror configurable through a custom SQL statement.
  • Added logic to delete existing mirror records when the source mirror transaction changes.
  • Added logic to source the Account Internal ID from the transaction as a fallback for cases where the default value is empty.
  • Enhanced approach for building mirror records to handle large counts of transaction lines more efficiently.
     

Version: 20240703.RC

  • Added feature for creating mirror custom records that expose data in native currency revaluation transaction sublists that is otherwise inaccessible through saved searches or queries.
  • Delayed when a custom reversal transaction is created until a new native Currency Revaluation exists.
     

Version: 20240521.RC

Added handling for edge case when there is no Payment Event.

Version: 20240418.RC

Updated to support an empty value for the name field in the transaction line.

Version: 20240311.RC

Moved query and entity field mapping to app settings to enable customization based on client needs.

Version: 20240209.RC

  • Updated saved search criteria to prevent accidentally processing unintended transactions.
  • Updated map/reduce script deployments to be undeployed by default to avoid the process from accidentally executing before configuration is complete.
  • Fixed typo in the names of control record sublists.

Version: 20240124.RC

Initial release.

All Accelerator Templates are available exclusively to the Prolecto client community.