Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : EasyPrint Tool : RPOS6 : Profile Type : SALES

TOTAL SAVING (QUERY FIELD)

select sum(med_bill_hdr.mbh_schm_amt + med_bill_hdr.mbh_bill_schm_amt) + (sum(med_bill_dtl.mbd_item_qty*med_bill_dtl.mbd_max_rate)- sum(med_bill_dtl.mbd_item_qty*med_bill_dtl.mbd_item_rate)) from med_bill_hdr inner join med_bill_dtl on mbh_bill_no=mbd_bill_no where mbh_bill_no=GOFRUGAL


Related Articles
There are no related articles


Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB