Search Results for

    Show / Hide Table of Contents

    AXIO - Purchase Orders cleanup history

    The AXIO - Purchase orders cleanup history feature adds the ability to run a batch process that closes Open Purchase orders that have not been fully received, and no further receipts are expected.

    To access this tool, navigate to AXIO > Inquiries and reports > AXIO - Purchase orders clean up history.

    1. Navigate to AXIO > Setup > AXIO parameters > Procurement sourcing.

    2. Toggle Enable open PO cleanup to Yes to enable this feature.

      Purchase orders cleanup

    3. To obtain a list of Purchase orders that are partially received (open status), run the Accounts Payable > Purchase orders > All purchase orders.

      Purchase orders cleanup

    4. Filter the results to display only Purchase orders with a Status of 'Open order'.

      Purchase orders cleanup

      Purchase orders cleanup

    5. Export the resulting report to Excel.

      Purchase orders cleanup

      Purchase orders cleanup

    6. Open the report and make any desired edits (i.e. remove anything that should remain open).

      Purchase orders cleanup

      Important

      It is essential that the first column in the Import file is the Purchase order number. If this is removed or changed, the file will not import properly.

    7. Import the Excel file by navigating to AXIO > Periodic tasks > AXIO - Open purchase order line cleanup.

    8. Click "Browse" on the Upload open orders field and select the Excel file just created.

      Purchase orders cleanup

      Purchase orders cleanup

    9. Review the status of the process in System Administration > Batch Job.

    10. Once the batch job is complete, the user can review results in the Purchase orders clean up history page.

      Purchase orders cleanup

      Purchase orders cleanup

    In This Article
    Back to top Generated by DocFX