How to export approved Purchase Order and automatically Upload GRN


This function allows users to export Approved Purchased Order Information from the EMP and Import it to Upload GRN without any modifications, this function is beneficial for large volume usage.

IMPORTANT TO HAVE THIS FUNCTION TO WORK PLEASE ENABLE : PO has to be approved before converting to GRN under  Menu Path:  Control Panel > System Admin > EMP Configuration > Procurement

Then proceed to the Purchase Order Detail Listing , Menu PathProcurement > Report > Report > Purchase Order Detailed Listing

The PO Status has to be OUTSTANDING and Approval Status APPROVED.

Once generated the listing then click on the PO you want to convert to GRN  and click "Export"


NOTE : If the tick option does not show up, check if their is outstanding Quantity and PO is approved

Once the file has been exported, it has all the compulsory keys to Create a GRN, you can proceed, Menu Path:  Inventory > Others > Upload GRN

You may add any additional fileds if need be to the GRN file, please do not remove any of the exisitng information, especially

PO_ITEM_PKID

Once you upload the file, you may Regenerate the Listing and you can find the GRN number linked. 


Private & Confidential