Project

General

Profile

Actions

Dev Task - Normal #11

open

Orderline Test Report

Added by Amul Munusamy 30 days ago. Updated 18 days ago.

Status:
User Acceptance Pending
Priority:
Normal
Start date:
11/13/2025
Due date:
% Done:

0%

Estimated time:

Description

Type of Report - field details attached here.

https://emmesspms.amachu.tech/attachments/48


Files

test_report_field_details.txt (842 Bytes) test_report_field_details.txt Amul Munusamy, 11/13/2025 03:55 AM
test_report.xlsx (22.2 KB) test_report.xlsx Amul Munusamy, 11/13/2025 05:13 AM
report_type_acceptance.png (78.4 KB) report_type_acceptance.png Vignesh Saravanan, 11/13/2025 07:45 AM
report_type_nabl.png (92.4 KB) report_type_nabl.png Vignesh Saravanan, 11/13/2025 07:45 AM
test_report_order_lines_tree_view.png (103 KB) test_report_order_lines_tree_view.png Vignesh Saravanan, 11/13/2025 07:45 AM
clipboard-202511131934-fcp5y.png (98.9 KB) clipboard-202511131934-fcp5y.png Vignesh Saravanan, 11/13/2025 02:04 PM
clipboard-202511151106-agobx.png (46.2 KB) clipboard-202511151106-agobx.png Vignesh Saravanan, 11/15/2025 05:36 AM
clipboard-202511151110-asdxl.png (65 KB) clipboard-202511151110-asdxl.png Vignesh Saravanan, 11/15/2025 05:40 AM
clipboard-202511151111-cquu3.png (103 KB) clipboard-202511151111-cquu3.png Vignesh Saravanan, 11/15/2025 05:41 AM
clipboard-202511151112-inslr.png (63.7 KB) clipboard-202511151112-inslr.png Vignesh Saravanan, 11/15/2025 05:42 AM
clipboard-202511151113-s4brv.png (106 KB) clipboard-202511151113-s4brv.png Vignesh Saravanan, 11/15/2025 05:43 AM
Test_Report_Demo.mp4 (23.7 MB) Test_Report_Demo.mp4 Vignesh Saravanan, 11/15/2025 12:48 PM
emmess_communication_update.jpeg (193 KB) emmess_communication_update.jpeg Vignesh Saravanan, 11/15/2025 12:52 PM
report_type_acceptance.png
report_type_nabl.png
test_report_order_lines_tree_view.png
clipboard-202511131934-fcp5y.png
clipboard-202511151106-agobx.png
clipboard-202511151110-asdxl.png
clipboard-202511151111-cquu3.png
clipboard-202511151112-inslr.png
clipboard-202511151113-s4brv.png
emmess_communication_update.jpeg
Actions #1

Updated by Amul Munusamy 30 days ago

  • Subject changed from Type of Report to Test Report
Actions #2

Updated by Vignesh Saravanan 30 days ago

  • Status changed from New to In Progress
Actions #3

Updated by Vignesh Saravanan 30 days ago · Edited

Analysis

Define a new class OrderLineTestReport in sale_order_line.py with the fields specified in the given XLSX sheet. Add a One2many field in the sale.order model. Create and declare the corresponding form and tree views in both the Sale Order Form View and the Sale Quotation Form View.

Actions #5

Updated by Amul Munusamy 30 days ago

  • Description updated (diff)

Updated by Vignesh Saravanan 30 days ago · Edited

report_type_acceptance.png
report_type_nabl.png
test_report_order_lines_tree_view.png

Development Update:

Test Report Tab - List View

Report Type NABL

Report Type Acceptance

Actions #7

Updated by Amul Munusamy 29 days ago

  • Subject changed from Test Report to Orderline Test Report
Actions #9

Updated by Vignesh Saravanan 29 days ago

Defined an Onchange function when report_type = nabl

@api.onchange('test_qty')
    def _onchange_test_qty(self):        
        self.nabl_test_report_lines = [(5, 0, 0)]        
        lines = []
        prev_nabl_lines = self.env['order.line.test.report'].search([('sale_order_line_id', '=', self.sale_order_line_id.ids[0])])
        start_sno = 0
        for nabl_line in prev_nabl_lines:
            start_sno += len(nabl_line.nabl_test_report_lines)        
        for qty in range(self.test_qty):
            start_sno += 1
            lines.append((0, 0, {'sno': start_sno}))
        self.nabl_test_report_lines = lines
Actions #10

Updated by Vignesh Saravanan 28 days ago

clipboard-202511151106-agobx.png

ULR & UID Sequence Generation

Analysis:

UID

Uid sample - ECPL/CT/2025-26/001

Financial year based

ECPL - company name

CT/VT/DT - product classification

2025-2026 - financial year

001 to …. Based on number of items tested. Not based on product classification but based on total count

ULR

Ulr

TC11133/25/000000001F

TC11133 - lab ID remains constant

25 -calendar year changes since it’s considered January to December

000000001F this should be as per product classification

For CT / VT/ DT - each category should start from 000000001F and it goes on.. it gets carried across manufacturing order

Solution

New two fields defined in Internal Product Type menu path: Inventory --> Configuration --> Products --> Internal Product Type.

Technical Name Comodel String
uid_sequence_id ir.sequence UID Sequence Id
ulr_sequence_id ir.sequence ULR Sequence Id

View Update:

Create sequence for ULR and UID in ir.sequence model

Updated by Vignesh Saravanan 28 days ago

clipboard-202511151110-asdxl.png
clipboard-202511151111-cquu3.png
clipboard-202511151112-inslr.png
clipboard-202511151113-s4brv.png

ULR

Creation for OCT product category

For all 10 product category sequence are created

UID

Creation for AT product category

For all 10 product category sequence are created

Actions #14

Updated by Vignesh Saravanan 26 days ago

  • Status changed from In Progress to Resolved
Actions #15

Updated by Vignesh Saravanan 18 days ago

  • Status changed from Resolved to User Acceptance Pending
Actions

Also available in: Atom PDF