This proposal covers the scope of adding Volume as a Cost Allocation Method for the Landed Cost feature to the Netsuite Production account. By standard cost allocation method for volume is not available.

FEN-27

Requirement

Fenetti needs to include Landed Cost with the Cost allocation method: “Volume”, which will eventually split the costs to the items based on the volume (fetched from ‘VOLUME CBM‘, Field ID: custitem_fenetti_volume  in the item record) occupied in the shipping carrier.

Our Solution

We will be creating a checkbox ‘Cost Allocation based on Volume’ in the body level, and if this checkbox is checked then you can enter the Landed cost details in the custom sublist created- ‘Landed Cost- Volume’ (Basically a custom record) in the  Item Receipt and Bill. Also, using the script we will be checking the checkbox: ‘landed cost per line’ when the user ticks the checkbox ‘Cost Allocation based on Volume’.

NOTE: The ‘Landed Cost per Line’ field can only be changed on new transactions. Once checked, it cannot be changed.

In the ‘Landed Cost- Volume’ sublist, you can select the cost categories and enter corresponding Landed Cost, and by selecting the ‘Transaction’, it will automatically set the ‘Total’ (amount) from the selected transaction. If you want to add the cost manually, then leave the ‘Transaction’ field blank or you can overwrite the landed cost amount that is auto-populated.

Three fields are available in the ‘Landed Cost- Volume’ sublist: Cost Category, Landed Cost, and Transaction will be available to enter Landed Cost on the basis of Volume. This sublist is editable at any time.

By using the script we will be setting these values to the standard landed cost box in the item sublist upon the ‘Save’ of the Item Receipt/Bill and through which the item cost calculations are executed by the Netsuite itself in the item record. The values set in this box (item wise) will be based on the volume, 

Allocated cost per item = (Volume of Item / Total Volume of Eligible Items) x Total Landed Cost

If the item has no Volume entered in the line level of the Item Receipt, NetSuite displays an error message upon save of the item receipt/Bill. This will be applicable for the transactions created via UI only.

The value set in the landed cost box will upon the ‘Save’ of the Item Receipt/Bill.  So upon the creation, the standard landed cost box will be set based on the values in the ‘Landed Cost- Volume’ sublist.

So after the creation, the user can edit the Item Receipt/Bill to update the ‘Landed Cost- Volume’ sublist. In that case, upon save action the script will be checking whether the values in the  ‘Landed Cost- Volume’ sublist has changed, and if the values in the sublist are updated, then the new values will be overwriting the old values in the standard landed cost box in the item sublist.

In order to set the value by script in the standard Landed Cost box, it is required to check the checkbox ‘Cost Allocation based on Volume’ in the body level and also, the values should be entered in the ‘Landed Cost- Volume’ sublist.

NOTE: 

• If the ‘Cost Allocation based on Volume’ is checked initially then the script will be checking the ‘Landed Cost per Line’ checkbox. But later if you want to continue using the standard method to enter Landed Cost per Line manually, then uncheck ‘Cost Allocation based on Volume’ and continue editing the standard sublist.
• Please let us know if there is no chance to update the ‘Landed Cost- Volume’ sublist after the creation, Once it is set. If yes, scripting on the edit context of the transaction can be removed and the estimate will be reduced.

Assumptions and Points to be Noted

1. The Standard feature of ‘Landed Cost’ is considered for this implementation.
2. The ‘Landed cost’ feature in the Supply Chain Management SuiteApp is not considered for the implementation as it is NOT recommended to edit the script of the suite app as the updates in this suite app can cause bugs.
3. We assume that the ‘Volume’ (‘VOLUME CBM’, Field ID: custitem_fenetti_volume  in the item record) is available from the line level in the Item Receipt/Bill.

Risks

1. Performance issues will be there if more item lines and cost categories are there in Item Receipt/Bill. Please mention the range of item lines and cost categories that can occur?.
2. The ‘Landed Cost per Line’ field can only be changed on new transactions. Once checked, it cannot be changed.

Budget and Time

Task	Time Required
Analysis	2h
Field Creation (checkbox) and Custom Record Creation	2h
Script for setting landed cost	12h
Volume Validation (Client script)	2h
Testing	3h
Deployment and documentation	1h
Total	22 hours
Total Remuneration	$xxx