Symptom
Direct cost or Cost rate not showing in project, and you see below error:
'Cost could not be determined for some or all Materials of task' or 'Cost could not be determined for some or all Services of task'
or
'Planned cost and Cost rate not appearing in the Cost and revenue work center' and you see below error:
'Cannot determine account origin for service ABC in company DEF'
ABC means Service ID.
DEF means Company.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Project Management work center.
- Choose the Projects view.
- Choose Project GHI (GHI means the Project ID).
- Choose the Edit button.
- Choose the Valuate button.
- You get the message: 'Cost could not be determined for some or all Materials of task'
or
- Go to Cost and Revenue work center.
- Choose the Projects view.
- Choose the Project GHI.
- Choose the View Plan Values button.
- You can see here some of the project tasks are in Error status marked in Red color.
- Choose project task and navigate to the Messages tab
- You can see error message: 'Cannot determine account origin for service ABC in company DEF'
or
- Go to Project Management work center.
- Choose the Projects view.
- Choose Project GHI.
- Choose the Edit button.
- Select project plan tab.
- Go to work tab or Materials Tab.
- Here you can see the cost rate is empty.
Cause
The project valuation will be failed for the respective services or materials, if the account determination group is not maintained or if the account is not maintained.
Resolution
A) Follow below steps to view the account determination group maintained for Product category of Service or Material.
- Go to Business Configuration work center.
- Choose the Implementation Projects view.
- Choose Open Activity List button.
- Navigate to Fine Tune tab.
- Search and choose Account Determination Group for Product Categories.
- Choose Open button.
- Choose the respective product category as maintained in the service/Material master data.
- Check the account determination group for services or account determination group for material
B) Follow below steps to maintain the G/L accounts for Account determination group for Services:
- Go to Business Configuration work center.
- Choose the Implementation Projects view.
- Choose Open Activity List button.
- Navigate to Fine Tune tab.
- Search and choose Charts of Accounts, Financial Reporting Structures, Account Determination.
- Choose Open button.
- Choose the Account Determination -> Costs.
- Choose Account Determination Profile.
- Choose the Costs and then choose Service tab and maintain the Account Determination Group for Service which was observed in the step A.
3) Follow below steps to maintain the G/L accounts for Account determination group for Material.
- Go to Business Configuration work center.
- Choose the Implementation Projects view.
- Choose Open Activity List button.
- Navigate to Fine Tune tab.
- Search and choose Charts of Accounts, Financial Reporting Structures, Account Determination.
- Choose Open button.
- Choose the Account Determination -> Inventories.
- Choose Account Determination Profile.
- Choose the Inventories and then choose Inventory tab and maintain the Account Determination Group for Material which was observed in the step A.
- Also in the Gains and Losses tab.
- For respective Account Determination Group for Materials field, under Material Consumption column enter the G/L account for material cost posting.
Keywords
Cost rate is empty, Cost rate is wrong, Cost rate is not available , KBA , AP-PRO , Project Processing , How To