Planning worksheet calculate regenerative plan with error

(1) Share

Report

Posted on by JUBEL THOMAS JOY

231

Hi All,

Subj: Planning worksheet calculate regenerative plan with error : "The record in table Inventory Profile already exists. Identification fields and values: Line No.='1'

We needed to add an extra filter in the code for the ForecastConsumption() function within the Inventory Profile Offsetting codeunit. To achieve this, we used the OnBeforeForecastConsumption() event, moving all the code from the function into this event and setting the Handler to TRUE to prevent the standard code from executing.
However, we encountered an error that says, 'Inventory Profile already exists with identification values: Line No = 1.'

For testing, we removed all our custom filters and ran the planning process using only the standard code within the event, but the error still persisted.

Kindly suggest.

Categories:

Manufacturing

All responses (1)

Answers (0)

Suggested answer

Khushbu Rajvi. 1,529 on at

Like (1)

Report

Planning worksheet calculate regenerative plan with error

To fix the "Inventory Profile already exists" error, check for existing records with Line No. = 1 before running your planning worksheet.

In your OnBeforeForecastConsumption() event, add logic to ensure you only insert or modify records if they don't already exist. Use debugging tools to trace the issue and confirm that no other customizations are causing conflicts.