Project

General

Custom queries

Profile

Edit Copy Actions
Copy link

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:
Nawal Sidique
Target version:
22.12
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:
Quote

Description

Coding Assets Import

Add

Subtasks

Add

Related issues

Actions
Copy link
 #1

Updated by Junaid M about 1 year ago

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

Updated by Anonymous 9 months ago

  • Assignee changed from Nithin Raj to travvise Admin
QuoteActions
Copy link
 #3

Updated by Anil KV 7 months ago

GUI Change

-> Add Current Assets Status column

Actions
Copy link
 #4

Updated by Anil KV 7 months ago

  • Status changed from New to Ready for Coding
  • % Done changed from 0 to 20
QuoteActions
Copy link
 #5

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

QuoteActions
Copy link
 #6

Updated by Anil KV 7 months ago

Posting

->

Actions
Copy link
 #7

Updated by Junaid M 7 months ago

  • Assignee changed from travvise Admin to Nithin PM
QuoteActions
Copy link
 #8

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
QuoteActions
Copy link
 #9

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
Copy link
 #10

Updated by Nithin PM 6 months ago

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

Updated by Nithin PM 4 months ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60
QuoteActions
Copy link
 #12

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
Copy link
 #13

Updated by Arathy PS 4 months ago

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

Updated by Augustin Jose 3 months ago

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

Updated by Arathy PS 13 days ago

  • Assignee changed from Augustin Jose to Nawal Sidique
QuoteActions
Copy link
 #16

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
Copy link
 #17

Updated by Arathy PS 13 days ago

  • Status changed from Reopen Bugs to New Changes
Actions
Copy link
 #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
Copy link

Also available in: Atom PDF