OraFAQ Forum: Forms » set Financial Year

Home » Developer & Programmer » Forms » set Financial Year (Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

set Financial Year [message #626326]

Sun, 26 October 2014 01:45

Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan

Member

i have made Accounting Program in Oracle Forms 6i
Software is complete now but i want to ask
How can i set Financial Year ????
Start Date to Year End Date ?

Report message to a moderator

Re: set Financial Year [message #626332 is a reply to message #626326]

Sun, 26 October 2014 08:40

shahzad-ul-hasan
Messages: 615
Registered: August 2002

Senior Member

please see the attached file.
/forum/fa/12244/0/

When Button pressed Coding.

:GLOBAL.UNIT_YEAR_CODE := :UNIT_YEAR_CODE;

select FOR_UNIT,TO_CHAR(START_DATE,'DD-MM-RRRR'),TO_CHAR(END_DATE,'DD-MM-RRRR'), STATUS into 
			:global.for_unit,:global.start_date,:global.end_date,:GLOBAL.STATUS
from finance.accounts_calendar
where UNIT_YEAR_CODE = :GLOBAL.UNIT_YEAR_CODE;
:unit := :GLOBAL.FOR_UNIT;
SHOW_VIEW('CANVAS2');
HIDE_VIEW('CANVAS16');
   SET_VIEW_PROPERTY('CANVAS16', visible, property_false);
   GO_ITEM('CONTROL.a');

Modify that code with your one.

Attachment: 13.JPG
(Size: 22.22KB, Downloaded 1394 times)

Report message to a moderator

Re: set Financial Year [message #626336 is a reply to message #626332]

Sun, 26 October 2014 09:36

Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan

Member

thanks for your reply.

please describe little more about code and table for this ?

Report message to a moderator

Re: set Financial Year [message #626347 is a reply to message #626336]

Mon, 27 October 2014 00:27

shahzad-ul-hasan
Messages: 615
Registered: August 2002

Senior Member

i will send you its fmb at evening. you will check... that..

Report message to a moderator

Re: set Financial Year [message #626397 is a reply to message #626347]

Mon, 27 October 2014 10:14

Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan

Member

thanks dear

i am waiting your reply

Report message to a moderator

Re: set Financial Year [message #626593 is a reply to message #626397]

Wed, 29 October 2014 10:19

shahzad-ul-hasan
Messages: 615
Registered: August 2002

Senior Member

Please see the attached file.

Attachment: FINANCE.FMB
(Size: 80.00KB, Downloaded 1253 times)

Report message to a moderator

Previous Topic:	oracle forms and reports 11gr2 server taking too long for update data on database
Next Topic:	check all checkboxes i.e non data databse item after execute query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 03:32:26 CDT 2024