MRP Import / Export and Report

The MRP system is a powerful tool for inventory planners, production schedulers and forecasting.  This article describes how to load a script that will produce an export file containing all of the MRP Action Items (Order, Defer, etc.) for a given warehouse.

While originally intended to drive the Auto-Purchase Order function in AcctVantage, the tool can be used effectively to plan production of Product Assembly items.

The same script can be used for importing a change to the suggested Action.

For a thorough review of the MRP system, please refer to the MRP Review article.

Installing the MRP Export/Import Script

In order to perform the following Export/Import functions, you must first install the attached script.

Download this file: MRP Export/Import Script

To Install:

- Log in to AcctVantage with the username "Administrator"

- Go to Administration > Scripts

- Use the Action Menu to Load the installer file

Installing the MRP Export/Import Script

Export MRP Action Items

Once the script has been installed...

  • Go to Warehouse Management (Inventory) > Products
  • Find and highlight the Products that you wish to evaluate for demand.
  • Use the Action Menu to Select "MRP Export & Import"
  • At the prompt, select Export.
  • Enter a file name to save as
  • Select the Warehouse to evaluate

Open the Export File

After the export has processed, the file may be opened using any text editor or spreadsheet application.  Generally speaking, you will use the application's File > Open command.  For example, in the image below we have opened the file using MS Excel.

Export File Values

The export file contains suggested "Action Items" for Products that have forecasted demand.  If a Product was selected in the list for export, but does not have any forecasted ddemand, that Product will not appear in the export file.

Default PO Cost

This is a Unit Cost, not the total cost of the demand.

Suggested PO Action

  • Expedite: A material requirement needs to be met within the Rush Lead Time and there are no open Purchase Orders for this item.
  • Order: A material requirement needs to be met within the normal Lead Time and there are no open Purchase Orders for this item.
  • Increase: A material requirement needs to be met within the normal Lead Time and there is already an open Purchase Orders for this item. More units need to be added to an existing Purchase Order.
  • Defer: There are already one or more open Purchase Orders that are not needed -- receiving those items would result in excess inventory.

Suggested Qty

This is the demand in excess of what is currently available.  In other words, what do you need to buy or produce to meet the forecasted demand for the given time period.

Needed for Period Ending

This is a Friday date.  The Suggested Qty represents the demand for product in the week ending on this date.

MRP Action Status

There are only two (2) possible values in this column: Pending or <null>.  A Pending Action means that the system will include the Action on the next Auto-PO process.

MRP Action ID

This is a system assigned number that should not be changed.

Importing Updates

After reviewing the export file, you can update the MRP ACTION STATUS column to manage the Auto-PO process.  Clearing the cell for a given Product would remove that Action from the queue; updating the cell with "Pending" would add the Action to the queue.

To Import, save the file as .TXT (tab-delimited).  

  • Go to Warehouse Management (Inventory) > Products
  • Find and highlight the Products that you wish to evaluate for demand.
  • Use the Action Menu to Select "MRP Export & Import"
  • At the prompt, select Import.
  • At the prompt, select the .txt file