Project

General

Custom queries

Profile

Edit Copy Actions

Feature #308

open

Assets Import

Added by Junaid M about 1 year ago. Updated 8 days ago.

Status:
New Changes Coding Done
Priority:
Normal
Assignee:
Target version:
Start date:
02/14/2024
Due date:
% Done:

70%

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

Description

Coding Assets Import


Add

Subtasks


Add

Related issues

Actions #1

Updated by Junaid M about 1 year ago

  • Assignee changed from travvise Admin to Nithin Raj
Actions #2

Updated by Anonymous 9 months ago

  • Assignee changed from Nithin Raj to travvise Admin

Updated by Anil KV 7 months ago

GUI Change

-> Add Current Assets Status column

Actions #4

Updated by Anil KV 7 months ago

  • Status changed from New to Ready for Coding
  • % Done changed from 0 to 20

Updated by Anil KV 7 months ago

Workflow

->The item not in Assets Master then add
-then create assets purchase import
-Fields missing then discus and Add

Updated by Anil KV 7 months ago

Posting

->

Actions #7

Updated by Junaid M 7 months ago

  • Assignee changed from travvise Admin to Nithin PM

Updated by Anil KV 7 months ago

Document No(Master)
Date(Master)
Purchase Date*
Branch(Master)
Department(Master)
Assets Code*    
Assets Name    
Item Code*    
Item Name*
Supplier/FOP Code(Master)*
Supplier/FOP Name(Master)
Bill Number(Master)    
Reference(Master)    
Narration(Master)
Note(Master)
Depreciation %
Last Depreciation Date    
Particulars    
Reference
Transaction Currency
ROE
Transaction Purchase Amount
Transaction Total Depreciation Amount
Transaction Current Asset Value    
Base Purchase Amount
Base Total Depreciation Amount
Base Current Asset Value    

Calculation:-
================
dbl_ledg_cur_price = Transaction Purchase Amount
dbl_ledg_cur_input_amount = Transaction Purchase Amount
dbl_ledg_cur_vat = 0
dbl_ledg_cur_deduction = 0
dbl_ledg_cur_extra_pay = 0
dbl_ledg_cur_purchase_amount = Transaction Purchase Amount
dbl_ledg_cur_depreciation_start_amount = Transaction Purchase Amount
dbl_ledg_cur_imported_depreciation = Transaction Total Depreciation Amount
dbl_ledg_cur_sys_depreciation = 0
dbl_ledg_cur_sales_retrun_deduction = 0

Updated by Anil KV 7 months ago

Document No(Master)
Date(Master)
Purchase Date*
Branch(Master)
Department(Master)
Assets Code*    
Assets Name    
Item Code*    
Item Name*
Supplier/FOP Code(Master)*
Supplier/FOP Name(Master)
Bill Number(Master)    
Reference(Master)    
Narration(Master)
Note(Master)
Depreciation %
Last Depreciation Date    
Particulars    
Reference
Transaction Currency
ROE
Transaction Purchase Amount
Transaction Total Depreciation Amount
Transaction Current Asset Value    
Base Purchase Amount
Base Total Depreciation Amount
Base Current Asset Value    

Calculation:-
================
dbl_ledg_cur_price = Transaction Purchase Amount
dbl_ledg_cur_input_amount = Transaction Purchase Amount
dbl_ledg_cur_vat = 0
dbl_ledg_cur_deduction = 0
dbl_ledg_cur_extra_pay = 0
dbl_ledg_cur_purchase_amount = Transaction Purchase Amount
dbl_ledg_cur_depreciation_start_amount = Transaction Purchase Amount
dbl_ledg_cur_imported_depreciation = Transaction Total Depreciation Amount
dbl_ledg_cur_sys_depreciation = 0
dbl_ledg_cur_sales_retrun_deduction = 0
Actions #10

Updated by Nithin PM 6 months ago

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

Updated by Nithin PM 4 months ago

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

Updated by Arathy PS 4 months ago

  • Status changed from Coding Done to New Changes
  • % Done changed from 60 to 50

NEW CHANGES
---------------------------------------------
1. Add a new save settings button on the properties grid. (refer journal import)

Actions #13

Updated by Arathy PS 4 months ago

  • Assignee changed from Nithin PM to Augustin Jose
Actions #14

Updated by Augustin Jose 4 months ago

  • Status changed from New Changes to New Changes Coding Done
  • % Done changed from 50 to 70
Actions #15

Updated by Arathy PS 13 days ago

  • Assignee changed from Augustin Jose to Nawal Sidique

Updated by Arathy PS 13 days ago

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

NEW CHANGES - DONE
----------------------
Discuss with anil whether the Import need first two requirements fields,
1. Code and name in same column in excel file :
A checkbox Code and name in same column
Give same column no: for both code and name and if the check box is ticked then an entry box: Split character.
Add tooltip to the fields.

2. If the code is not auto generated and no code in excel file then a check box, No code-- if the check box is ticked then an entry box: code character
add title to the fields.

3. The default action type should be: Remove all and insert.

Actions #17

Updated by Arathy PS 13 days ago

  • Status changed from Reopen Bugs to New Changes
Actions #18

Updated by Nawal Sidique 8 days ago

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

Also available in: Atom PDF