Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This document outlines the steps to perform to commit Manager Plus Purchase orders to ERP Requisition. The ERP requisitions will report back to Manager Plus what and when it was received.   

There is an existing process in ERP, the "Work Order Interface" for Manager Plus, we based all of the steps for this on what was already in that process, and what was available to us in the Manager Plus API.

Prerequisites

To perform this sync, we will need:

  • Security Access to ERP Item Master
  • Security Access to Manager Plus PO 


CONNECT Configuration

Power User → Config Feature

A user with admin rights / Power User rights will need to enable the feature, It will be under the "Ordering . Requisitions to Purchase Order" node in the tree.

image2020-12-30_13-29-1.png

Settings → User Profiles

For each user that can review these batches, we'll need to grant them security access.

image2020-12-30_13-37-13.png

Power User → Manager Plus Warehouse Map

Manager Plus Inventory Locations may not match ERP locations. to resolve this, there is a mapping screen. Enter the Manager Plus value on the left, and the ERP value on the right and these will be resolved when we import and stage requisitions from Manager Plus and when we send them back.  

image2020-12-31_9-28-49.png


ERP Configuration

Approvers and Buyers

In order to approve requisition records and convert requisition records to purchase orders, we need to configure the ERP user SYSTEM_AAI. 

Normally this is done through the menu Master→Purchasing→Requisition Approver Setup (and Requisition Requestor Setup).  Since SYSTEM_AAI is a special user, it is done through a script.  See Manager Plus PO to ERP Requisitions PO and Receiver

Make sure to configure the approval limit as well.


Creating POs In Manager Plus

Modules → Purchasing → Purchase Orders

We'll log into the Manager Plus web service and create purchase orders. 

image2020-12-31_9-34-16.png

From here, we can look up any purchase orders that we have created. When we want to create a new purchase order we'll click "New".

image2020-12-31_9-35-17.png

We'll create our new purchase order, entering information for the header. The most important thing to add is the parts lines. These are the lines that will be synchronized between the two systems. Enter a line for parts, using the item code. 

image2020-12-31_9-38-17.png

Staging Requisitions in CONNECT

Ordering → Purchase Order Requisition → New Batch

When we are ready to manually create a batch We'll click "New Batch". Clicking here will load a dialog window that will load information about the last batch that we processed. By default, the new batch will begin by picking up records  

image2020-12-31_9-53-22.png

When the batch is created, each part line from the purchase order will be staged.  

image2021-1-10_20-44-0.pngSending Requisitions to ERP


Sending Requisitions to ERP

Clicking the "Send Batch" button will send the purchase orders to ERP Requisition, before this happens, Update from source will be called to get changes from Manager Plus, in case anything has changed since it was staged.

When records are sent, their send date and ERP Requisition ID will be updated.

If a record fails to send for any reason, we can review the reasons on the "Commit Results" message tab.

image2021-1-10_20-49-36.png


Creating and Receiving Purchase Orders in ERP

Purchasing → Common → Requisition → Requisition Processing

In ERP, we will navigate to the requisition screen. From here, we will approve these requests from Manager Plus/Connect and create Purchase Orders.

Searching for "Pending Approval" requisitions should give us all of the orders that we committed.

Select the requisitions and "Approve" them to update their requisition status.

Next, search approved requisitions and click "Convert to Purchase Order" to create purchase orders.

image2021-1-10_20-53-57.png


Purchasing → Common → Purchase Order

We can view our converted requisitions in the purchase order lookup screen. Each approved requisition will be converted into a purchase order, and each part will become a PO line.

image2021-1-10_21-0-0.png

Purchasing → Common → Receive Against PO

When we are ready to receive the inventory, we'll open ERP and Receive it. 

image2021-3-1_8-45-3.png

Receiving POs and Receipts in CONNECT

Ordering → Purchase Order Requisition → View Existing

Retrieve the batch with your purchase orders in it and click "Receive Updates". If the PO line has been received, we'll see new records underneath it in the grid. 

In this example, I only received one of the two lines, we can see that the receiver has been added to the second line. It is ready to ship to Manager Plus.

If a receiver fails to import for any reason, we can review the reasons on the "Commit Results" message tab.   

image2021-3-1_8-49-10.png

Committing Receipts to Manager Plus

Ordering → Purchase Order Requisition → View Existing

When we are ready to send the received inventory to Manager Plus, we'll click "Commit Batch". Each record that succeeds will have a row style resembling dark grey or green when highlighted, there will be dates on the receiver for when the records was sent to Manager Plus.

If a record fails for any reason, we can review the reasons on the "Commit Results" message tab. 

image2021-3-1_8-51-45.png

Modules → Purchasing → Purchase Orders

When we search the PO in Manager Plus, we can now see that it has a status of "Requisitioned in ERP".

image2021-3-1_8-59-4.png

When we click the "Detail" tab of the PO we can see that the parts line has been received, and how many units were received. 

image2021-3-1_8-59-26.png

Scheduling Batches 

Settings → Other → Scheduled Tasks

We'll add records to the schedule list if we want to schedule these batches

  • "PurchaseOrderRequisitionCreate": Create a schedule item of this type to automatically create batches of items.
  • "PurchaseOrderRequisitionSend": Create a schedule item of this type to automatically send them to ERP.
  • "PurchaseOrderRequisitionReceive": Create a schedule item of this type to automatically update them with any purchase orders and receivers created in ERP.
  • "PurchaseOrderRequisitionCommit": Create a schedule item of this type to automatically update manager Plus POs and receive against them.
  • "PurchaseOrderRequisitionAllSteps": Runs all of the above steps in their listed order. Scheduling this one job will run them all. 

image2020-12-30_13-23-59.png



Dev Documentation: Manager Plus PO to ERP Requisitions PO and Receiver


  • No labels