renzosing
15th June 2005, 21:01
I'm creating a new Baan session and the user would like to see Total Demand as it is showned in Time Phase Planning. Does anyone have any helpful hints of how this can be calculated, because Time Phase Planning use dals to do the calculation, I've looked at the script for cprrpdll0010, but I'm not seeing what tables to pull this data from and it is a bit confusion to me. Below is some sample code. Thanks

total.demand = total.demand +
cprrpdll0010.planned.demand(cnt) +
cprrpdll0010.forecast.demand(cnt) +
cprrpdll0010.critical.demand(cnt) +
cprrpdll0010.ipl.demand(cnt) +
cprrpdll0010.actual.demand(cnt)

cuiwenyuan
12th June 2012, 10:59
Do you mean the session cprrp0420m000?

I am also working on the total demand on specific Item and Date range. But I am working on ERP LN.

avpatil
12th June 2012, 11:17
Actually it is not that easy, as you have mentioned. The total demand is a calculated value and is not stored in table. For e.g. if forecast is 1000 and Cusotmer demant is 1200 then it is not added, it is the greater of the two. Also, I dont know if there exist forecast consumption in Baan V, if that is the case then previous period forecast is also added to current period forecast. In Baan IV it does used to store the cosnumed forecast in MPS table and I am sure it may be the case with MPS table.

ferenc.magyar
28th May 2019, 17:06
Is there any proposed solution for this?

avpatil
28th May 2019, 17:59
I think one can write a logic if one cannot retrieve the same from any DAL