2589122 - Unable to Migrate Open Items Payables

SAP Knowledge Base Article - Public

2589122 - Unable to Migrate Open Items Payables

Symptom

You are receiving the following error messages when try to migrate the Open Items Payables:

  • 'Errors detected during import simulation'.
  • 'Import Simulation (x Errors Found, x Warnings Found)'.
  • 'Error detected in source record with key value 'Y, ABCDXY'.
  • 'Company AB not registered in country DEF; define relevant tax number.'.
  • 'Account determination group missing for supplier XYZ and company AB'.

You do not understand why the mentioned messages are being triggered, since you checked and the Tax Number is maintained accordingly and the Master Data of the company AB is complete.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Configuration Work Center.
  2. Select the View Implementation Project.
  3. Open the Activity List.
  4. Show All Activities.
  5. Open the Activity Migrate of Accounting Transaction Data.
  6. Select the respective Migration Unit.
  7. Click Execute Migration button.
  8. Check the message Log, and you can see the error messages:
  • 'Errors detected during import simulation'.
  • 'Import Simulation (x Errors Found, x Warnings Found)'.
  • 'Error detected in source record with key value 'Y, ABCDXY'.
  • 'Company AB not registered in country DEF; define relevant tax number.'.
  • 'Account determination group missing for supplier XYZ and company AB'.

Cause

Most of those error messages, are generic messages, the ones which will help you find the resolution is the one regarding the Account Determination Group and the one about Tax Number.

The Tax Number is maintained, however the message is being displayed due the Valid From date of this Tax Number. If you compare the Valid From date of the Tax Number in the system and the Document dates in the Excel, you can see that the Tax Number Valid From is after the Document Date. Hence, when system check the validity of it, it cannot find a Tax Number valid on that date.

I.e. Tax Number Valid From date is 01/01/2018 and Document Date is 10/11/2017.

  1. Go to Tax Management Work Center.
  2. Select the Company Arrangements view.
  3. Search for the Comlany AB.
  4. Open the Tax Authority.
  5. Select the Company AB.
  6. Go to Tax Numbers view. Here, you can see the Tax Number, and the date of the same.

Resolution

You need to change the Tax Number Valid From date so that the error does not occur.

See Also

Check the Case Document 1989231 - Migration Error: "Account determination group missing for supplier ABC and company XYZ, for the error message regarding Account Determination Group.

Keywords

Migration Tool, Migration of Accounting, Migration of Open Items Payables, Tax Number, Tax Date, Account Determination Group. , KBA , SRD-CC-MIG , Migration , Problem

Product

SAP Business ByDesign all versions