Dynamics Community Forum Thread Details

Kanban Estimation

Hi everyone,

I'm working on production reports, for time & material, estimated & realized costs. For the production orders it was easy, simply getting the data from ProdTable and ProdCalcTrans table. But now with Kanban estimated time and realized time i'm facing a big issue.

Kanban are using temporary tables, and the data in this screen (Kanban Schedule Board) is filled from the .. temp table :

Under the Scheduled Kanban we can see 19:12:36/22:27:36 and these are the estimated duration. The form datasource is empty, and it's using methods to refresh.

I checked KanbanJobSchedule table, but it only gives ExpectedDateTime. And in the KanbanJob table we get :

ActualEndDateTime (datetime where kanban ended),
ActualPreparedDateTime (datetime where kanban was "created" or "inserted"),
ActualStartDateTime (datetime where Kanban is started, usually equals to ActualPreparedDateTime)
ExpectedDateTime (with the same value as in the KanbanJobSchedule table)

So none of this values are useful as we don't have an "ExpectedStartDateTime" field or something like that.

I need a hint for this, anything, on how to get the estimated start time, or even where i can get the kanban duration, so I can substract it from the ExpectedDateTime and make my cost calculation.

Beside this, I also need the scheduled start time to print in which Shift it started (from the workcell Calendar) on the report.

Thank you

Quick Links