Extract Pending PO & Pending GRN Report from single screen

By | April 26, 2017

In our previous blog of Pending PO & Pending GRN, you can see there are separate UI for both the reports. Here, we have come up with a more convenient UI for user to extract both reports from a single UI.

Pending PO & GRN Report helps us to keep track of all the pending POs & Receipt Entries created against particular vendors.

For this report we have created utility for displaying records in which the PO and GRN is partially completed or not completed in the system. This utility provides us both Pending PO & GRN print option to print in one report only. So that the user can print both the reports in a single utility. As shown in below figure:
This utility will be helpful for users, as it will give them all the records that they need to capture from database for Pending Purchase & Receipt Entries.

Pending PO Report:

In the above example of Pending PO Report, a user can create a purchase order entry with quantity of 6 and create a partial receipt of the same. Hence, in this report, we will get the details of the quantity ordered and the quantity received for the same item with their respective Unit Cost. It also displays Item-Wise Entries with their respective Vendors & PO Numbers.

It will be helpful to the user to keep track of the newly created inventories that are purchased and received for the item. It will also help the user to keep track of the item used in this report in which he will know the quantity that is available for the same item for a particular location.

Pending GRN Report:
In the above example, we are displaying records account set wise with their respective Vendors and Year period in which the receipts are being generated.

This report provides us the pending GRN’s that are partially invoiced with their source amount and functional amount that means the receipt amount and invoice amount respectively.

Suppose if the user used a specific account set (EUROPE) in the Purchase Order entry and created a receipt entry against the same. Then the receipt, which is partially invoiced, will be displayed in the report.

The main purpose to write this blog is to provide users a track of all the Pending PO & GRN Report that gives us the exact quantities used in GRN & PO Entries. This report will be helpful to keep track if the PO or GRN is completed or not in the system.

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, Salesforce.com 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 accpac@greytrix.com. We will be glad to assist you.