Feature #10
openPayment Terms Master
Added by Anil KV over 2 years ago. Updated 5 days ago.
70%
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 DateFiles
| 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 |
Subtasks
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/...
Updated by Aparna Mathew over 2 years ago
- Status changed from New to Coding Started
- % Done changed from 0 to 40
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
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
Updated by Shanto Shaji over 2 years ago
- Tested By set to Shanto Shaji
- Code Reviewed By set to Shanto Shaji
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.
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
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
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
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)
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
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
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 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
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 Junaid M about 1 year ago
GUI Changes As per DOC001. Ask Junaid for changes Page
Updated by Junaid M about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
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)
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)"
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}
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
- File clipboard-202412311431-v03p0.png clipboard-202412311431-v03p0.png added
- Status changed from New Changes to Reopen Bugs
ISSUE FOUND
----------------------------------------
1. Due duration wrong when selecting bill duration as two months and payment mode as same month---discuss with anil
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
- File clipboard-202503041259-jtf3b.png clipboard-202503041259-jtf3b.png added
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
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.
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
- File clipboard-202503131525-srywr.png clipboard-202503131525-srywr.png added
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
Issue Found
----------
1)Bill period is showing incorrectly
Updated by Augustin Jose 5 days ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70