Project

General

Profile

Edit Copy Actions
Copy link

Feature #199

open

Cost Sheet

Added by Junaid M almost 2 years ago. Updated 30 days ago.

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

Description

Coding Cost Sheet

Files

Download all files
clipboard-202501101033-n31tm.png (57.2 KB) clipboard-202501101033-n31tm.png Theja Ponon, 01/10/2025 10:33 AM
clipboard-202504031449-dsq9g.png (140 KB) clipboard-202504031449-dsq9g.png Theja Ponon, 04/03/2025 02:49 PM
clipboard-202504031451-suzpg.png (20 KB) clipboard-202504031451-suzpg.png Theja Ponon, 04/03/2025 02:51 PM
Add

Subtasks

Add

Related issues

Actions
Copy link
 #1

Updated by Anil KV almost 2 years ago

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

Updated by Junaid M almost 2 years ago

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

Updated by Amal Siby almost 2 years 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
QuoteActions
Copy link
 #4

Updated by Junaid M almost 2 years 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
Copy link
 #5

Updated by Junaid M about 1 year ago

  • Assignee changed from Amal Siby to Greeshma S
QuoteActions
Copy link
 #6

Updated by Greeshma S 10 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

QuoteActions
Copy link
 #7

Updated by unnikannan S 10 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
Copy link
 #8

Updated by Greeshma S 10 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #9

Updated by Theja Ponon 4 months ago

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

Actions
Copy link
 #10

Updated by Greeshma S 4 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Actions
Copy link
 #11

Updated by Theja Ponon 30 days ago

QuoteActions
Copy link
 #12

Updated by Theja Ponon 30 days ago

Issue Found
--------
1)Incorrect value in count of document and customer amount ,supplier amount

2)showing this error message on taking print

3)Print is not showing for last two items in print list
4)refernce no is not showing in print of general doc print and issue on date
5)In linked document tab ,credit,debit,matched amounts are not showing

Actions
Copy link
 #13

Updated by Greeshma S 30 days ago

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

Also available in: Atom PDF