Project

General

Profile

Edit Copy Actions
Copy link

Feature #117

open

Intra Bank Transfer

Added by Anil KV over 2 years ago. Updated 1 day ago.

Status:
New Changes Coding Done
Priority:
Normal
Assignee:
Sreeranjini T
Target version:
22.12
Start date:
02/04/2023
Due date:
% Done:

70%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Intra Bank Transfer
Tested By:
unnikannan S
Code Reviewed By:
Quote

Description

Coding Intra Bank Transfer

Files

Download all files
2-tsModel.ts (2.18 KB) 2-tsModel.ts Junaid M, 01/05/2023 02:25 PM
1-CsModel.cs (4.25 KB) 1-CsModel.cs Junaid M, 01/05/2023 02:25 PM
3-CsFile.cs (14.5 KB) 3-CsFile.cs Junaid M, 01/05/2023 02:25 PM
4-CsControllerFile.cs (25.4 KB) 4-CsControllerFile.cs Junaid M, 01/05/2023 02:25 PM
6-HtmlFile.html (1.91 KB) 6-HtmlFile.html Junaid M, 01/05/2023 02:25 PM
5-TsFile.ts (16 KB) 5-TsFile.ts Junaid M, 01/05/2023 02:25 PM
sql.sql (17.9 KB) sql.sql Junaid M, 01/05/2023 02:25 PM
Add

Subtasks

Add

Related issues

Actions
Copy link Download all files
 #1

Updated by Junaid M about 2 years ago

Actions
Copy link
 #2

Updated by Junaid M about 2 years ago

  • Assignee changed from Junaid M to Amal Siby
Actions
Copy link
 #3

Updated by Amal Siby about 2 years ago

  • Status changed from Open to Coding Started
  • % Done changed from 10 to 40
Actions
Copy link
 #4

Updated by Amal Siby about 2 years ago

  • Start date changed from 12/07/2022 to 02/04/2023
QuoteActions
Copy link
 #5

Updated by Amal Siby about 2 years ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 40 to 60

coding Completed.

Print info not Done.

QuoteActions
Copy link
 #6

Updated by Amal Cyriac about 2 years ago

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

ISSUE FOUND *****
1.Fix bugs on Bank Currency-ROE
(Not showing ROE input box)
2.Set an Alert for add Credit & Debit Amount
3.Fix error while save

P0001: jsnSqlRes: {"sinSqlCustomStatus" : -1, "strSqlCustomStatusCode" : "ERROR", "strSqlCustomMessage" : "Bank Transfer Save Failed", "strSqlCustomErrorType" : "DATABASE_SYSTEM_ERROR", "strSqlCustomErrorCode" : null, "strSqlSysMessage" : "invalid transaction termination", "strSqlSysExceptionDetail" : "", "strSqlSysExceptionHint" : "PL/pgSQL function sp_insert_or_update_bank_transfer_base(jsonb) line 146 at ROLLBACK\nSQL statement \"CALL sp_insert_or_update_bank_transfer_base(jsnDocument, jsnSpOutRes)\"\nPL/pgSQL function sp_insert_or_update_bank_transfer(jsonb,jsonb[]) line 54 at CALL", "binSqlPk" : 27, "binSqlLogPk" : 0, "strSqlDocNo" : null, "dctSqlOtherData" : {"binDocumentId": "27", "strDocumentNo": "IT/001", "binBankTransferId": null}}
QuoteActions
Copy link
 #7

Updated by Amal Siby almost 2 years ago

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

Bug Fixed -(1.Fix bugs on Bank Currency-ROE
(Not showing ROE input box)
2.Set an Alert for add Credit & Debit Amount
3.Fix error while save)

Print info not Done. On hold

QuoteActions
Copy link
 #8

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.Set proper validations on ROE
(Debit & credit amount should be tally)
2.fix errors on currency
(Unable to cast object of type 'System.DBNull' to type 'System.String'.)
3.Add precision on amount

QuoteActions
Copy link
 #9

Updated by Amal Siby almost 2 years ago

Bug fixed.

Actions
Copy link
 #10

Updated by Amal Siby almost 2 years ago

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

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 bugs on Attachment popup
(Prevent close without tap on Close button)

Actions
Copy link
 #12

Updated by Amal Siby almost 2 years ago

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

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.Prevent save/update when Debit & Credit are not tally
2.Fix bug on bank currency
(Selected currency automatically change to default )
3.Set proper alignment between code & name
(Selection box)

QuoteActions
Copy link
 #14

Updated by Amal Siby almost 2 years ago

Bug Fixed.

Actions
Copy link
 #15

Updated by Amal Siby almost 2 years ago

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

Updated by Amal Cyriac almost 2 years ago

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

ISSUE FOUND *****
1.Fix bugs on check box after update - Set validation
2.Fix error on ROE - Displaying wrong value
3.Precision missing while update
4.fix bugs on posting - Cr/Dr are incorect
5.Set precision on Amount in QAR column

QuoteActions
Copy link
 #17

Updated by Amal Siby almost 2 years ago

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

Bug Fixed.

QuoteActions
Copy link
 #18

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.Set proper validations on inline check box
(Branch/Department changing on update)
2.Currency not showing on document search
3.Fix bugs on Bank charge
( Amounts changing while currency change)

QuoteActions
Copy link
 #19

Updated by Amal Siby almost 2 years ago

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

Bug Fixed.

QuoteActions
Copy link
 #20

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.POP UP SHOWING AMOUNT NOT TALLY WHILE CHANGING BRANCH,DEPARTMENT TO WITH QAR,USD

Actions
Copy link
 #21

Updated by Amal Siby over 1 year ago

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

Updated by unnikannan S over 1 year ago

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

ISSUE FOUNDED

1.RE-DIRECT ISSUE FROM OTHER MODULES
2.ADD INFO POP UP AS (BLUE)
3.CHANGE APPROVED BT:TO BY:
4.ADD MANDATORY FIELD IN DOC AND POSTING STATUS
5.MISSING RESPONSIBLE USER ADDING BOX AFTER SAVE

QuoteActions
Copy link
 #23

Updated by Amal Siby over 1 year ago

Reported Bug fixed

Actions
Copy link
 #24

Updated by Amal Siby over 1 year ago

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

Updated by unnikannan S over 1 year ago

TESTING DONE

QuoteActions
Copy link
 #26

Updated by unnikannan S over 1 year ago

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

ISSUE FOUNDED

1.ERROR WHILE DLETING DOCUMENT SHOWING (42883: procedure sp_delete_document(bigint, integer, bigint, character varying[], unknown) does not exist)
2.CHANGE THE POSITION OF NARRATION FIELD UNDER DOC AND POST STATUS

Actions
Copy link
 #27

Updated by Amal Siby over 1 year ago

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

Updated by unnikannan S over 1 year ago

TESTING DONE

Actions
Copy link
 #29

Updated by Junaid M 11 months ago

  • Assignee changed from Amal Siby to Vivekp V
Actions
Copy link
 #30

Updated by unnikannan S 6 months ago

  • Status changed from Reopen Bugs Coding Done to Testing Done
  • % Done changed from 70 to 90
QuoteActions
Copy link
 #31

Updated by Anil KV 5 months ago

Posting DONE

Outward Bank Transfer/Deposit Charge(PV) - Service Tax GUI - Inclusive Case also consider
* NEED Inclusive Tax, Actual Bank Charge, Tax, Tax % etc in GUI[like RV or PV]

Bank Charge posting
------------------
From Bank Ac Cr (Amount + Bank Charge + Tax)

To Bank Ac Dr (Amount)

Outward Bank Charge Account(Mapping) Dr (Charge(Not Inclusive Tax) + Tax)
* Opposite Ledger = To Bank
*jsnRelatedData = {'TYPE':'BANK TRANSFER',
                              'NO' : DOC NO,
                              'BASE_AMOUNT' : Bank Cr Amount,
                              'CHARGE_PERC': Bank Charge %,
                              'CHARGE_AMOUNT' : Amount}
Tax
======
Billing Tax Receivable Control Account(Input) Dr (TAX)

*jsnRelatedData = {'TYPE': 'PAYMENT',
                              'NO' : DOC NO,
                              'TAX_BASE': Bank Charge,
                              'TAX_PERC': Tax %,
                              'TAX_AMT': Tax}

Actions
Copy link
 #32

Updated by Junaid M 5 months ago

  • Status changed from Testing Done to New Changes
  • % Done changed from 90 to 50
Actions
Copy link
 #33

Updated by Vivekp V 5 months ago

  • Status changed from New Changes to New Changes Coding Done
  • % Done changed from 50 to 70
Actions
Copy link
 #34

Updated by unnikannan S 4 months ago

  • Status changed from New Changes Coding Done to Reopen Bugs Testing Done
  • % Done changed from 70 to 90
QuoteActions
Copy link
 #35

Updated by Arathy PS 4 months ago

  • Status changed from Reopen Bugs Testing Done to New Changes
  • % Done changed from 90 to 50

NEW CHANGES DONE
-------------------------------------
1. Add against doc field on credit side after bank charge.

Actions
Copy link
 #36

Updated by Vivekp V 4 months ago

  • Status changed from New Changes to New Changes Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #37

Updated by Arathy PS 5 days ago

  • Status changed from New Changes Coding Done to New Changes
  • Assignee changed from Vivekp V to Sreeranjini T
  • % Done changed from 70 to 50

Set Document Id in Posting - Fixed

Eg:

mdlTransaction.binDocumentId = mdlReceiptDocument.binDocumentId; // 1st time, Set From Procedure
mdlTransaction.binSubDocId = mdlReceiptDocument.binDocumentId; // 1st time, Set From Procedure

Actions
Copy link
 #38

Updated by Sreeranjini T 1 day ago

  • Status changed from New Changes to New Changes Coding Done
  • % Done changed from 50 to 70
Edit Copy Actions
Copy link

Also available in: Atom PDF