Claims Report to Track Inventory and Accounting

By | May 30, 2023

In Sage 300 ERP, we have provision to know the details of items that are purchased, shipped and remaining in the inventory with the help of various reports. This helps the User to keep a track of their inventory and accounting. But in the case when User needs to claim benefits for the schemes provided by the supplier or for the items that are not consumed, a single report is necessary that provides the User with the complete cycle of the product right from purchase to sales. We have thus developed a report that shows the complete transaction cycle of the product.

New Stuff:- Failed to retrieve data from database. Error: Database Vendor Code 208

In this blog, we are introducing the Claims Report, which allows users to export data for sales and purchase transaction of an item in Excel format. The user interface of the utility to export “Claims Report” is as displayed below:

Utility to export Claims Report
Fig1: Utility to export Claims Report

User can use this utility to export the details of Sales Invoice using the below Filter criteria:

  • Item Code
  • Location
  • Sales Invoice Date

After entering the excel file path and selecting the filter range, user will be able to export the data at desired path.
Below is the excel-based generated output of the “Claims Report”: –

Claims Report Excel Output file
Fig2: Claims Report Excel Output file

As we can see in the above output file all the details of sales transactions are seen in single line. Here output will be generated only for those items that have OE Invoice transactions against them.

This report includes following fields from OE Invoice, OE Credit/Debit Note screen, PO Invoice screen, IC Receipt and IC Shipment screen and can be modified according to your requirement.

  • Item Code
  • Item Name
  • Manufacturer Name
  • Expiry
  • Invoice Number
  • Invoice Date
  • Customer PO Number
  • Quantity Sold
  • Unit Cost
  • Unit Value
  • Discount%
  • Discount Amount
  • Gross Value
  • GST%
  • GST Amount
  • Net Invoice Value
  • Customer code
  • Customer Name
  • Customer Item Code
  • Credit/Debit Note Number
  • Credit/Debit Note Date
  • Credit/Debit Note Type
  • Quantity Returned
  • Unit Cost
  • Unit Value
  • Vendor Code
  • Vendor Name
  • Remit To Location Name
  • Purchase Invoice Number
  • Purchase Invoice Date
  • Purchase Quantity
  • Purchase Rate(Before Discount)
  • Purchase Value
  • Purchase Rate(After Discount)
  • Purchase Gross Value
  • IC Receipt/Shipment Number
  • Quantity Adjusted
  • Unit cost

Thus this report helps User to get the complete transaction for a particular item, 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.