SAP Knowledge Base Article - Public

2155939 - GR/IR Clearing: Cannot Find Account Determination Group for Product Category of Fixed Asset

Symptom

The GR/IR clearing run finished with errors. In the Processed with Errors tab of the Log Result you notice the error message 'Cannot find account determination group for product category XYZ' displayed for a purchase order item.
But this product category was set up for fixed asset procurement only. The fixed asset has been generated successfully.
Therefore you are wondering which setting triggers this error message.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. In the Inventory Valuation work center navigate to the Periodic Tasks view and here to GR/IR Clearing.
  2. Press New - GR/IR Clearing run.
  3. Enter all the respective mandatory data and press Start Now to immediately execute the run.
  4. After a few moments a message appears notifying that the run finished with errors.
  5. Press on the Display Log button.
  6. In the Log go to the Processed with Errors tab.
  7. Here the error appears for a fixed asset procurement purchase order item: Cannot find account determination group for product category XYZ.

Cause

The purchase order for the new fixed asset has been created in a currency different to the company currency. As the exchange rate valid on the posting date of the goods receipt is different to the exchange rate valid on the supplier invoice posting date an exchange rate difference posting is necessary.
For legal reasons the exchange rate differences resulting from GR/IR clearing cannot be posted to a fixed asset account but need to be posted to a profit or loss account.

Resolution

In general the product category XYZ needs to be assigned to a default account determination group which is used for inventory postings resulting from exchange rate differences. It is advisable to create a new account determination group and to assign it to the respective ledger accounts as well as to the product category:

 Account determination set-up:

  1. In the Business Configuration work center navigate to the Implementation Projects view and open the Activity List.
  2. Navigate to the Fine-Tune phase and find the Charts of Accounts, Financial Reporting Structures, Account Determination activity and open it (If your system is live open the Business Configuration Overview and find the activity here. Press Change Immediately to open it).
  3. Under Account Determination Groups press on the Edit Account Determination Groups link.
  4. In the left table, open the Inventory - Groups for Materials ledger.
  5. In the right table, enter the Group ID and its description.
  6. Press Save and Close.
  7. Back in the activity go to Account Determination and click the Inventories link.
  8. Open the Differences tab.
  9. Press Add Row.
  10. Select the new account determination group.
  11. Then navigate to the Gain from Exchange Rate Differences and the Loss from Exchange Rate Differences column to maintain a respective expense account.
  12. Press Save and Close.

Now you can assign the account determination group to product category XYZ:

  1. In the Business Configuration work center navigate to the Implementation Projects view and open the Activity List.
  2. Navigate to the Fine-Tune phase and find the Default Account Determination Group for Product Categories activity (If your system is live open the Business Configuration Overview and find the activity here. Press Change Immediately to open it).
  3. Press Add Row and select product category XYZ.
  4. In the Default Account Determination Group for Materials column enter the new account determination group.

After these changes the GR/IR clearing run will be able to correctly clear the price differences resulting from the different exchange rates.

Keywords

exchange rate differences; Goods Receipt and Invoice Receipt Clearing; product category; , KBA , SRD-FIN-INV , Inventory , How To

Product

SAP Business ByDesign all versions