Symptom
After the execution of FIFO Cost Determination run, the system shows the error message: Threshold not maintained for company ABC and material XYZ.
ABC means Company ID
XYZ means Material ID
Environment
SAP Business ByDesign
Reproducing the Issue
-
Go to Inventory Valuation work center.
- Go to Periodic Tasks -> FIFO Cost Determination view.
- Show all FIFO Cost Determination Runs and search for the erroneous Run ID.
In the Messages tab, the system shows the error message: Threshold not maintained for company ABC and material XYZ.
Cause
Threshold values are not maintained in the Business Configuration activity: Threshold Values for FIFO.
The FIFO threshold function is used by the FIFO cost determination run in cases where not all inventory layers were captured by the material cost accumulation run and therefore it was not possible to directly assign a cost to all items. In such situations the FIFO threshold function attempts to assign an alternative cost to the missing items.
Resolution
-
Go to Business Configuration work center.
- Go to Overview view.
- Open activity: Threshold Values for FIFO
You have to set up rules in the following table in a similar fashion:
Seq No. | Company ID | Company Name | Product Category ID | Product Category Description | Material | Upper Threshold | Lower Threshold |
1 | ABC | XYZ | 10.000.000 EUR | 100 EUR |
The mandatory inputs are Company ID, Upper Threshold and Lower Threshold.
4. Click Save and Close after maintaining the necessary rules.
You now have to re-execute the FIFO Cost Determination run with the same selection parameters. You can see the run has been executed successfully without errors.
See Also
2113245 - FIFO Cost Determination - No Valid Cost Accumulation Exists For Material
2690102 - Error Message: No valid cost accumulations exist for 1234567890 with stock quantity XYZ ea
Keywords
FIFO Cost Determination, Threshold Values, BYD. , KBA , SRD-FIN-INV , Inventory , Problem