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 ?
|
|
|
Re: set Financial Year [message #626332 is a reply to message #626326] |
Sun, 26 October 2014 08:40 |
shahzad-ul-hasan
Messages: 625 Registered: August 2002
|
Senior Member |
|
|
please see the attached file.
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 1646 times)
|
|
|
|
|
|
|