Project

General

Profile

Edit Copy Actions

Feature #10

open

Payment Terms Master

Added by Anil KV over 2 years ago. Updated 5 days ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Target version:
Start date:
08/04/2022
Due date:
08/08/2022 (over 2 years late)
% Done:

70%

Estimated time:
20:00 h
Owner(Agency):
Travvise
Time Taken(HH):
37.00
Module:
Payment Terms
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Payment Terms

CREATE TABLE accounts.tbl_payment_terms (
pk_payment_terms_id BIGSERIAL PRIMARY KEY,

sin_payment_mode SMALLINT NOT NULL DEFAULT 1, --*1
sin_next_day_week_month SMALLINT DEFAULT 0, --*2
sin_based_on SMALLINT NULL DEFAULT 1, --*2
vhr_payment_term_string VARCHAR(250) NOT NULL,
sin_if_supplier SMALLINT DEFAULT 1,
sin_if_customer SMALLINT DEFAULT 1
) INHERITS(tbl_action_user_and_date_time);
--*1 > 0 = No Terms
-
1 = Cash Only
-- 2 = Advance Payment
-- 3 = Same Month
-- 4 = Same Fortnight
-- 5 = Same Week
-- 6 = Same Day
-- 7 = Next Month
-- 8 = Next Fortnight
-- 9 = Next Week
-- 10 = Next Day
--*2 > *1>7 and 0 Input then consider Next Month End, MAX Value=31
-- *1->8 and 0 Input then consider Next Fortnight End, MAX Value=15
-- *1->9 and 0 Input then consider Next Week End, MAX Value=7
-- *1->10 then Inut is must, MIN=1, MAX=365
--*3 > 1 = Document Date
-
2 = Submission Date
-- 3 = Issue Date
-- 4 = Travel/Check In/From Date
-- 5 = Return/Check Out/To Date

Files

1-CsModel.txt (1.4 KB) 1-CsModel.txt Anil KV, 08/04/2022 12:03 PM
2-tsModel.txt (1002 Bytes) 2-tsModel.txt Anil KV, 08/04/2022 12:03 PM
4-CsControllerFile.txt (24.3 KB) 4-CsControllerFile.txt Anil KV, 08/04/2022 12:03 PM
3-CsFile.txt (12.9 KB) 3-CsFile.txt Anil KV, 08/04/2022 12:03 PM
6-HtmlFile.txt (1.91 KB) 6-HtmlFile.txt Anil KV, 08/04/2022 12:03 PM
5-TsFile.txt (13.6 KB) 5-TsFile.txt Anil KV, 08/04/2022 12:03 PM
sql.txt (13.4 KB) sql.txt Anil KV, 08/04/2022 12:03 PM
clipboard-202412311431-v03p0.png (98.7 KB) clipboard-202412311431-v03p0.png Arathy PS, 12/31/2024 02:31 PM
BSP-Payment-Cycle-Travelify.jpg (177 KB) BSP-Payment-Cycle-Travelify.jpg Junaid M, 03/04/2025 12:30 PM
clipboard-202503041259-jtf3b.png (72.6 KB) clipboard-202503041259-jtf3b.png Arathy PS, 03/04/2025 12:59 PM
clipboard-202503131525-srywr.png (105 KB) clipboard-202503131525-srywr.png Theja Ponon, 03/13/2025 03:25 PM

Add

Subtasks


Add

Related issues

Updated by Anil KV over 2 years ago

public lstPaymentMode: any[] = [ { "intId": 0, "strLabel": "No Terms", "blnDisable": false, "blnActive": true, "strRemarks": "" }, { "intId": 1, "strLabel": "Cash Only", "blnDisable": false, "blnActive": false, "strRemarks": "" }, { "intId": 2, "strLabel": "Advance Payment", "blnDisable": false, "blnActive": false, "strRemarks": "" }, { "intId": 3, "strLabel": "Same Month", "blnDisable": false, "blnActive": false, "strRemarks": "" }, { "intId": 4, "strLabel": "Same Fortnight", "blnDisable": false, "blnActive": false, "strRemarks": "" }, { "intId": 5, "strLabel": "Same Week", "blnDisable": false, "blnActive": false, "strRemarks": "" }, { "intId": 6, "strLabel": "Same Day", "blnDisable": false, "blnActive": false, "strRemarks": "" }, { "intId": 7, "strLabel": "Next Month", "blnDisable": false, "blnActive": false, "strRemarks": "" }, { "intId": 8, "strLabel": "Next Fortnight", "blnDisable": false, "blnActive": false, "strRemarks": "" }, { "intId": 9, "strLabel": "Next Week", "blnDisable": false, "blnActive": false, "strRemarks": "" }, { "intId": 10, "strLabel": "Next Day", "blnDisable": false, "blnActive": false, "strRemarks": "" },
];

public lstPaymentModeBasedOn: any[] = [ { "intId": 1, "strLabel": "Document Date", "blnDisable": false, "blnActive": true, "strRemarks": "" }, { "intId": 2, "strLabel": "Submission Date", "blnDisable": false, "blnActive": false, "strRemarks": "" }, { "intId": 3, "strLabel": "Issue Date", "blnDisable": false, "blnActive": false, "strRemarks": "" }, { "intId": 4, "strLabel": "Travel/Check In/From Date", "blnDisable": false, "blnActive": false, "strRemarks": "" }, { "intId": 5, "strLabel": "Return/Check Out/To Date", "blnDisable": false, "blnActive": false, "strRemarks": "" },
];

Updated by Anil KV over 2 years ago

Cases
1) Days entry enable only NEXT DAYS, NEXT MONTH, NEXT Fortnight, NEXT WEEK. otherwise no values and not editable
2) Build Payment Name string = Payment Mode + [within + Days] + Based on + Document Date/...

Actions #3

Updated by Aparna Mathew over 2 years ago

  • Status changed from New to Coding Started
  • % Done changed from 0 to 40
Actions #4

Updated by Aparna Mathew over 2 years ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 40 to 60
  • Time Taken(HH) set to 37.00
  • Module set to Payment Terms
Actions #5

Updated by Shanto Shaji over 2 years ago

  • Status changed from Coding Done to Testing Started

Updated by Shanto Shaji over 2 years ago

  • Status changed from Testing Started to Reopen Bugs
  • % Done changed from 60 to 50

Created By And Modified By string Alignment Issue

Actions #7

Updated by Shanto Shaji over 2 years ago

  • Tested By set to Shanto Shaji
  • Code Reviewed By set to Shanto Shaji
Actions #8

Updated by Aparna Mathew over 2 years ago

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

Updated by Aparna Mathew over 2 years ago

In html the created by alignment fixed.
In ts file the remove all unwanted console and commented lines.

Actions #10

Updated by Shanto Shaji over 2 years ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Started
  • % Done changed from 60 to 70
Actions #11

Updated by Shanto Shaji over 2 years ago

  • Status changed from Reopen Bugs Testing Started to Reopen Bugs Testing Done
  • % Done changed from 70 to 80

Updated by Anil KV over 2 years ago

  • Status changed from Reopen Bugs Testing Done to Reopen Bugs
  • % Done changed from 80 to 50

Change Data service

lstPaymentMode to lstPaymentTerms
lstPaymentModeBasedOn to lstPaymentTermsBasedOn

Actions #13

Updated by Aparna Mathew over 2 years ago

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

Updated by Amal Cyriac about 2 years ago

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

ISSUE FOOD ****
1.Set validations on Payment Terms --> No. Of Days
Same Week
Same Fortnight
Same day

Actions #15

Updated by Aparna Mathew about 2 years ago

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

Updated by Amal Cyriac almost 2 years ago

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

ISSUE FOUND *****
1.Fix mistakes on labels while translation
(Arabic)
2.At least one Item checked while Save/Update
(Supplier & Customer)

Actions #17

Updated by Aparna Mathew almost 2 years ago

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

Updated by Amal Cyriac almost 2 years ago

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

ISSUE FOUND *****
1.Update grid head- Payment Terms List

Actions #19

Updated by Aparna Mathew almost 2 years ago

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

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 BLANK OPTIONS IN BASED ON
2.CAN'T SAVE PAYMENT TERM WITH CASH ONLY

Actions #21

Updated by Aparna Mathew over 1 year ago

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

Updated by unnikannan S over 1 year ago

TESTING DONE

Updated by unnikannan S about 1 year ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Code Reviewed By deleted (Shanto Shaji)

ISSUE FOUNDED

1.ADD COMMISSION AGENT CHECK BOX IN UI
2.ADD DOCUMENT END DATE IN UI
3.SHOW TOOL TIP FOR END DATE IN UI AS BILL DATE
4.SHOW PAYMENT DUE DATE AS PAYMENT DATE IN UI (TOOL TIP)
5.SHOW MINIMUM MAXIMUM DURATION OF DATES AS EXAMPLE

Actions #24

Updated by Aparna Mathew about 1 year ago

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

Updated by unnikannan S about 1 year ago

TESTING DONE

Updated by Junaid M about 1 year ago

GUI Changes As per DOC001. Ask Junaid for changes Page

Actions #27

Updated by Junaid M about 1 year ago

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

Updated by Aparna Mathew about 1 year ago

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

Updated by unnikannan S about 1 year ago

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

ISSUE FOUNDED

1.ALLOW WEEKLY WISE CHANGES ON PERIOD
2.ADD TRANSACTION DATE ON BASED ON SELECT BOX
3.SHOW DEFAULT BASED ON DATE AS TRANSACTION DATE (DISABLE ALL OTHER BASED ON DATES IN UI)
4.FIX TRANSLATION BUG IN LIST WHILE CHOOSING PAYMENT MODE (NEXT OPTIONS)

Actions #30

Updated by Aparna Mathew 12 months ago

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

Updated by unnikannan S 12 months ago

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

ISSUE FOUNDED

1.SHOW TERMS BASED ON CATEGORY IN LIST
2.BILL DURATION SHOWING IN MINUS

Actions #32

Updated by Aparna Mathew 12 months ago

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

Updated by unnikannan S 12 months ago

TESTING DONE

Updated by unnikannan S 12 months ago

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

ISSUE FOUNDED

1.ERROR ON CONSOLE WHILE CLEARING BILL DURATION DAY AND TRY TO UPDATE
2.SHOWING NAN IN DAY FIELD
3.FIX BUGS ON PRINT GRID

Actions #35

Updated by Aparna Mathew 12 months ago

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

Updated by unnikannan S 12 months ago

TESTING DONE

Actions #37

Updated by unnikannan S 8 months ago

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

Updated by unnikannan S 8 months ago

ISSUE FOUNDED

1. Fix Showing Null In UI In Case Of Clearing Default Value Choosing Next Week/Month
2. Error While Clearing Default Value 0
3. Change In Submission Period On Focus Out
4. Payment mode as Same Month > Bill Period showing previous month... Missing bill duration
5. Bill Submission Weekly (Fri-Thu) Data showing Thu-Fri

Updated by Avinash MS 8 months ago

GUI Change
---------------------------------------------------------------------------------------
1. Hide div Sample upon choosing Payment Mode -> No Term, Cash Only, Advance Payment.
2. Bill Submission -> Change Monthly - Monthly/Month (Default 1, Max 6, no zero value)
3. Base Date -> Add title as "Sample Date (Included)"

Actions #40

Updated by Aparna Mathew 8 months ago

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

Updated by unnikannan S 7 months ago

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

ISSUE FOUNDED

1.Monthly,quarterly bill period showing incorrectly

Updated by Avinash MS 7 months ago

GUI Change
------------------------------------------------------------------------------------------------
1) Payment Mode "Same Month"> Bill Submission {Monthly/Month(1), Fortnight, Weekly, Days}
2) Payment Mode "Same Fortnight"> Bill Submission {Fortnight, Weekly, Days}
3) Payment Mode "Same Week"> Bill Submission {Weekly, Days}

Actions #43

Updated by Aparna Mathew 7 months ago

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

Updated by Arathy PS 7 months ago

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

Issue found:
1)Enable 'days' in bill submission when select 'same month' as payment term.

Actions #45

Updated by Aparna Mathew 7 months ago

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

Updated by Arathy PS 4 months ago

  • Status changed from Reopen Bugs Coding Done to New Changes
  • % Done changed from 70 to 50

NEW CHANGES
------------------------------------------------------------

1. In 'Based On' Enable 'Submission Date'.
2. In 'Based On' Enable 'Customer Approved Date'--Not needed.
3. In 'Based On' add 'Corporate Approved (Submission).
4. In 'Based On' add 'Corporate Approved (Invoice).
*Change Payment Term String based the data also 

Ask anil
---------------
=>Change All overdue report the payment team based
=>Change Corporate overdue list the payment team based
=>Change Extra Limit set GUI the payment team based

Updated by Arathy PS 3 months ago

ISSUE FOUND
----------------------------------------
1. Due duration wrong when selecting bill duration as two months and payment mode as same month---discuss with anil

Actions #48

Updated by Arathy PS 3 months ago

  • Assignee changed from Aparna Mathew to Vivekp V
Actions #49

Updated by Arathy PS 2 months ago

  • Assignee changed from Vivekp V to Augustin Jose
Actions #50

Updated by Augustin Jose 2 months ago

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

Updated by Arathy PS 14 days ago

ISSUE FOUND
------------------------
1. Due date is incorrect when payment term is set for next day with days:7

In the bill submission select item : days (start date 1st), fortnight/2 (1-7, 8-15, 16-23, 24-ME) --ALSO IN ALL CUSTOMER, SUPPLIER MASTER MODULES.

Actions #53

Updated by Augustin Jose 11 days ago

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

Updated by Theja Ponon 5 days ago

Issue Found
----------
1)Bill period is showing incorrectly

Actions #55

Updated by Augustin Jose 5 days 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