AR ledger Report

By | November 29, 2023

In Sage300 ERP, Once the transaction is completed on the order entry screen and the day end process is conducted, the transaction is then shown on the AR invoice screen. Moreover, a batch is generated with the GL account. Nevertheless, the item description and comments from the order entry screen do not appear on the AR invoice screen. Consequently, we have created this report to offer comprehensive information on both order entry and AR transactions, encompassing the item description and comments.

New Stuff: – Restricting Order Posting for Zero Unit price or Order Subtotal

In this blog post, we will discuss the AR Ledger Report Utility, which allows users to export detailed data of both order and account receiver transactions.

  • From and To Document Date
  • From and To Customer Code
  • Functional or Customer Currency.

The report data will be generated as an MS-Excel file that is exported, using the user’s specified range of document date, customer code, and currency.

Please refer below screenshot of the user interfaces for the “AR Leger Report Utility”.

Fig1: Utility to export the report

In the screenshot provided above, the user can specify the ‘From’ and ‘To’ Document date, Customer code, and currency. Based on this information, the report will generate the necessary data in Excel

format. The user will enter the desired path for the report in the ‘Select File’ field, which is shown in the screenshot. The user can choose the desired path by clicking on the Browse button.

After entering the excel file path as well as range of Document date, Customer code and currency user will be able to export the data.

Below is the excel-based generated output of the “AR Ledger” report: –

AR Ledger Report - Sage 300

AR Ledger Report – Sage 300

Fig2: Output of report

This report includes following fields from Bank screen and can be modified according to your requirement.

  • Document Number.
  • Document Date.
  • Customer Name.
  • Description.
  • Item comment.
  • Basic Amount.
  • Tax.
  • Total Invoice Amount.
  • TDS as per 26AS.
  • Adjustments.
  • Received Amount.
  • Outstanding Balance.
  • Remarks.

In this way user can easily fetch the required Order Entry and AR transaction data which serves the purpose of this utility.


About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged 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 competence.

Greytrix offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM, Salesforce(listed on Salesforce Appexchange), Dynamics 365 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 services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using Data and web services  to Sage business partners, end users and Sage PSG worldwide.

Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more details on Sage 300 and Sage 300c Services, please contact us at, We will like to hear from you.