Realised Unrealised Report

By | March 28, 2017

Enterprise resource Planning or ERP is a solution for organisations to manage their business efficiently. The main moto of an ERP Software is to collect and organise data from various levels and provide management the clear picture of profit and loss.

New stuff: Generic GL Import Macro for Sage 300 ERP

Let us say, if in a business you issue invoices or makes purchases in foreign currency then it is necessary to keep values in “Home” currency to keep your accounting accurate. With this report, you can found the realised unrealised gain and loss. In accounting, there is a difference between realised and unrealised gain and losses. Realised income and expense refer to profit and loss of completed transactions whereas unrealised is for relevant transactions, which are not completed.

Let’s take an example, suppose you have created an invoice of rupee 100 which has an exchange rate as 5 and while creating payment of 100 rupee the exchange rate is 6  in this case when we convert these amount to home currency its different will be 100 rupee is consider as Realised Unrealised value of this transaction.

In Sage 300 ERP, we have given new user interface to print this report, which look as follows:
Here it has from and to date filter criteria which export the report to excel format.
The report export format is as follows:
The report mainly contains the posted GL Batches, which has the income and loss accounts. The report shows the main receipt or payment and the original document number against which the receipt or payment is applied. In the report you will find different columns like GL Batch, GL Entry NO, AP/AR/BK Batch No, AP/AR/BK Entry No, Account code, Account Description, Original document No(Batch / Entry). Other columns that you will find here are Original Document No, Original Document Date, Original Document Amount Original Document Currency, Original Document Rate, Original Document Value in Functional Currency, Payment / Receipt Document No, Payment / Receipt Document No (Batch / Entry), Payment / Receipt Document Date, Payment / Receipt Document Amount. More columns consists of: Payment / Receipt Document Currency, Payment / Receipt document rate, Revaluation rate(in case of unrealised valuation), Payment / Receipt / Revaluation document value in Functional Currency, Exchange rate diff, Realised forex (Gain) / loss etc.

Revaluation batches are also a part of this report. This report is useful to find the Realised and Unrealised profit and loss of your business.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at We will be glad to assist you.