2451534 - How to Create a Fixed Asset From a Supplier Invoice With Multiple Items Assigned to the Same Individual Material

SAP Knowledge Base Article - Public

2451534 - How to Create a Fixed Asset From a Supplier Invoice With Multiple Items Assigned to the Same Individual Material

Symptom

You are trying to create a Fixed Asset from a Supplier invoice with multiple items. They are all assigned to the same Individual Material.
Scenario 1:
If the used product category is not assigned to a default account determination group (Fine Tuning: Default Account Determination Group for Product Categories) an error message appears:
Cannot find account determination group for product category 101.
Scenario 2:
If the used product category is assigned to a default account determination group the supplier invoice can be posted. However, not all invoice items have been considered for the generation of the fixed asset net value.

Reproducing the Issue

Scenario 1: Fixed Asset Product Category is not assigned to a Default Account Determination group for Materials:

  1. In the Supplier Invoicing workcenter navigate to the Invoices and Credit Memos view.
  2. In the Common Task view, select New Invoice Without Purchase Order.
  3. Maintain all mandatory data and then navigate to the Items tab via View All.
  4. Enter the first item, assign a fixed asset product category and a net value within or above the Low Value Asset range.
  5. In the Cost Distribution tab, and here, in the Account Assignment Type field select IMAT - Individual Material.
  6. Enter a new or existing individual material.
  7. Now add further invoice items. They are automatically assigned to the same product category and individual material. Their net amount, however, is below the Low Value Asset range.
  8. Press Post: An error message appears: Cannot find account determination group for product category 101.

You expect that all item values are used to generate the resulting fixed asset net value. Instead, the items with amounts below the Low Value Asset range are considered to be posted as general expenses and therefore require the default account determination group assigned to the used product category.

Scenario 2: Fixed Asset Product Category is assigned to a Default Account Determination group for Materials:
In this case the Supplier invoice can be posted but not all invoice items have been considered for the Fixed Asset net value generation:

Example:

Low Value range as per Capitalization Threshold for Fixed Assets Fine Tune activity: Minimum Amount: 150,00 LC; Maximum Amount 499,00 LC.
Supplier Invoice item 1: Net Amount: 1000,00 LC
Supplier Invoice item 2: Net Amount: 50,00 LC
Supplier Invoice Item 3: Net Amount: 40,00 LC
You expect a Fixed Asset Net Value of 1090,00 LC. Instead, the net value of the Fixed asset is 1000,00 LC:

  1. In the Fixed Assets workcenter navigate to the Fixed Assets view.
  2. Select the Fixed Asset and press Edit - Values.
  3. Navigate to the Journal sub-tab.
  4. Here you notice that the Acqusition posting only considered the value of supplier invoice item 1.
  5. Press on the Journal Entry ID to open it.
  6. In the Journal entry you notice that the amounts below the low value asset range have been posted to an expense account instead of the Fixed Asset account.

Cause

When creating a fixed asset from a supplier invoice it depends if the supplier invoice has been created with or without a purchase order.

In the above case you created the fixed asset from a supplier invoice without purchase order.

Resolution

If you create a Fixed Asset from a Supplier Invoice WITHOUT a Purchase order the LAST item of the invoice needs to be within or above the Low Value Asset range. In this case all items will be considered for the Fixed Asset acquisition posting.

Example:
Supplier Invoice Item 1: 50,00 LC
Supplier Invoice Item 2: 40,00 LC
Supplier Invoice Item 3: 1000,00 LC
Resulting Fixed Asset net value: 1090,00 LC.

If you create a Fixed Asset from a Supplier Invoice WITH a Purchase order the FIRST item of the purchase order/ invoice needs to be within or above the Low Value Asset range. In this case all items will be considered for the Fixed Asset acquisition posting.

Example:
Supplier Invoice item 1: Net Amount: 1000,00 LC
Supplier Invoice item 2: Net Amount: 50,00 LC
Supplier Invoice Item 3: Net Amount: 40,00 LC
Resulting Fixed Asset net value: 1090,00 LC.

Keywords

KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions