You are currently reviewing an older revision of this page.
Trying to create budget / budgets after new finanical year started.
Should really generate budgets before new financial year starts, if try to do when in the next financial year , doesn't work.
Work around:
Identify the financial years ranges from exor, reference,financial years , fastpath HIG3664
Check dates, and modify sql below to reflect setup required.
egyear 2011 start date 01-APR-2010 31-MAR-2011year 2012 start date 01-APR-2011 31-MAR-2012
If todays date 02-APR-2011 ie in next financial year
Then run the following
If want comments to be the same as last year change code below from '', below to be => a.bud_comment
If want budget increased by 10% amend code below to be
a.bud_value below to be => a.bud_value*1.1
insert into budgets ( bud_sys_flag, bud_agency, bud_rse_he_id, bud_job_code, bud_icb_item_code, bud_icb_sub_item_code, bud_icb_sub_sub_item_code, bud_fyr_id, bud_value, bud_cost_code, bud_comment, bud_committed, bud_actual, bud_id ) select a.bud_sys_flag, a.bud_agency, a.bud_rse_he_id, a.bud_job_code, a.bud_icb_item_code, a.bud_icb_sub_item_code, a.bud_icb_sub_sub_item_code, '2012', a.bud_value, a.bud_cost_code, '', 00,--a.bud_committed, 00,--a.bud_actual, bud_id_seq.nextval from budgets a where a.bud_fyr_id = '2011' and not exists ( select * from budgets where bud_sys_flag = a.bud_sys_flag and bud_agency = a.bud_agency and bud_job_code = a.bud_job_code and bud_icb_item_code = a.bud_icb_item_code and bud_icb_sub_item_code = a.bud_icb_sub_item_code and bud_icb_sub_sub_item_code = a.bud_icb_sub_sub_item_code and bud_fyr_id = '2012' );
Then issuecommit; if all ok or rollback; if not.
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!