Feature #199
openCost Sheet
Start date:
07/18/2023
Due date:
% Done:
70%
Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Cost Sheet
Tested By:
unnikannan S
Code Reviewed By:
Files
Subtasks
Related issues
Updated by Anil KV over 1 year ago
- Assignee changed from Junaid M to travvise Admin
Updated by Junaid M over 1 year ago
- Assignee changed from travvise Admin to Amal Siby
Updated by Amal Siby over 1 year ago
- Status changed from New to Coding Started
- Start date changed from 06/15/2023 to 07/18/2023
- % Done changed from 0 to 40
Updated by Junaid M over 1 year ago
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
Updated by Greeshma S 9 months ago
- 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
Updated by Greeshma S 8 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon 2 months ago
- File clipboard-202501101033-n31tm.png clipboard-202501101033-n31tm.png added
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND
--------
1)adm/acm message is not clearing
Updated by Greeshma S 2 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70