Project

General

Profile

Edit Copy Actions

Feature #390

open

Corporate Receipt

Added by Junaid M 5 months ago. Updated 3 months ago.

Status:
Coding Done
Priority:
Normal
Target version:
Start date:
10/17/2024
Due date:
% Done:

60%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Corporate Receipt
Tested By:
Code Reviewed By:

Description

Coding Corporate Receipt


Add

Subtasks


Add

Related issues

Actions #1

Updated by Junaid M 5 months ago

  • Assignee set to travvise Admin

Updated by Arathy PS 4 months ago

GUI CHANGE
--------------------------------
1. Add a new label Approval status (blue star): empty, approved --- > at original receipt no: place (move it to right)
2. Add title 'approval done from agency side'
3.Status:- [Use same value same as document approval]
Need Agency Approve
Agency Approved
Rejected

Db Implimentation:
1. Create new flat table for temporary storage.

Actions #3

Updated by Anil KV 3 months ago

  • Status changed from New to Ready for Coding
  • Assignee changed from travvise Admin to Shilpa Pavithran
  • % Done changed from 0 to 20

Updated by Anil KV 3 months ago

Tables:-

CREATE TABLE corporate.tbl_corporate_receipt (
pk_corporate_receipt_id BIGSERIAL PRIMARY KEY,
fk_documents_id BIGINT NOT NULL REFERENCES document.tbl_documents(pk_documents_id),

--Master
vhr_payee_name VARCHAR(200) DEFAULT '',
vhr_payee_contact VARCHAR(200) DEFAULT '',
--Mode
fk_dr_account_id BIGINT NOT NULL REFERENCES accounts.tbl_account(pk_account_id),
sin_mod_of_receipt_type SMALLINT NOT NULL,-- check receipt.tbl_mod_of_receipt
vhr_reference VARCHAR(100),
jsn_mode_details JSON, --*2 Cheque, Card, etc data -> all keys enter below
vhr_ledg_dr_currency VARCHAR(3) NOT NULL,
dbl_ledg_dr_cur_roe DOUBLE PRECISION DEFAULT 1.00,
dbl_ledg_dr_cur_amount DOUBLE PRECISION DEFAULT 0.0,
dbl_ledg_dr_cur_bank_charge DOUBLE PRECISION DEFAULT 0.0,
vhr_base_dr_currency VARCHAR(3) NOT NULL,
dbl_base_dr_cur_amount DOUBLE PRECISION DEFAULT 0.0,
dbl_base_dr_cur_bank_charge DOUBLE PRECISION DEFAULT 0.0,
--Party
fk_cr_main_ledger_id BIGINT NOT NULL REFERENCES accounts.tbl_chart_of_ac(pk_chart_of_ac_id),
fk_cr_customer_id BIGINT NOT NULL REFERENCES accounts.tbl_account(pk_account_id),
fk_cr_sub_customer_id BIGINT NULL,
fk_sub_ledger_id BIGINT REFERENCES accounts.tbl_sub_ledger(pk_sub_ledger_id),
fk_actual_customer_ac_id BIGINT NULL REFERENCES accounts.tbl_account(pk_account_id),--*4
vhr_ledg_cr_currency VARCHAR(3) NOT NULL,
dbl_ledg_cr_cur_roe DOUBLE PRECISION DEFAULT 1.00,
dbl_ledg_cr_cur_amount DOUBLE PRECISION DEFAULT 0.0,
vhr_base_cr_currency VARCHAR(3) NOT NULL,
dbl_base_cr_cur_amount DOUBLE PRECISION DEFAULT 0.0,
-- Receipt Approve
vhr_original_receipt_no VARCHAR(30) NOT NULL,
fk_approve_user_id BIGINT NULL REFERENCES authentication.tbl_user(pk_user_id),
dtm_approval TIMESTAMP WITH TIME ZONE,
txt_approval_remarks TEXT DEFAULT '',
sin_approval_status SMALLINT DEFAULT 1--*1

);

receipt.tbl_receipt_master->vhr_corporate_receipt_no

--Note: Approve Mandatory via corporate_receipt_approve
-- Approve then create a Receipt
-- Approve the kep the table last section and document.tbl_doc_approve_log
-- Approved then donot delete the Doc

Actions #5

Updated by Shilpa Pavithran 3 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions #6

Updated by Shilpa Pavithran 3 months ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60
Edit Copy Actions

Also available in: Atom PDF