Symptom
After receiving the ordered consumables, you record the delivery in the system using a goods and services receipt document. But when you try to post the goods and services receipt document to accounting, the system gives the following error message: 'Account determination is missing for position type Material Consumption'.
Environment
SAP Business ByDesign
Reproducing the Issue
- In the General Ledger work center, choose the Closing Cockpit view.
- Select the Closing-Relevant Tasks subview.
- You can find there is a task that has the subject Account determination is missing for position type Material Consumption.
- Select the task and you can see the following description: Edit your account determination in chart of accounts XYZ (XYZ represents the chart of account) Chart of Accounts and account determination profile <ZIAS> in configuration for column path Inventories -> Gains and Losses-> Material Consumption and position type Material Consumption.
- Meanwhile, go to the Source Documents subview.
- Select the not posted goods and services receipt document in question.
- Choose View Business Transaction, you can see the same error message: 'Account determination is missing for position type Material Consumption'.
Cause
When you try to post the goods receipt for the ordered consumables to accounting, the posting record for this business transaction would be debiting Material Costs and crediting Unbilled Payables. Posting to which G/L account for material cost is controlled by means of account determination group that allows you to specify any number of G/L accounts for material costs and to use them for different materials. From the product, the system determines the Account Determination Group for Materials, if you have only specified a product category but not the product, the system uses the product category to determine the account determination group.
As you only specify product category in the purchase order, the system first determines the account determination group by the product category, and then tries to find the assigned Material Consumption G/L account, but in fact there is no G/L account maintained, so the system gives the error message: 'Account Determination is Missing for Position Type Material Consumption'.
Resolution
To successfully post the goods and services receipt document to accounting, first of all, you have to identify the Account Determination Group for Materials for the specified product category:
- In the Goods and Services Receipts work center, choose the Receipts and Returns view.
- Open the not posted goods and services receipt document.
- Check the Product Category ID of the ordered material.
- Go to the Product Data work center and choose the Product Categories view.
- You can see the Product Category of the ordered material is ABC (ABC represents the Product Category ID).
- Go to the Business Configuration work center and choose the Activity List view.
- Select the All Activities subview.
- Navigate to the Fine-Tune step.
- Open the "Charts of Accounts, Financial Reporting Structures, Account Determination" activity.
- Choose Edit Account Determination Group.
- Choose Inventory, and you can see the Groups for Materials ID for Product Category ABC, which is DEF (DEF represents the Group ID).
Then you need to maintain a Material Consumption G/L account for the account determination group DEF:
- Still in the Charts of Accounts, Financial Reporting Structures, Account Determination activity, choose Inventories under the Account Determination section.
- In the Gains and Losses tab, choose Add.
- In the Account Determination Group for Materials field, enter DEF.
- In the Material Consumption field, enter the G/L account for material cost posting.
Finally, repost the not posted goods and services receipt document:
- In the General Ledger work center, choose the Closing Cockpit view.
- Select the Source Documents subview.
- Select the not posted goods and services receipt document in question.
- Choose View Business Transaction, and choose Post.
The not posted goods and services receipt document should be posted successfully.
Keywords
Account Determination, Missing, position type, Material Consumption, G/L account , KBA , g/l account missing , material consumption , goods and service receipt , SRD-FIN-ACR , Receivables , How To