One common issue that many companies run into when they are trying to calculate their landed cost is that they receive their landed cost amounts months after they have received the inventory. By this time, they have closed their accounting periods in NetSuite and can not go back to update the landed cost natively on the Item Receipt. The solution below provides the steps to track an item’s average cost in this situation.
Want to learn more about landed cost? Check out this article that I wrote back in August of 2024 on Landed Cost and Implementing It in NetSuite.
To solve the issue, we use a Linked Item Receipt custom field on the Vendor Bill to help link the Landed Cost Vendor Bills back to the original correct Item Receipt. With these values, you can create NetSuite saved searches to calculate what value of the Landed Cost should allocated to each item (and per quantity). With these calculations, you can create a saved search that, at the end of each month, you export and then import to update the item’s average cost.
This field should be filled in for any Bill record that has Landed Cost payments tied to it. This will ensure that the correct costs are being attributed to the Item Receipt.
For each Landed Cost Cost Category, you will want to customize the following:
Step 1: Custom Saved Search that pulls in the amount from the Vendor Bill.
Criteria:
Results:
Available Filters:
Step 2: Custom fields
The first custom field should be a field to hold the calculation from the saved search above.
The second field should be used to hold this value for reporting.
Step 3: A workflow should be created to copy the first field into the second field.
If you want to allocate any of your costs by Quantity, you will need to create fields to calculate and hold the Sum of quantity. If you need help or guidance with this step, contact our team for assistance!
Here is an example of a saved search that calculates the True Item Cost.
Finally, you will need to create a second saved search to use as your import.
NOTE: We will be importing this as an Inventory Adjustment. We will have two lines for each item. The first line will show the quantity received in the last month * -1 and the Item’s current average cost. The second line will show the quantity received in the last month and the Item’s True Cost, calculated on the previous saved search. This allows the calculation to be weighted average.
Step 1: Export the search above as a CSV.
Step 2: Copy the values in Green under the values in Red.
Step 3: Save the CSV file.
Step 4: Go to Setup > Import/Export > Import CSV File and complete a NetSuite CSV Import with the following settings in place:
That's it; the issue should now be resolved!
We like to update our blogs and articles to make sure they help resolve any troubleshooting difficulties you are having. Sometimes, there is a related feature to enable or a field to fill out that we miss during the instructions. If this article didn't resolve the issue, please use the chat and let us know so that we can update this article!
If you have general questions about NetSuite or more specific questions about how our team can support your business, contact us! Anchor Group is a certified Oracle NetSuite Alliance Partner and Commerce Partner equipped to handle all kinds of NetSuite and SuiteCommerce projects, large or small.
Tagged with Training, Troubleshooting