Symptom
You have executed the Actual Cost Rollup and receive some error messages, such as
-
'Cost center AAA (Manufacturing) has no cost.' (AAA represents the Cost Center ID).
-
'Valuation with cost estimate of resource XYZ failed' (XYZ represents the Resource ID).
- 'Valuation with cost estimate of production lot ZZZ failed' (ZZZ represents the Production Lot ID).
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Inventory Valuation work center.
- Go to the Periodic Tasks view -> Actual Cost Rollup.
- Find and select XXX (XXX represents the Actual Cost Rollup run ID).
- Go to the Execution Details view.
- Find Execution ID YYY.
- Go to the Messages view.
You will find the error messages below:
- 'Cost center AAA (Manufacturing) has no cost.'
- 'Valuation with cost estimate of resource XYZ failed.'
- 'Cost center AAA (Manufacturing) has no cost.'
- 'Valuation with cost estimate of production lot ZZZ failed.'
Cause
For the system to recognize the Costs, they need to be successfully posted.
However, in this case, there is no charge posted to the Cost G/L account of the service, which is related to the resource XYZ in related production lot ZZZ.
To verify this, you can first check the Cost G/L account of the service.
- Go to Cost and Revenue work center.
- Go to Resources.
- Open resource XYZ and go to Services tab.
- Open Service DEF (DEF is the service ID - Name) and go to Valuation, here you get the Account Determination Group.
- Go to Business Configuration work center and Overview view.
- Search for Charts of Accounts, Financial Reporting Structures, Account Determination and open Costs subledger configuration.
- Go to Service, you can get the G/L account of Credit and Debit for Internal Services.
Now you can check the posted charge to the G/L account in the following report:
- Go to the Cost and Revenue work center.
- Go to the Reports view -> List and show all Reports.
- Select the Cost Centers - Line Items report.
- Search using the requested information as company, Set of Books, Accounting Period, Cost Center AAA and G/L account you get.
The report does not display any data in the Charge key figure for this G/L account. Or, the Charge value is negative.
In this case, there are no costs to be considered for the Cost Center to which the resource belongs to. The run cannot finish successfully.
Resolution
The Cost Center can receive postings through a Journal Entry Voucher. For example, you can create a Journal Entry Voucher for the company (something like salary posting) with a debit to the Cost Center and an offset line which will have the credit.
An example of such post would be:
- Go to the General Ledger work center.
- Go to the Journal Entries view -> Journal Entry Vouchers.
- Click New -> Journal Entry Voucher. At least two rows need to be maintained. Example as follows:
- Line A: Production G/L Account ABC: Debit - in combination with Production Cost Center AAA.
- Line B: G/L Account DEF: Credit - in combination with and optional Cost Center BBB.
Observation: The Debit Line should be against the Cost Center for which the charge needs to be posted and the Credit Line should have either a different Account Assignment Type or should belong to a different Cost Center. The Debit Line G/L Account should be of Expense Type.
Note: when you create the manual journal entry voucher to post the expense, the G/L Account ABC must be an account with G/L account type Costs/Expenses, otherwise, you might get error: Account assignment to cost center AAA only allowed for account type Costs/Expenses. G/L Account ABC cannot be used. So you can change the G/L Account type of ABC to Costs/Expenses if it is not.
After you have successfully posted the cost to the relevant Cost Center, create a new Rollup run and you see the error will not occur.
Keywords
Cost center, Valuation cost. No cost. , KBA , production lot has no items , cost center has no cost , actual cost rollup failed , SRD-FIN-INV , Inventory , How To