Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	ecdb5e56-0e2c-3e03-a39a-d088ee783b83
key	FA-213

Jira

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	ecdb5e56-0e2c-3e03-a39a-d088ee783b83
key	FA-201

View file

name	AM-95153.csv
height	250

Sample CSV Template for Importing (exported file )

Image RemovedImage Added

Import screen for Fixed Asset.

Columns

#	Letter	Column	Sample values	Image Added
1	A	Asset Description	Duplicate (1) of AM-83
2	B	Company Location	MuddyRun
3	C	Serial Number	12345
4	D	Notes
5	E	Date Acquired *	05/19/2020
6	F	Date In Service *	05/19/2020
7	G	Depreciation Method Id	AM-47DM
8	H	Cost *	1000
9	I	Forex Rate	1
10	J	Currency *	USD
11	K	Market Value	0
12	L	Insurance Value	0
13	M	Salvage Value *	500
14	N	Basis Description
15	O	Disposition Number
16	P	Disposition Amount	0
17	Q	Pool Id
18	R	Accuitent	0
19	S	Manufacturer Name
20	T	Model Number
21	U	Asset Account Id	11015-00-00
22	V	Expense Account Id	11050-00-00
23	W	Depreciation Account Id	11100-00-00
24	X	Accumulated Account Id	11375-00-01
25	Y	Gain Loss Account Id	11375-00-02
26	Z	Imported Dep Thru	11/16/2020 12:00:00 AM
27	AA	Import GAAP Dep To Date	150
28	AB	Import Tax Dep To Date

Image Removed

	Column	Comment
	Imported Dep Thru	Added 5/25/2021 for importing
	Import Dep To Date	Added 5/25/2021 for importing
	Asset Description
	Company Location
	Serial Number
	Notes
	Date Acquired *
	Date In Service *
	Cost *
	Currency *
	Market Value
	Insurance Value
	Salvage Value *
	Basis Description
	Disposition Number
	Disposition Amount
	Pool Id
	Accuitent
	Manufacturer Name
	Model Number
	Asset Account Id
	Expense Account Id
	Depreciation Account Id
	Accumulated Account Id
	Gain Loss Account Id

...