| master-detail [message #78194] |
Mon, 28 January 2002 00:05  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
