| Master-Details [message #78187] |
Fri, 25 January 2002 01:42  |
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 and net amount automatically.
Chandrakanth
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
