Proposal Summary
This proposal outlines the process to create a custom form for calculating the landed cost from the inbound shipment record. The landed cost will be calculated and distributed to multiple Item receipts which were created from different purchase orders.
Requirement
The Harbour Lifestyle may have multiple item receipts for an inbound shipment so they need the bill amount to be split across all item receipts associated with the Inbound shipment based on volume.
Our Solution
The client may have multiple item receipts for an inbound shipment, so we propose a solution to split the bill amount across all item receipts associated with the inbound shipment based on volume.
In accordance with that, we already have an existing solution,
About existing Solution
- There is an existing customization for calculating the landed cost from each item receipt.
- For the purpose of calculating the amount from the bill, a landed cost custom record is created and associated to the item receipt.
- The associated custom record will be used as the source for the bill amounts from a specific account, and it will be used to calculate the landing cost.
- The amount determined with the cost category will be set inside the landed cost sub-record following the calculation of the landed cost for each line item.
Revised Solution
- The new customization will completely replace the existing one.
- As per the new request, we will be creating a button inside the inbound shipment record that will navigate towards a Custom Record.
- Two input body level fields are there to source the total volume of the shipment and to source the created from inbound shipment.
- The total volume will be determined by adding up the volumes of all the items that were received for this inbound shipment.
- There will be two subtabs:
Landed Cost Volume
- As a reference to the current sublist from the landed cost customization, this sublist will be created.
- A custom record will be made for the sublist if there is none or the existing custom record will be maintained/reused.
- The cost categories can be chosen from a field. This column will include a list of all cost categories created in NetSuite.
- A field for selecting the bill and another for sourcing the bill’s amount.
Items Based on Item Receipt
- This sublist will be showing the items from different item receipts.
- The sublist will include items, the associated item receipts, the Quantity and volume per piece columns, and more as shown in the image.
- All the item sublist fields will non-editable.
- Based on the cost category that was previously selected, the final columns will be created.
There will be created and edit contexts for this customization.
On Create Context
- A button will be added to the Inbound Shipment page.
- The user will be able to click this button after the creation of the inbound shipment.
- A sublist for entering the cost category and bill amounts will be displayed when the “landed cost Volume” Custom record is opened.
- Harbour Lifestyle will be able to select the cost category from a list, and there will also be a field where the amount may be pulled directly from a billing record.
- The record can be saved after the values are entered.
- The scripts will be updating the landed cost sub-record in the background when they locate the appropriate item lines from the item receipts.
On Edit Context
- Click the button from the inbound shipment record to edit the landed cost volume custom record once more.
- The customised record that was already saved will now be opened in view mode.
- Harbour Lifestyle can update the cost categories after opening the record in edit mode.
- The lines from the corresponding item receipts will be displayed in the ‘Items Based on Item Receipt’ sublist inside the custom record.
- This sublist will be non-editable.
- The previously entered cost categories from each landed cost sub-record inside item receipts will be totally erased and repopulated with the values from the modified custom record.
Currency Handling
- There will be two extra fields added inside the Landed cost Volume for currency.
- “Bill amount” and “Bill Currency”
- These two fields will be mandatory.
- Either the bill amount field can be sourced from the bills or can directly enter an amount.
- In both scenarios, Harbour lifestyle should give the billing currency.
- On comparing bill currency and Item receipt currency we will be converting the amount based on the exchange rate.
- This converted amount will be given split into each item landed cost sub-record.
Error Handling
- There will be an additional field called “Processed” to indicate which lines of the “Items based on Item receipt” sublist have been updated.
- Also, there will be an indication during the updating time as ‘Not started’, ‘Pending Processing’ and ‘Completed’.
Calculation Logic
- Landed Cost based on volume per category
[ Cost Category Amount (From Landed cost sublist) / Total volume of shipment] x Volume per PC x Quantity.
Assumptions
- The bill amount will be sourced from the ‘7012 Goods in Transit’ account.
- Open Accounting periods.
- By clicking the button from the Inbound shipment record always the cost allocation method will be Volume.
- The currency filed will not be empty.
- The exchange rate will be based on the Item receipt transaction date.
- This customization will only be done for Harbour lifestyle UK.
- We assume there will be no role permission issue.
- We are planning to develop this in SB first. Upon confirmation, we can move it to production.
Notes
- The custom ‘Items based on Item Receipt’ sublist will be non-editable. (Only for viewing purpose).
- The exchange rate will be always based on the Item receipt transaction date.
- There must be a value inside the billing currency.
Exclusion
- The accounting period should be open.
- The UOM will not be taken into consideration.