Project

General

Profile

Edit Copy Actions
Copy link

Feature #39

open

Set Document Code Format

Added by Anil KV over 2 years ago. Updated 7 months ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Baseem Shan
Target version:
22.12
Start date:
09/01/2022
Due date:
09/02/2022 (over 2 years late)
% Done:

70%

Estimated time:
16:00 h
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Document Code Format
Tested By:
unnikannan S
Code Reviewed By:
Quote

Description

Coding Document Code Format

GUI Change
1) Allowed Deleted And Reverted Doc No In Manual Entry Based On User Permission to Allowed Deleted And Reversal Doc No In Manual Entry Based On User Permission
2) Document Code Format List edit only checkbox and Separator
3) Branch List Edit only Perfix and FY List also
4) Number Part Length mandatory

Files

Download all files
2-tsModel.ts (1.57 KB) 2-tsModel.ts Anil KV, 09/03/2022 04:43 PM
1-CsModel.cs (2.17 KB) 1-CsModel.cs Anil KV, 09/03/2022 04:43 PM
3-CsFile.cs (11.4 KB) 3-CsFile.cs Anil KV, 09/03/2022 04:43 PM
4-CsControllerFile.cs (17.1 KB) 4-CsControllerFile.cs Anil KV, 09/03/2022 04:44 PM
5-TsFile.ts (13.9 KB) 5-TsFile.ts Anil KV, 09/03/2022 04:44 PM
6-HtmlFile.html (1.93 KB) 6-HtmlFile.html Anil KV, 09/03/2022 04:44 PM
sql.sql (8.97 KB) sql.sql Anil KV, 09/03/2022 04:44 PM
Add

Subtasks

Add

Related issues

QuoteActions
Copy link
 #1

Updated by Anil KV over 2 years ago 

public lstDocNoGeneratedBy: any[] = [
    { "intId": 1, "strLabel": "System Wise", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 2, "strLabel": "Compay Wise", "blnDisable": true, "blnActive": false, "strRemarks": "" },
    { "intId": 3, "strLabel": "Branch Wise", "blnDisable": false, "blnActive": true, "strRemarks": "" }
  ];

  public lstDocNoResetBy: any[] = [
    { "intId": 0, "strLabel": "No Reset", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 1, "strLabel": "Year Wise", "blnDisable": false, "blnActive": true, "strRemarks": "" },
    { "intId": 2, "strLabel": "Month Wise", "blnDisable": true, "blnActive": false, "strRemarks": "" }
  ];

  public lstSaleRefundSaringDocNo: any[] = [
    { "intId": 0, "strLabel": "Seperate Document Number For Each Sharing", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 1, "strLabel": "Create A Sharing Document And Append #1, #2, ...Other Sharing", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 2, "strLabel": "Append #1, #2, ....In Main Document Number", "blnDisable": false, "blnActive": true, "strRemarks": "" }
  ];

  public lstOtherSaringDocNo: any[] = [
    { "intId": 0, "strLabel": "Seperate Document Number For Each Party", "blnDisable": false, "blnActive": true, "strRemarks": "" },
    { "intId": 1, "strLabel": "Create A  Document And Append #1, #2, ...Each Party", "blnDisable": false, "blnActive": false, "strRemarks": "" }
  ];

  public lstDocNoYearFormat: any[] = [
    { "intId": 0, "strLabel": "", "blnDisable": false, "blnActive": true, "strRemarks": "" },
    { "intId": 1, "strLabel": "YY", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 2, "strLabel": "YYYY", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 3, "strLabel": "FY Prefix", "blnDisable": false, "blnActive": false, "strRemarks": "" }
  ];

  public lstDocNoMonthFormat: any[] = [
    { "intId": 0, "strLabel": "", "blnDisable": false, "blnActive": true, "strRemarks": "" },
    { "intId": 1, "strLabel": "M", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 2, "strLabel": "MM", "blnDisable": false, "blnActive": false, "strRemarks": "" },
    { "intId": 3, "strLabel": "MMM", "blnDisable": false, "blnActive": false, "strRemarks": "" }
  ];

  public lstDocNoFormatItems: any[] = [
    { "intId": 1, "strLabel": "Company", "blnDisable": true, "blnActive": false, "blnMandatory": false, "chrSeparator":"/", "strRemarks": "" },
    { "intId": 2, "strLabel": "Branch", "blnDisable": false, "blnActive": false, "blnMandatory": false, "chrSeparator": "/", "strRemarks": "" },
    { "intId": 3, "strLabel": "Document Code", "blnDisable": false, "blnActive": false, "blnMandatory": true, "chrSeparator": "/", "strRemarks": "" },
    { "intId": 3, "strLabel": "Number Part", "blnDisable": false, "blnActive": false, "blnMandatory": true, "chrSeparator": "/", "strRemarks": "" },
    { "intId": 3, "strLabel": "Month", "blnDisable": false, "blnActive": false, "blnMandatory": false, "chrSeparator": "/", "strRemarks": "" },
    { "intId": 3, "strLabel": "Year", "blnDisable": false, "blnActive": false, "blnMandatory": false, "chrSeparator": "-", "strRemarks": "" }
  ];
QuoteActions
Copy link
 #2

Updated by Anil KV over 2 years ago 

CREATE TABLE document.tbl_doc_no_gen_settings (
        pk_doc_no_gen_settings_id BIGSERIAL PRIMARY KEY,

        sin_doc_no_generated_by SMALLINT DEFAULT 0,--*1
        sin_doc_no_reset_by SMALLINT DEFAULT 0,--*2
        sin_allowed_manual_entry SMALLINT DEFAULT 1,
        sin_allowed_del_docs_manual_entry SMALLINT DEFAULT 1,

        sin_credit_sale_sharing_docs SMALLINT DEFAULT 3, --*3
        sin_cash_sale_sharing_docs SMALLINT DEFAULT 3, --*3
        sin_receipt_multi_party_docs SMALLINT DEFAULT 1, --*4
        sin_payment_multi_party_docs SMALLINT DEFAULT 1, --*4
        sin_dn_cn_docs SMALLINT DEFAULT 1, --*4

        sin_no_part_length SMALLINT DEFAULT 3,
        sin_year_part_format SMALLINT DEFAULT 0, --*5
        sin_month_part_format SMALLINT DEFAULT 0 --*6

) INHERITS(tbl_action_user_and_date_time);
--*1 -> 1 = System Wise - INV/001
--      2 = Compay Wise - Not Use - INV/COM/001
--      3 = Branch Wise - Default - INV/BTA/001
--*2 -> 0 = No Reset
--      1 = Year Wise - Default
--      2 = Month Wise
--*3 -> 1 = Seperate Document Number For Each Sharing
--      2 = Create A Sharing Document And Append #1, #2, ... Other Sharing
--      3 = Append #1, #2, .... In Main Document Number - Default
--*4 -> 1 = Seperate Document Number For Each Party - Default
--      2 = Create A  Document And Append #1, #2, ... Each Party
--*5 -> 0 = 
--      1 = YY
--      2 = YYYY
--      3 = FY Prefix
--*6 -> 0 = 
--      1 = M
--      2 = MM
--      3 = MMMM
------------------------------------------------------------------------------------------------------
--Use : Document no parts and order
--Ref : 
--Case: ->Doc Number Prefix(Company and Branch Keep in own table) and FY also
--Note:
CREATE TABLE document.tbl_doc_no_format (
        pk_doc_no_format_id BIGSERIAL PRIMARY KEY,

        int_doc_order INTEGER NOT NULL,  
        sin_system_doc_part SMALLINT NOT NULL, --*1
        chr_doc_separator CHAR(1),

        sin_is_active SMALLINT DEFAULT 0,
           sin_is_editable SMALLINT DEFAULT 0
);
--*1 -> 1 - Company - Disable
--        2 - Branch 
--      3 - Document Code - ON and Disable(Not alloed to OFF)
--      4 - Number Part - ON and Disable(Not alloed to OFF)
--      5 - Month
--      6 - Year
Actions
Copy link
 #4

Updated by Shanto Shaji over 2 years ago

  • Status changed from New to Coding Started
  • % Done changed from 0 to 40
Actions
Copy link
 #5

Updated by Shanto Shaji over 2 years ago

  • Status changed from Coding Started to Particialy Coding Done
  • % Done changed from 40 to 30
Actions
Copy link
 #6

Updated by Shanto Shaji over 2 years ago

  • Status changed from Particialy Coding Done to Reopen Bugs Coding Done
  • % Done changed from 40 to 60
Actions
Copy link
 #7

Updated by Shanto Shaji over 2 years ago

  • Status changed from Reopen Bugs Coding Done to Particialy Coding Done
  • % Done changed from 60 to 40
QuoteActions
Copy link
 #8

Updated by Shanto Shaji over 2 years ago

To Do

Finaincial year Tab

Actions
Copy link
 #9

Updated by Shanto Shaji over 2 years ago

  • Status changed from Particialy Coding Done to Coding Done
  • % Done changed from 40 to 60
QuoteActions
Copy link
 #10

Updated by Amal Cyriac almost 2 years ago

  • Status changed from Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to Amal Cyriac

ISSUE FOUND *****
1.Branch , Company prefix not working while new Doc. Generation
2.Cant remove year prefix

Actions
Copy link
 #11

Updated by Shanto Shaji almost 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #12

Updated by Amal Cyriac over 1 year ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

TO DO

*****
1.Add separator (/) column
( after parameter column)
2.Disable company checkbox
3.Set Example field as dynamic
4.Set to global constant (Variable, Document related values)

Actions
Copy link
 #13

Updated by Junaid M over 1 year ago

  • Assignee changed from Shanto Shaji to Baseem Shan
QuoteActions
Copy link
 #14

Updated by unnikannan S over 1 year ago

ISSUE FOUNDED

1.DISABLE COMPANY

Actions
Copy link
 #15

Updated by Baseem Shan over 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #16

Updated by unnikannan S over 1 year ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By changed from Amal Cyriac to unnikannan S

ISSUE FOUNDED

1.ADD VALIDATION FOR CREDIT SALE,CASH SALE DOC NO GENERATING FIELD
2.NOT WORKING MONTH PART FORMAT
3.ERROR WHILE ADDING MORE VALUE IN SEPERATER FIELD (Error converting value "//" to type 'System.Char'. Path 'mdlDocumentCodeFormat.lstMdlDocNoFormat3.chrDocSeparator', line 1, position 883.)
4.DUPLICATION IN BRANCH PREFIX CODE (WHILE CHOOSING DOC NO RESET BY YEAR WISE)
5.CONNECT YEAR PART FUNCTION

Actions
Copy link
 #17

Updated by Baseem Shan about 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #18

Updated by Junaid M 7 months ago

NEW CHANGES
----------------------
1. Add New option in all 4 select box "No Separate Document Number"
2. For Credit Sale And Refund Sharing Document No Generating, Cash Sale And Refund Sharing Document No Generating Default option is "Seperate Document Number for each Sharing".
3. For Rv, Pv, DnCn Default option is "No Separate Document Number"

[Done] - Added in Data service.

Edit Copy Actions
Copy link

Also available in: Atom PDF