Landed cost
About Landed Cost
Landed cost is the total price of a product once it has arrived at a buyer's door. The landed cost includes the original price of the product, all transportation fees (both inland and ocean), customs, duties, taxes, insurance, currency conversion, crating, payment fees, and handling. Advanced Inventory provides a mobile app solution to facilitate the Landed Cost process through a hand held mobile device. The Advanced Inventory app is integrated to work with the NetSuite landed cost system. No custom records were created to support this feature.
[Body Empty]
Environment Considerations
To ensure optimal communication between the NetSuite interface and the Advanced Inventory app, refer to the following recommendations for the Landed Cost feature.
Data Set Up
Customs, duties, taxes, insurance, currency conversion and additional fees, must be input into NetSuite.
Receive a purchase order using Landed Cost
Landed cost is a subrecord, separate from the item details subrecord. To set Landed Cost, use the subrecord object inside the line or the lines array. The following example demonstrates the use of only nvpair to set line columns.
Example Using DSI_TransactionTransform
{
"transform": [{
"mc_user": "johnny.bravo@dsiglobal.com",
"fromrecordtype": "purchaseorder",
"fromrecordid": "42160",
"torecordtype": "itemreceipt",
"tolocation": "",
"location": "2",
"pps": "",
"sourcefields": [{
"fieldid": "",
"value": ""
}],
"targetfields": [{
"fieldid": "landedcostperline",
"value": "T"
}],
"sublists": [{
"sublistid": "item",
"lines": [{
"linenum": "",
"nvpair": [{
"columnid": "item",
"value": "979"
},{
"columnid": "quantity",
"value": "1"
}],
"subrecord": {
"subrecordid":"landedcost",
"nvpair": [{
"columnid": "",
"value": ""
}],
"sublists": [{
"sublistid": "landedcostdata",
"lines":[{
"linenum": "NEW",
"nvpair": [{
"columnid": "costcategory",
"value": "1"
},{
"columnid": "amount",
"value": "5.00"
}]
},{
"linenum": "NEW",
"nvpair": [{
"columnid": "costcategory",
"value": "2"
},{
"columnid": "amount",
"value": "7.89"
}]
}]
}]
}
},{
"linenum": "",
"nvpair": [{
"columnid": "item",
"value": "977"
},{
columnid": "quantity",
"value": "1"
}],
"subrecord": {
"subrecordid":"landedcost",
"nvpair": [{
"columnid": "",
"value": ""
}],
"sublists": [{
"sublistid": "landedcostdata",
"lines":[{
"linenum": "NEW",
"nvpair": [{
"columnid": "costcategory",
"value": "1"
},{
"columnid": "amount",
"value": "15.00"
}]
},{
"linenum": "NEW",
"nvpair": [{
"columnid": "costcategory",
"value": "2"
},{
"columnid": "amount",
"value": "17.89"
}]
}]
}]
}
}]
}]
}]
}
Loading...
There was a problem loading this topic