Symptom
Error is displayed upon updating cost rate for a service:
"Cannot change cost rate of service XYZ; it was used in valuation after DD.MM.YYYY" when updating the cost rate of the service. (XYZ stands for the service ID, while DD.MM.YYYY stands for the valid from date of the cost rate.)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Cost and Revenue work center.
- Go to the Services view.
- Edit service XYZ.
- Go to the Valuation tab, and click Edit Cost Rate.
- Update the cost rate with valid from date as DD.MM.YYYY.
- Press Enter, error is thrown:
"Cannot change cost rate of service XYZ; it was used in valuation after DD.MM.YYYY".
Cause
The error occurs as there are postings for this service after DD.MM.YYYY.
This can be viewed via the G/L Accounts - Line Items report, as follows:
- Go to the General Ledger work center.
- Go to the Reports view.
- Open the report G/L Accounts - Line Items.
- Input company, set of books, and Journal Entry Type as Internal Service Confirmation.
- Run the report.
- Add field Service (Product) and filter with service XYZ: the postings are displayed.
Resolution
If the cost rate needs to be changed with the validity from DD.MM.YYYY, the postings after the date need to be reversed first to allow this.
Keywords
Service Cost Rate, Valuation, Internal Service Confirmation , KBA , SRD-FIN-COR , Cost & Revenue , How To