Project

General

Profile

Edit Copy Actions

Feature #199

open

Cost Sheet

Added by Junaid M almost 2 years ago. Updated 2 months ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Target version:
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:

Description

Coding Cost Sheet


Files

clipboard-202501101033-n31tm.png (57.2 KB) clipboard-202501101033-n31tm.png Theja Ponon, 01/10/2025 10:33 AM

Add

Subtasks


Add

Related issues

Actions #1

Updated by Anil KV over 1 year ago

  • Assignee changed from Junaid M to travvise Admin
Actions #2

Updated by Junaid M over 1 year ago

  • Assignee changed from travvise Admin to Amal Siby
Actions #3

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

Actions #5

Updated by Junaid M 11 months ago

  • Assignee changed from Amal Siby to Greeshma S

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 unnikannan S 8 months ago

  • 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

Actions #8

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

ISSUE FOUND
--------
1)adm/acm message is not clearing

Actions #10

Updated by Greeshma S 2 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Edit Copy Actions

Also available in: Atom PDF