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 try to create a Fixed Asset from a Supplier invoice with multiple items, 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 XYZ' (XYZ represents the Product Category ID).
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 Acquisition value.

Environment

SAP Business ByDesign

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 work center navigate to the Invoices and Credit Memos view.
  2. Either create a New Invoice Without Purchase Order from the Common Tasks view or create an invoice from a Purchase order in the Invoice Entries view.
  3. Press View All and maintain all mandatory data in the General tab, then navigate to the ltems tab.
  4. Enter the first item, assign the fixed asset product category XYZ and a net value below the Low Value Asset Capitalization threshold.
  5. Go to the Cost Distribution sub-tab.
  6. In the Account Assignment Type field select IMAT - Individual Material.
  7. Enter a new or existing individual material.
  8. (Also maintain a cost center in the Cost Center field).
  9. Now add further invoice items. They are automatically assigned to the same product category, individual material and cost center. Their net amount is within/ above the Low Value Asset Capitalization threshold.
  10. Press Post: An error message appears: 'Cannot find account determination group for product category XYZ'.

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 are considered for the Fixed Asset Acquisition cost 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 (LC stands for Local Currency).
Supplier Invoice item 1: Net Amount: 40,00 LC
Supplier Invoice item 2: Net Amount: 50,00 LC
Supplier Invoice Item 3: Net Amount: 1000,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 work center 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 Acquisition posting only considered the value of supplier invoice item 3.
  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 multiple Supplier Invoice Items it depends on the Item order to decide which items are to be considered for the Fixed Asset Acquisition posting.

Resolution

The FIRST item net value of the supplier invoice needs to be within or above the Low Value Asset Capitalization range. Only then 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

Fixed Asset Acquisition, Multiple Supplier Invoice Items for one Individual Material, product category is not assigned to a default account determination group , KBA , fixed asset acquisition , multiple items one individual material , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions