Symptom
When you try to migrate Open Purchase Orders, system throws one of 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
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Configuration Work Center.
- Navigate to the Overview View.
- Search for 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, then the mentioned error would occur.
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 the Product Data work center.
b. Select the 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
Migiration, Purchase Order, Service Call Failed, Quantity in Migrated Reference Missing, Quantity Missing, Product not Valid, Tax Calculated, Country, Company, Registered, Jurisdiction Code Missing, Address, Supplier, Default State, Price Date an Time Missing, Document not Submitted for Approval, Inconsistencies Exist, Order not Possible, Entries Missing or Inconsistent. , KBA , AP-PRP , Purchase Request Processing , How To