You are currently reviewing an older revision of this page.
Want to stop users from using a an item code in a works order, the budgets are set yearly and I don’t think they can be end dated.
Created a new dummy group with the same group type as 'ALL ROADS' called it 'DUMMY GROUP' with no memberships.using sql assigned existing groups no longer wish to use to the new DUMMY GROUP withinh this financial year. Any section selected on a future order will then not find these numbers as nothing to match against.
Identified current situation, came up with proposal for way forward to allow for budget reallocation
Budgets12AGAA 2012 ALL ROADS CG,DI,GC HM12AMAA 2012 ALL ROADS HT HM12ARAA 2012 ALL ROADS GA HM12AEAA 2012 ALL ROADS FC,KC,LC HM12AQAA 2012 ALL ROADS CM,LC,MC HM
26AGAA 2012 ALL ROADS DI ED26AGAB 2012 ALL ROADS DI ED26AGAC 2012 ALL ROADS DI ED
Budgets12AGAA 2012 DUMMY RD - LINK CG,DI,GC HM12AMAA 2012 DUMMY RD - LINK HT HM12ARAA 2012 DUMMY RD - LINK GA HM12AEAA 2012 ALL ROADS FC,KC,LC,HT,GA,CG,GC scheme type HM12AQAA 2012 ALL ROADS CM,LC,MC,CG,GC HM
Sql wrote to do:
select rse_he_id, rse_unique from road_segswhere rse_unique in ('ALL ROADS','DUMMY GROUP');
select * from budgets where bud_fyr_id = '2012'and bud_icb_item_code||bud_icb_sub_item_code||bud_icb_sub_sub_item_code in ('12AGAA','12AMAA','12ARAA');
update budgetsset bud_rse_he_id = 9264170where bud_fyr_id = '2012'and bud_rse_he_id = 48378and bud_icb_item_code||bud_icb_sub_item_code||bud_icb_sub_sub_item_code in ('12AGAA','12AMAA','12ARAA');
3 rows updated
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!