Home » Developer & Programmer » Forms » how to attach holidays in my discount form in form 6i
how to attach holidays in my discount form in form 6i [message #252476] Wed, 18 July 2007 23:54 Go to next message
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 #252545 is a reply to message #252476] Thu, 19 July 2007 02:46 Go to previous messageGo to next message
zameersait
Messages: 16
Registered: July 2007
Junior Member
The form u hav given only shows the setup of the discount and its days range. Where are u applying the discount? The sundays and holidays are read from any table?
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 Go to previous messageGo to next message
bahubcd
Messages: 36
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 Go to previous message
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.
Previous Topic: GO_RECORD ?
Next Topic: how i can send value from one form to another
Goto Forum:
  


Current Time: Thu Dec 08 16:15:14 CST 2016

Total time taken to generate the page: 0.12923 seconds