Symptom
When you try to migrate Open Purchase Orders, system throws below error message:
Quantity in migrated reference missing
Quantity missing
Product XYZ not valid
Tax calculated for country ABC in which company XYZ (Company Name) is not registered
Jurisdiction code missing in address of Supplier XYZ (Supplier Name); default state ABC
Price date and time missing
Document not submitted for approval; inconsistencies exist
Order not possible; entries missing or inconsistent
Reproducing the Issue
- Open the activity Migration of Purchase orders.
- Select Migrate purchase orders using the migration tool link
- Execute the migration of upload file for Open Purchase Order
Resolution
1. Error Message: Quantity in migrated reference missing
The cause for this error message is Delivered Quantity (Column 68) is maintained as zero (0).
It is not possible to migrate the Purchase Order with Zero Delivered Quantity.
2. Error Message: Quantity missing
The cause for this issue is that you have maintained zero (0) for Quantity field (Column 10)
It is not possible to migrate the Purchase Order with Zero Quantity.
3. Error Message: Product XYZ not valid
The cause for the issue is that the Products are not activated for Purchasing in Product Master Data. To verify,
a. Go to Product Data work center.
b. Select Materials view.
c. Highlight one of the affected Material.
d. Select Edit button and you can able to find that the Purchasing is not activated for the Material.
To resolve this, you need to activate the Material for Purchasing. This can be performed individually in each material or selected the affected Materials and select Mass Change button. Here, you can activate the Purchasing for those Materials.
4. Error Message: Tax calculated for country XYZ in which company ABC (Company Name) is not registered
The cause for the issue is, the Tax was calculated successfully but the country where the tax is due is a country where company is not registered.
Possible Solution:
a. Change the tax country to a country where the company is registered.
or
b. Add a Company Tax Arrangement for the Company for this country. This can be performed as follows,
a. Go to the Tax Management work center.
b. Go to the Tax Authorities view.
c. Select New -> Tax Authority and maintain all necessary information.
d. Go to the Company Tax Arrangements tab.
e. Select the Add Row button and maintain Company, Valid From/To.
f. Save the transaction.
5. Error Message Jurisdiction code missing in address of Supplier XYZ (Supplier name); default state ABC
The cause for this issue is that the Tax Jurisdiction Code is not maintained in the address of the Supplier XYZ.
To resolve this,
a. Go to Supplier base work center.
b. Select Suppliers view.
c. Select the Supplier XYZ and select Edit button.
d. Go to Communication tab.
e. Maintain the Tax Jurisdiction Code for the Address
f. Save the changes.
Please correct the data in the migration template as per above guidelines and try to migrate again then the below error messages will also vanish.
6. Price date and time missing
The cause for the issue is that you have maintained price as 0 (Zero) for some of the line items in the Purchase Order.
Please correct the price to valid numeric and try migration again.
Document not submitted for approval; inconsistencies exist
Order not possible; entries missing or inconsistent
Service call failed. Report an case
7. You can also check whether the Supplier ID entered in the Migration template exist in the system.
8. The issue may also come, if you used the Supplier Name instead of Supplier ID. Always use the Supplier ID in the Migration template as this field is dedicated for Supplier ID.
9. Ensure that the information in the column Quantity UoM, Goods and Services Receipt Expected and Country are complete.
The points 7, 8 and 9 may lead the Service Call Failed error message, so You need to correct this data as well.
Keywords
KBA , AP-PRP , Purchase Request Processing , How To