Feature #199
open
- Assignee changed from Junaid M to travvise Admin
- Assignee changed from travvise Admin to Amal Siby
- Status changed from New to Coding Started
- Start date changed from 06/15/2023 to 07/18/2023
- % Done changed from 0 to 40
Query - Total Price And Cost
SELECT
MIN(sm.pk_sale_master_id) AS pk_sale_master_id,
COUNT(doc.vhr_file_number) AS vhr_file_number_count,
SUM(sm.dbl_base_cur_supplier_amount) AS dbl_base_cur_supplier_amount,
SUM(sm.dbl_base_cur_customer_amount) AS dbl_base_cur_customer_amount,
'SALE' AS vhr_module
FROM sale.tbl_sale_master AS sm
LEFT JOIN document.tbl_documents AS doc
ON sm.fk_documents_id = doc.pk_documents_id
WHERE
UPPER(doc.vhr_file_number) = '?'
GROUP BY doc.vhr_file_number
UNION ALL
SELECT
MIN(rm.pk_refund_master_id) AS pk_refund_master_id,
COUNT(doc.vhr_file_number) AS vhr_file_number_count,
SUM(rm.dbl_base_cur_supplier_amount) AS dbl_base_cur_supplier_amount,
SUM(rm.dbl_base_cur_customer_amount) AS dbl_base_cur_customer_amount,
'REFYND' AS vhr_module
FROM refund.tbl_refund_master AS rm
LEFT JOIN document.tbl_documents AS doc
ON rm.fk_documents_id = doc.pk_documents_id
WHERE UPPER(doc.vhr_file_number) = '?'
GROUP BY doc.vhr_file_number
- Assignee changed from Amal Siby to Greeshma S
- Status changed from Coding Started to Coding Done
- % Done changed from 30 to 60
Journal,Debit-CreditNote,ADM/ACm master,ADM/ACm Adjustment Posting Summary Not Added
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to unnikannan S
ISSUE FOUNDED
1.Clear Deleted Vouchers/Doc Datas From General Tab
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
ISSUE FOUND
--------
1)adm/acm message is not clearing

- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Also available in: Atom
PDF