Help on circular reference
During my training, I had to build the Inventory ordering module for the supply chain model (level 2). After building it following the instruction, I'd like to test new formulas to determine the Suggested Order Amount for the Month.
I'd liked it to be equal to the Forecast demand + Safety stock target - beginning Inventory
However, when I type this formula, an error window shows a circular reference.
I really can't figure out where the problem comes from since none of the line items considered refer to themselves :
Beginning Inventory = IF 'SYS01 Time Settings By Week'.First Week of Timescale? THEN 'DAT01 Beginning Inventory'.Beginning Inventory ELSE PREVIOUS(Ending Inventory)
Forecast Demand = 'DEM03 Demand Forecast'.Final Forecast
Safety Stock Target = HALFYEARVALUE('DAT04 Distribution Center Parameters'.Weekly Safety Stock)
The only thing that could be blocking is the fact that the beginning inventory is determined according to the ending inventory itself determined by the Suggested Order Amount for the Month. However the reference to the ending inventory is supposed to be delay regarding time and therefore avoid any circular reference.
I hope I was clear and that someone can answer my questions. If there is a need to add any other elements to answer, please let me know.
Thanks in advance !