Home » Developer & Programmer » Forms » master-detail
master-detail [message #78194] Mon, 28 January 2002 00:05 Go to next message
chandrakanth
Messages: 16
Registered: October 2001
Junior Member
THERE ARE TWO TABLES

A. P_ORDER 1. PO_NO - MASTER
2. PO_DT
3. PARTY
4. BASIC_AMT
5. SALESTAX_AMT
6. EXCISEAMT
7. TRANSPORT CHARGES
8. DISCOUNT AMT
9. NET_AMT

B. PORDER_ITEMS - DETAILS
1. PO_NO
2. PO_DT
3. ITEM
4. RATE
5. QUANTITY
6. AMOUNT

Details is having mulitiple rows. In detail block amount = rate * quantity.

Sum of the detailblock.amount= masterblock.basic_amt.

Salestax and excise is according to the percentage given by the users.

Net_amt = basic_amt+salestax_amt+exciseamt+transport
charges-discount_amt

How to calculate the gross,salestax,exise and net amount automatically.

also i want to modify the qty or rate even after providing sales tax, excise percentage.if so basis and other amounts to be calculated according to the new values

Chandrakanth
Re: master-detail [message #78261 is a reply to message #78194] Tue, 05 February 2002 21:58 Go to previous message
Manoj
Messages: 101
Registered: August 2000
Senior Member
use summary columns in detail block and
write trigger in post block or whatever y r using to leave then block assign these entry to master block items .it will work.
Previous Topic: Oracle Developer
Next Topic: re: ORA-03121
Goto Forum:
  


Current Time: Thu Apr 02 15:03:11 CDT 2020