Fixing Inventory Costing Issues in NetSuite with Quick Update Tool

Introduction

Fixing inventory costing issues with the Quick Update tool is pretty straightforward. Are you a NetSuite Super User or an Administrator, and do you sometimes wish to update a field in NetSuite, but you can’t? Does this slow you down? Does it affect your work? If the answer is ‘yes,’ you are not alone; this is something NetSuite users face from time to time.

Learn more about our NetSuite services

As we support our customers, we built tools that help us administer our clients’ NetSuite environments. Recently, we bundled our tools into a product called BOLDAdmin. ‘BOLD’ because that’s who we are, and ‘Admin’ because NetSuite Administrators and Super Users are for whom this solution was designed.

In this article, I will not bore you with too many details about the app’s features. Instead, I will focus on one single use case where BOLDAdmin was able to help our client with an inventory costing issue.

Business Inventory Costing Issues

Our client is a manufacturer and a distributor of luxury limited-edition eyewear. Their SKUs are inventory items with a FIFO costing method. Recently, the client discovered that their Cost of Goods Sold did not add up, which ultimately skewed their product gross margins.

After some discovery, the production manager realized that the biggest reason COGS wasn’t correctly recorded was the Return Merchandise Authorizations (RMA’s).

Given that our client’s limited-series eye frames come with a hefty price tag, the company will take scratched or damaged frames for repair. Often, these frames are recorded on a single RMA transaction that cannot necessarily be linked to the original sales transaction.

Furthermore, when a standalone RMA for a specific SKU is created, this will likely be the first return receipt for the item at the (Repair) location, which is always different from the fulfillment location. This means that the FIFO costing layer will not be (properly) established for this SKU at the new location.

This can happen when the Item Receipt transaction linked to the RMA is not properly reviewed. Often, the Item Receipt for a given SKU will be recorded at 0.00 dollars. This presents a series of problems for the accounting team as these SKUs (received at $0.00 cost) will also record a $0.00 Cost of Goods Sold when fulfilled and shipped to the customer. This issue can be avoided only if the ‘rate override‘ field on the item receipt line(s) is populated during the receipt.

Read more: Build Your Own Power BI Reports For NetSuite.

this image shows rate override - Fixing Inventory Costing Issues in NetSuite

Okay, you’ll say: ‘This is great if I need to do it on one transaction, but what do I do if I have to update thousands of Item Receipt transactions?’ Well, if I did not know that our solution could help, I would have told you that you are out of luck as Item Receipts in NetSuite cannot be updated via CSV Import tool.

Transform your Inventory Management

Ready to revolutionize your inventory management in NetSuite? Discover how AlphaBOLD's Quick Update Tool can fix your costing issues efficiently.

Request a Demo

Inventory Costing Issue: Solution

There is no reason for sorrow or panic. Here is what we can do to overcome this system limitation.

  • Build a Saved Search: First and foremost, we must build a Saved Search to identify which Item Receipt lines were posted with zero cost. This is an example of criteria that will give us what we need. Note that your use case may differ slightly, but the lookup logic will not change.

Criteria:

this image shows Build a Saved Search

Results:

this image shows Saved Search result - Fixing Inventory Costing Issues in NetSuite

Notice I exposed the item’s transfer price (for reference only). My client has been maintaining this price; he wanted to use it as a true cost for the SKU. You can also use the ‘last purchase price’ field on the item record if you feel that this price represents the true cost of your item.

  • Expose the source field on the transaction line: I will name my item record’s ‘transfer price’ in the ‘source field.’ In the next step, I want to expose it on the Item Receipt line to update my override rate field.
this image shows transfer price

Field Configuration:

  • Go to: Customizations > Lists, Records, & Fields > Transaction Lines Fields > New
  • See the illustrations below for setup details (your configuration may be slightly different):
this image shows Transaction Lines Fields
this image shows new Transaction Lines Fields
this image shows Transaction Lines Fields items
  • Save & Apply to Forms. Make sure you select your default Item Receipt form
this image shows Item Receipt form
  • Run Quick Update Tool – You thought this step would never come, right?! Well, here we are! We will navigate to the BOLD Quick Update tool and click on the ‘Update Record Line Fields’ feature.
this image shows Quick Update Tool
  • Next, we will configure the Quick Update interface to update the lines listed as our Saved Search results.
this image shows update record line
  • Notice we use internal ID’s to reference our fields:
    • Enter Field ID: This is the field that we are updating.
    • Enter Source Field ID: This is the field from which we pull our value (Transfer Price field).
    • Mode: Dynamic, meaning it will be sourcing the value from another field.
  • Finally, we can execute the flow to update the fields and follow the progress.
this image shows script status - Fixing Inventory Costing Issues in NetSuite
  • When the process is completed, we can download the logs.
this image shows record line logs
  • Let’s review one of the transactions.

Read more: Engineering Change Order in NetSuite

this image shows review transactions -Fixing Inventory Costing Issues in NetSuite

Elevate your NetSuite Experience

Struggling with inventory costing issues in NetSuite? AlphaBOLD's Quick Update Tool is here to streamline your processes and ensure accuracy.

Request a Demo

Conclusion

In this article, I demonstrated how thinking outside the box can fix convoluted inventory costing issues. Also, I gave you a glimpse of what BOLD Quick Update and BOLD Admin can do to help you adjust seemingly unreachable records and fields. Write to us if you liked this solution, and should you want to learn more about BOLD Admin and test it for free, reach out to us now!

If you have any questions or queries, please contact us

Explore Recent Blog Posts