Detail Purchase Order Report in Sage 300

By | February 10, 2017

Enterprise Resource planning is a business software that integrates and runs all aspect of your business. ERP system have evolved today to include several new functional application integration like vendor portals, product wise view and functionality, single view of complete supply chain, etc.

New Stuff: Validate Item Segment in Sage 300 ERP

One of the major components in any ERP software is the reporting system. Sometimes in a standard ERP system, the reports generated will not be give you the exact data which you required. This is where customization come into play.

Detail Purchase Order Report is one such customized report developed to keep track of all the purchase orders, their respective PO Receipts & PO Invoices.

This report allows easy sorting data of all the Purchase Order Transactions as per Vendor, Item & PO Number wise. (Refer below screen shot for more clarification)

PO Detail ReportLet’s suppose if a user is creating a Purchase Order Entry (PO) and creating (Partial or Full) Receipt  &  Invoice (Partial or Fully) of the same PO then in this report you can get the respective PO Numbers, with their respective PO receipts & Invoices.

Also this report fulfills the client’s requirement as per delivered Items:
For E.g.: If a User is creating PO with 2 different items e.g.: A & B
If a user makes one partial receipt of A & one of B to complete the PO Quantity, so the report data will come as per Item Number used in PO transaction. As Item Number, their respective PO Number & PO Receipt (if multiple then comma separated). Same applies for the Invoice Entry also.

This will keep the User more focused on the Transactions what he made. The user can get all the created PO entries with their PO Numbers, their respective items, their receipt numbers & Invoice Numbers also this will keep track of the quantity purchased, quantity received & quantity invoiced PO Detail will also help users to maintain proper Inventory Levels for the product used for further transactions in ERP Module & will be more robust for users to create PO entries.

PO Detail Report

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.