Customer and Transaction Date Filter in OE Invoice Form

By | July 29, 2020

OE Invoice in Sage 300 Erp, is a confirmation document that is sent to the customers before delivering of the goods or services. Sales Invoice on the other hand can be created once the customer accepts the quote.

Sage 300 ERP (Sage Accpac ERP) provides users to print the OE Invoice document through the OE Invoice Form. But standard OE Invoice form in Sage 300 ERP has provision to filter invoices only on Invoice Number, so sometimes it becomes difficult to find those invoices when user does not have the idea of exact Invoice Number. So based on the requirement of one of our client we have customized the OE Invoice forms screen to sort the report data based on the Customer and Transaction Date. This makes convenient for the users to find the required Invoice by filtering using Customer and Transaction date.

New Stuff:- E-Way Bill Process for GST

We have customized the OE Invoice Form screen by including additional controls of the Customer finder and Transaction Date. By selecting the customer and Transaction Date range user can further filter the OE Invoice transactions posted for particular Customers and Date.

OE Invoice-Customer and date filter in OE Forms
OE Invoice-Customer and date filter in OE Forms

After selecting the From Date, To Date, From Customer and To customer as in the above screenshot and then click on the print button, invoices will be printed only of the selected customers and within the range of transaction date selected.

If user wants to print all the invoices of the particular single customer then this customization will be more helpful since user just need to select the same customer number in from customer and to customer and select the transaction date within which user wants to print Invoice of that customer. And same goes with the Transaction Date filter, if user wants to print all the invoices posted with in particular date range then user just needs to select from date and to date and print the report. Thus using other filters in combination, it is helpful for the users to achieve a desired output in the form of report.

Based on the requirement of the clients any other filters can also be added by customizing the OE Invoice form screens.

About Us:-

Greytrix – a globally recognized and one of the oldest Sage Gold 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,, 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.

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