Fixed assets
About Fixed Assets
The Fixed Asset Management process provides automated management of fixed asset acquisition, depreciation, revaluation and retirement, as well as maintenance schedules and insurance. Advanced Inventory provides a mobile app solution to facilitate the Fixed Asset Management process through a hand held mobile device. The Advanced Inventory app is integrated to work with the NetSuite Fixed Asset functions.
Functional process
In NetSuite, Fixed Asset Management is a process used to import new assets and mid-life assets to track asset depreciation. Fixed assets, as opposed to current assets, are assets with a remaining useful life of over a year.
Environment Recommendations
The following list provides recommendations that should be addressed when implementing the Fixed Assets RESTlet.
-
Asset ledger accounts should be clearly defined.
-
Assets should be categorized into asset types in setup.
About creating Fixed Asset records
All Fixed Asset functions require the Enhance Permission role which has the extra custom record permissions.
The following Fixed Asset transactions can be configured for a hand held device.
-
Create Asset Type
-
Create Asset Record Manually
-
Create Asset Record from Proposal for Purchase Order
-
Update/Edit Asset Record Manually
-
Asset Split
Create Asset Type
Use the example below to create an Asset Type record.
Example Using DSI_RecordCreate
{
"recordcategory": "custom",
"create": [{
"mc_user": "River.Tamm@dsiglobal.com",
"recordtype": "customrecord_ncfar_assettype",
"targetfields": [{
"fieldid": "name",
"value": "Atmosphere"
},{
"fieldid": "custrecord_assettypedescription",
"value": "Air"
},{
"fieldid": "custrecord_assettypeaccmethod",
"value": "2"
},{
"fieldid": "custrecord_assettyperesidperc",
"value": "50"
},{
"fieldid": "custrecord_assettypelifetime",
"value": "12"
},{
"fieldid": "custrecord_assettypedepractive",
"value": "2"
},{
"fieldid": "custrecord_assettyperevisionrules",
"value": "2"
},{
"fieldid": "custrecord_assettypedeprrules",
"value": "1"
},{
"fieldid": "custrecord_assettypedeprperiod",
"value": "1"
}]
}]
} Create Asset Record Manually
Use the following example to create an Asset Record Manually transaction.
Example Using DSI_RecordCreate
{
"recordcategory": "custom",
"create": [{
"mc_user": "Kaylee.Frye@dsiglobal.com",
"recordtype": "customrecord_ncfar_asset",
"targetfields": [{
"fieldid": "altname",
"value": "Nitrogen"
},{
"fieldid": "custrecord_assettype",
"value": "6"
},{
"fieldid": "custrecord_assetdescr",
"value": "78% of atmosphere"
},{
"fieldid": "custrecord_assetdeprperiod",
"value": "1"
},{
"fieldid": "custrecord_assetcost",
"value": "500"
},{
"fieldid": "custrecord_assetresidualvalue",
"value": "250"
},{
"fieldid": "custrecord_assetaccmethod",
"value": "3"
},{
"fieldid": "custrecord_assettyperevisionrules",
"value": "2"
},{
"fieldid": "custrecord_assetlifetime",
"value": "60"
}]
}]
} Create Asset Proposal for PO
Use the following example to create an Asset Proposal for PO transaction.
Example Using DSI_RecordCreate
{
"recordcategory": "custom",
"create": [{
"mc_user": "Malcolm.Reynolds@dsiglobal.com",
"recordtype": "customrecord_ncfar_assetproposal",
"targetfields": [{
"fieldid": "altname",
"value": "Nitrogen"
},{
"fieldid": "custrecord_propassettype",
"value": "6"
},{
"fieldid": "custrecord_propstatus",
"value": "1"
},{
"fieldid": "custrecord_propassetdescr",
"value": "Office Air"
},{
"fieldid": "custrecord_propassetlifetime",
"value": "60"
},{
"fieldid": "custrecord_assetresidualvalue",
"value": "250"
},{
"fieldid": "custrecord_propsubsidiary",
"value": "3"
},{
"fieldid": "custrecord_proplocation",
"value": "6"
},{
"fieldid": "custrecord_propdeprperiod",
"value": "1"
},{
"fieldid": "custrecord_assetlifetime",
"value": "60"
},{
"fieldid": "custrecord_proppurchaseorder",
"value": "40651"
},{
"fieldid": "custrecord_propmainacc",
"value": "16"
},{
"fieldid": "custrecord_propdepracc",
"value": "19"
}]
}]
} Update or Edit Asset Record Manually
Use the following example to create an Update/Edit Asset Record Manually transaction.
Example Using DSI_RecordUpdate
{
"internalid": "155",
"recordtype": "customrecord_ncfar_asset",
"mc_user": "Zoe.Washburne@dsiglobal.com",
"updatefields": [{
"fieldid": "custrecord_assetdescr",
"newvalue": "77.95% of atmosphere"
},{
"fieldid": "custrecord_assetcost",
"newvalue": "555.95"
}]
} Asset Split
To split an asset into two assets, simply update the quantity of the existing asset, then create a new asset with the difference in quantity. In this example, asset 158 had 10 quantity. At the end asset 158 has 8 quantity and asset 159 has 2 quantity.
Example Using DSI_RecordUpdate
{
"internalid": "158",
"recordtype": "customrecord_ncfar_asset",
"mc_user": "Simon.Tamm@dsiglobal.com",
"updatefields": [{
"fieldid": "custrecord_ncfar_quantity",
"newvalue": "8"
}]
} Example Using DSI_RecordCreate
{
"recordcategory": "custom",
"create": [{
"mc_user": "Simon.Tamm@dsiglobal.com",
"recordtype": "customrecord_ncfar_asset",
"targetfields": [{
"fieldid": "altname",
"value": "Carbon Dioxide 2"
},{
"fieldid": "custrecord_ncfar_quantity",
"value": "2"
},{
"fieldid": "custrecord_assettype",
"value": "6"
},{
"fieldid": "custrecord_assetdescr",
"value": "0.1% of atmosphere"
},{
"fieldid": "custrecord_assetdeprperiod",
"value": "1"
},{
"fieldid": "custrecord_assetcost",
"value": "0.72"
},{
"fieldid": "custrecord_assetresidualvalue",
"value": "0"
},{
"fieldid": "custrecord_assetaccmethod",
"value": "2"
},{
"fieldid": "custrecord_assetlifetime",
"value": "600"
}]
}]
}
Loading...
There was a problem loading this topic