set Financial Year [message #626326] |
Sun, 26 October 2014 01:45 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c514fffdfe7aab065b12f1f8ace8f6c1?s=64&d=mm&r=g) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahzad-ul-hasan
Messages: 625 Registered: August 2002
|
Senior Member |
|
|
please see the attached file.
![/forum/fa/12244/0/](/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 1625 times)
|
|
|
|
|
|
|