AP Report Export Utility

By | March 31, 2023

Invoices and payments are one of the most important documents in the AP module in Sage 300 ERP. We have many reports in Sage 300 which provide us with details of the purchase Invoice Transactions and have many aspects covered. But this information is extracted according to Invoices which have line items. There are no amenities in Sage 300 ERP to extract the Invoices and payments data in Excel format at once where there can be many invoices only with their header details fetched. We have developed such an Export utility which will display the output in excel and will show details related to multiple Invoices and payments together.

New Stuff :- Pending Purchase Order Report

Objectives:

  1. To list invoices Details just by selecting From invoice and To invoice date and From vendor and To vendor filters.
  2. To list payment details made against the invoices.
  3. To list vital information about invoices and payments such as Vendor ID, Vendor Name, Document No, Document Type, Document Date, Document Nominal Code, Document Reference, Document Net Total, Document Gross Total, Payment Number, Payment Date, Payment Nominal Code, Payment Reference, Payment Amount, Currency, Document Applied to.

In this blog, we are going to introduce the AP Report Export Utility where the user can use this utility to export the required data of AP Invoices and Payments. Invoice date and Vendor number will be used in the Filter criteria.

  • From Invoice Date and To Invoice Date and From Vendor Number and To Vendor Number.
  • The report data will be exported as an MS-Excel exported file based on the specified Range of Invoice Dates and Vendor Number. This data will be exported at desired path as selected in the Browse dialog box.

User Interface for AP Report Export Utility:

UI for AP Report Export Utility in Sage 300 ERP
Fig1:UI for AP Report Export Utility

After entering the excel file path and range of Invoice Dates and vendor number, user will be able to export the data at desired path.

Below is the excel-based generated output of the “AP Report Export” : –

AP Report Export – Output File In Sage 300 ERP
Fig2:AP Report Export – Output File

This report includes following fields from AP Invoice screen, AP Payment, AP Account set and AP vendor screen and can be modified according to your requirement.

  • Vendor ID
  • Vendor Name
  • Document No
  • Document Type
  • Document Date
  • Document Nominal Code
  • Document Reference
  • Document Net Total
  • Document Gross Total
  • Payment Number
  • Payment Date
  • Payment Nominal Code
  • Payment Reference
  • Payment Amount
  • Currency
  • Document Applied to

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 accpac@greytrix.com, We will like to hear from you.