| how to attach holidays in my discount form in form 6i [message #252476] |
Wed, 18 July 2007 23:54  |
contact.gauravsharma
Messages: 2
Registered: July 2007
|
Junior Member |
|
|
Hi to all of respected members
i am making a cash discount form for finanac module and in which we have to give discount depending upon the payment days.
fields:- days_from,days_to,discount
for example- days_from......days_to...... % discount
1 .............7...........8.00
1..............15...........6.00
1..............30............2.00
but if there is a holidays like (sunday,any festival) between the
days_from and days_to given by operator to the system then these
holidays should be automatically adjusted
please help me in this regard.(It's urgent)i am attaching the related form(fmb)...
|
|
|
|
|
|
| Re: how to attach holidays in my discount form in form 6i [message #252551 is a reply to message #252476] |
Thu, 19 July 2007 02:54  |
bahubcd
Messages: 40
Registered: July 2007
Location: Bangalore
|
Member |
|
|
Hi,
For the requirement stated by you,
I suggest you to create a seperate admin form to record the holiday dates in to a table(holidays_tb) which can have columns namely holiday_date and holiday_desc.
Then while running your original form, get the no of days that fall in the date range (this is the input given in your orginal form) from the holidays_tb and subtract the same from the days_from and days_to difference.
This has a bit of work around but can serve your requirement.
Please do inform me how did you implement it at the end (In case of a different way)..
|
|
|
|
| Re: how to attach holidays in my discount form in form 6i [message #252582 is a reply to message #252545] |
Thu, 19 July 2007 04:30 |
contact.gauravsharma
Messages: 2
Registered: July 2007
|
Junior Member |
|
|
Right now the table i am using with this form is as follows
[SIZE=7]Table name:- fac_discount_m
SQL> desc fac_discount_m;
Name Null? Type
------------------------------- -------- ----
DAYS_FROM NUMBER(4)
DAYS_TO NUMBER(5)
CASH_DISCOUNT NUMBER(6,2)
FAC_PARTY_CODE VARCHAR2(6)
FAC_LOCN_CODE VARCHAR2(6)
ITEM_MAIN_CODE VARCHAR2(2)
As u asked any table for sunday and holidays....i am not using any table right now.....simply because. i don't know ...what to do and how to do.............plz....help me in this regard.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
