Order Import Issue – Item with inventory_item_id=XXXXXX is not defined in Item validation Org XXX

 

Discription:

Approved Internal Requisitions are not converted into Internal Sales Orders.

Description:

In Purchasing Responsibility, an Internal Requisition (447493) has been created and approved. “Create Internal Orders” Request is submitted and completed successfully.

In Order Management Responsibility, Order Import” Program is submitted with Order Source as Internal and Order Source Reference as Internal Requisition Number (447493). But the Internal Sales Order is not imported.

Actions Taken:

Step 1: Check the “Order Import Corrections” Form

Check the Order Import Corrections form for any errors.

Responsibility: Order Management Super User

Navigation: Import Orders > Corrections

Checked in “Order Import – Corrections” form for the problematic requisition and found the line with Error Message “Item with inventory_item_id=327809 is not defined in Item validation Org 367

Step 2: Check the Item Validation Organization in System Parameters

The Item Validation Organization in “OM System Parameters ” has been defined as

Step 3: Check the Item Assignments:

Check whether that problematic item has been assigned to that Item Validation Organization or not.

This problematic Item has not been assigned to the Item Validation Organization.

Note:

If the Item Validation Organization is valid and the Item is not assigned to that organization, then assign this Item to the Item Validation Organization Org and then fix the errors in Corrections form.

OR

If the Item Validation Organization is invalid, Change the Item Validation Organization in System Parameter Value.

In our case, assume that the Item Validation Organization is invalid.

Solution:

Step 1: Change the Item Validation Organization as Item Master Organization

Change the Item Validation Organization as “XXX Item Master Organization”.

Step 2: Query the Problematic Requisition in Order Import Corrections Form

Open the Order Import Corrections form for the problematic order based on the “Order Source”.

Order Source = Internal

Order Reference = Click on LOV and query by the Requisition number

Note: While querying by “Requisition number” in the Order Reference field, the Order Reference ID will be populated instead of the Requisition number.

Click “Find”

Corrections form will populate the problematic order line.

Step 3: Remove the “Request ID” value:

In “Main” TAB, remove the “Request ID” value

Step 4: Uncheck “Error Flag”:

Navigate to “Status” TAB

Uncheck the “Error Flag

Step 5: Uncheck Error Flag in Lines:

Click on “Lines” Button and navigate to “Status” TAB

If the “Error Flag” is checked, uncheck.

Step 6: Save

Save and Close the “Lines” form.

Now the Corrections Header form will be displayed.

Step 7: Validate:

Click on “Validate

Will get the Notification like “Order processed successfully“. Click “OK”.

Step 8: Import:

Click on “Import

Will get the Notification like “Order processed successfully“. Click “OK“.

Line will be removed from the “Corrections” form and display the pop-up message. Click OK.

\

Step 9: Query the ISO in Order Organizer form:

Go to “Order Organizer” form and query the Internal Sales Order by Order Source.

Click “Find

Query has retrieved the Internal Sales Order record

Click “Open

Click on “Line Items

Step 10: Query the Requisition in Requisition Summary form to check the ISO No:

Navigate to Purchasing Module and query the Requisition Summary to check the ISO Number

Responsibility: Purchasing Super User

Navigation: Requisition > Requisition Summary

 

Click “Find 

We can find the respective ISO Numbers in the Requisition Lines Summary Form.

Summary

This Post explained what the steps should follow to Create move order through Plannerplanner

Queries?

Do drop a note by writing us at contact@staging.doyensys.com or use the comment section below to ask your questions.

Recent Posts