Project

General

Profile

Edit Copy Actions
Copy link

Feature #171

open

ADM/ACM Adjustment

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

Status:
New Changes Coding Done
Priority:
Normal
Assignee:
Greeshma S
Target version:
22.12
Start date:
07/20/2023
Due date:
% Done:

70%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
ADM/ACM Adjustment
Tested By:
unnikannan S
Code Reviewed By:
Quote

Description

Coding ADM/ACM Adjustment

Files

Download all files
clipboard-202407131328-ymecu.png (120 KB) clipboard-202407131328-ymecu.png unnikannan S, 07/13/2024 01:28 PM
clipboard-202410251747-quxnw.png (157 KB) clipboard-202410251747-quxnw.png unnikannan S, 10/25/2024 05:47 PM
Add

Subtasks

Add

Related issues

QuoteActions
Copy link
 #1

Updated by Anil KV almost 2 years ago

ADM/ACM Adjustment GUI Changes
-------------------------

-> Date Mandatory
-> Department Mandatory
-> Type Mandatory
-> Add Document Status like Posting status - before posting status
-> Add - File No, Enquiry No - like Receipt
-> Add attachment and Print buttons
-> Party Section
- Account Mandatory
- Amount Mandatory
-> In List
- Width reset - based on data
- Add Profit:0.00 in Grid Title
- Remove Account column
- Adjustment Amount Column Editable
- Last Colun - Delete and View Details Icon
-> Search Popup
-  Remove Adjustment Party, Settlement, Batch No
- Add ~ in last - Doc No, Ticket No
- ADM, ACM Check box Disable - Tick based on Master Type
- increase height - List
- Add Search button top Right
- ADM Unadjusted, ACM Unadjusted Account(Based on check box) outstanding > 0 records only

Actions
Copy link
 #2

Updated by Anil KV over 1 year ago

  • Assignee changed from Junaid M to travvise Admin
QuoteActions
Copy link
 #3

Updated by Anil KV over 1 year ago

Select SQL

SELECT tr.pk_transaction_id,
       tr.fk_branch_id,
       tr.fk_department_id,
       tr.fk_ledger_id,
       tr.dat_transaction,
       tr.vhr_ledg_currency,
       tr.dbl_ledg_cur_roe,
       tr.dbl_ledg_cur_debit,
       tr.dbl_ledg_cur_credit,
       tr.dbl_ledg_cur_outstanding,
       tr.vhr_base_currency,
       tr.dbl_base_cur_debit,
       tr.dbl_base_cur_credit,
       tr.dbl_base_cur_outstanding,
       tr.vhr_cons_currency,
       tr.dbl_cons_cur_roe,
       tr.dbl_cons_cur_debit,
       tr.dbl_cons_cur_credit,
       tr.dbl_cons_cur_outstanding,
       tr.vhr_reference,
       tr.txt_narration,
       doc.pk_documents_id,
       doc.vhr_document_no
FROM transaction.tbl_transaction tr
     LEFT JOIN document.tbl_documents AS doc
        ON doc.pk_documents_id= tr.fk_documents_id
WHERE tr.sin_posting_status = 1
    AND tr.sin_document_status = 1
    AND tr.sin_transaction_status = 1
    AND dbl_ledg_cur_outstanding > 0
ORDER BY tr.dat_transaction

tr.sin_record_type = 42 -- ADM 
tr.sin_record_type = 43 -- ACM 
42 = ADM Unadjusted
43 = ACM Unadjusted
Actions
Copy link
 #4

Updated by Junaid M over 1 year ago

  • Assignee changed from travvise Admin to Aparna Mathew
Actions
Copy link
 #5

Updated by Aparna Mathew over 1 year ago

  • Status changed from New to Coding Started
  • Start date changed from 02/25/2023 to 07/20/2023
  • % Done changed from 0 to 40
Actions
Copy link
 #6

Updated by Aparna Mathew over 1 year ago

  • Status changed from Coding Started to Particialy Coding Done
Actions
Copy link
 #7

Updated by Aparna Mathew over 1 year ago

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

Updated by Seema Mathew over 1 year ago

  • Status changed from Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to Seema Mathew

ISSUE FOUNDED

1.NOT SHOWING MAIN LEDGER IN ACCOUNTS
2.ERROR WHILE SAVE (Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index')

Actions
Copy link
 #9

Updated by Aparna Mathew over 1 year ago

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

Updated by Seema Mathew over 1 year ago

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

ISSUE FOUNDED-

1.SHOWING ERROR WHILE ADDING ADM/ACM ADJUSTMENT

QuoteActions
Copy link
 #11

Updated by unnikannan S over 1 year ago

ISSUE FOUNDED

1.ADD ACT US CLIENT ACCOUNTS WHILE CHOOSING CUSTOMER

Actions
Copy link
 #12

Updated by Aparna Mathew over 1 year ago

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

Updated by unnikannan S over 1 year ago

TESTING DONE

QuoteActions
Copy link
 #14

Updated by Seema Mathew over 1 year ago

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

ISSUE FOUNDED****

1.WHILE ADDING REMARK DEFAULT ITS COME TO REFERENCE NUMBER
2.CALCULATION ERROR IN ADM/ACM ADJUSTMENT

QuoteActions
Copy link
 #15

Updated by unnikannan S over 1 year ago

Seema Mathew wrote in #note-14:

ISSUE FOUNDED****

1.WHILE ADDING REMARK DEFAULT ITS COME TO REFERENCE NUMBER
2.ERROR WHILE ADDING ADM/ACM ADJUSTMENT

Actions
Copy link
 #16

Updated by Aparna Mathew over 1 year ago

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

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 Seema Mathew to unnikannan S

ISSUE FOUNDED

1.CHANGE IN CUURENCY CODE AFTER SAVE AND ADDING THE DOC NO
2.ADD COA ACCOUNTS IN PROFIT,LOSS TAB

Actions
Copy link
 #18

Updated by Aparna Mathew over 1 year ago

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

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.ADD IN GRID CODE LOCATION = CENTRE

Actions
Copy link
 #20

Updated by Aparna Mathew over 1 year ago

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

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.CONSIDER MATCHED AMOUNT IN LIST
2.DEFAULT CURRENCY AS QAR

Actions
Copy link
 #22

Updated by Aparna Mathew about 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #23

Updated by unnikannan S about 1 year ago

TESTING DONE

QuoteActions
Copy link
 #24

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.BLOCKING DELETION
2.ADJUST GAP BETWEEN REDSTAR AND AMOUNT

Actions
Copy link
 #25

Updated by Aparna Mathew 12 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #26

Updated by unnikannan S 11 months ago

TESTING DONE

QuoteActions
Copy link
 #27

Updated by unnikannan S 11 months ago

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

ISSUE FOUNDED

1.Error While Loading Saved Data (42703: column tf.int_record_ref_doc_sequence_no does not exist)

Actions
Copy link
 #28

Updated by Aparna Mathew 11 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #29

Updated by unnikannan S 9 months ago

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

ISSUE FOUNDED

1.Add Validation For Doc Date

Actions
Copy link
 #30

Updated by Aparna Mathew 9 months ago

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

Updated by unnikannan S 9 months ago

TESTING DONE

Actions
Copy link
 #32

Updated by unnikannan S 8 months ago

Actions
Copy link
 #33

Updated by Aparna Mathew 6 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #34

Updated by unnikannan S 5 months ago

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

ISSUE FOUNDED

1.Error While Loading Already Saved Doc

Actions
Copy link
 #36

Updated by Aparna Mathew 5 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Actions
Copy link
 #37

Updated by unnikannan S 5 months ago

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

Updated by Arathy PS 3 months ago

  • Assignee changed from Aparna Mathew to Greeshma S
QuoteActions
Copy link
 #39

Updated by Arathy PS 5 days ago

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

Set Document Id in Posting

Eg:

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

Actions
Copy link
 #40

Updated by Greeshma S 5 days 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