Your team counts 37 units, but NetSuite shows 27. Maybe some items were damaged or stolen. Maybe someone entered the wrong number months ago. Now you need to fix the count before month-end. You also have 200 more items to check. This is where NetSuite Services can help. NetSuite offers two main ways to fix stock records.
You can enter a change using the Inventory Adjustment form. You can also set target balances using an Inventory Worksheet. Standard adjustments post to the general ledger (GL) when saved. They do not have a built-in approval step before posting.
Key Takeaways
Is NetSuite right for you?
Six honest questions. We'll tell you straight - even if it's "not yet."
Your verdict
A strong fit
Understanding NetSuite Inventory Adjustments: What They Are and Why They Matter
An inventory adjustment changes the quantity or value of your stock. You do not need a purchase order or sales order. You use it when your physical count does not match NetSuite.
Common Causes for Inventory Adjustments
Stock records can be wrong for many reasons:
- Clerical errors when someone types the wrong number
- Theft or shrinkage that goes unnoticed
- Damage during storage or handling
- Miscounts when receiving or shipping goods
- Cost changes that need to be recorded
- Physical count errors found during warehouse checks
Impact on Financial Statements
Inventory adjustments affect your general ledger. When you add stock, the inventory account usually increases. When you remove stock, its value decreases. NetSuite records the other side in the selected adjustment account.
These changes affect your balance sheet. They may also affect your income statement, based on the account used.
The account you choose matters. If theft and damage share one account, trends become harder to spot. Clear account rules help your finance team review these changes.
Types of Inventory Adjustments in NetSuite
NetSuite gives you two main tools. The first is the standard Inventory Adjustment form. Use it when you know how much stock to add or remove. Enter a positive or negative number in the "Adjust Qty By" field.
The second tool is the Inventory Worksheet. Use it when you know the final stock balance. Enter that amount in "New Qty." NetSuite works out the change.
NetSuite also has an Inventory Count process. It lets teams review and approve physical counts before stock changes are posted.
The Step-by-Step Process for Inventory Adjustment in NetSuite
Making an adjustment is simple once you know where to go. Here is the basic process for NetSuite Consulting clients and teams handling it themselves.
Navigating to the Inventory Adjustment Page
Go to Transactions, then Inventory, then Adjust Inventory. If you use OneWorld, select the right subsidiary when needed. The form opens with the fields for your stock change.
You need to complete these fields:
- Adjustment Account - The GL account for this change
- Date - The date of the stock change
- Posting Period - The accounting period used
- Item - The product you want to change
- Location - Where the stock is stored
- Adjust Qty By - How many units to add or remove
- Est. Unit Cost - The estimated cost per unit when adding stock
Saving and Posting Adjustments
Click Save when you finish. The standard adjustment posts to NetSuite right away. There is no built-in pending state or approval queue.
That can surprise teams that expect a manager to approve each change.
If you need approval for direct adjustments, you may need a custom process. For physical counts, NetSuite Inventory Count already offers an approval step. We will cover both options below.
Mastering the NetSuite Inventory Adjustment Worksheet
The worksheet works differently from the standard form. Instead of entering a change amount, you enter the final stock balance.
When to Use an Inventory Adjustment Worksheet
Use the worksheet when you need to set stock to a known balance. Your team counts the goods and records the actual amounts. You then enter those numbers into NetSuite.
NetSuite works out the difference between the old and new balances.
This helps when you need to fix many items at once. You do not need to work out each change by hand.
However, worksheets cannot be used for lot-numbered or serial-numbered items. Use the right count or adjustment process for those goods.
Preparing Your Worksheet for Batch Upload
NetSuite lets you import worksheet data from a CSV file. According to Oracle documentation, an import can have up to 1,000 lines.
Large imports may still time out. If that happens, split your data into smaller files.
Common worksheet data includes:
- Item name or internal ID
- Location
- New quantity
- New value
The CSV also needs the correct header fields, such as the adjustment account and date. These fields must match NetSuite's import rules.
Importing Data into NetSuite with the Worksheet
Go to Transactions, then Inventory, then Adjust Inventory Worksheet. Open the CSV import process. Upload your file and map the fields. Review your settings before starting the import.
There is one key rule to remember. According to Oracle's NetSuite documentation, worksheets average inventory costs.
They do not keep FIFO or LIFO cost history. Oracle recommends standard Inventory Adjustments for items using those cost methods.
Designing Effective Approval Workflows for Inventory Adjustments in NetSuite
Here is where things get tricky. Standard Inventory Adjustments have no built-in approval queue. The same applies to Inventory Worksheets. Once saved, these transactions post to the GL.
NetSuite Inventory Count works differently. A completed count can move to Pending Approval. A manager can approve or reject it. Once approved, NetSuite creates the needed stock adjustments.
That difference matters when setting up controls. A user with access to direct adjustments can post changes without a separate approval step. Your team needs clear rules for who can make those changes.
Why Approval Workflows are Crucial for Inventory Control
Without the right review process, you risk:
- Stock changes that go unnoticed
- SOX control issues for public companies
- Missing proof of who approved changes
- Errors found too late in the month
Key Decisions for Workflow Design
Before building a custom process, ask these questions:
- Who should approve small and large changes?
- Do you need value or quantity limits?
- Should managers approve only their own locations?
- How fast must approvals happen?
- Can NetSuite Inventory Count meet your needs?
For help with custom rules, read our guide on how to create a workflow.
Comparing Approval Workflow Options
| Feature |
Direct Adjustment |
Inventory Count |
Custom SuiteFlow |
SuiteScript Solution |
| Approval before posting |
No |
Yes |
Custom |
Custom |
| Tiered approvals |
Not built in |
Count-based |
Yes |
Yes |
| Custom limits |
Not built in |
Limited |
Yes |
Yes |
| Audit records |
Transaction history |
Count history |
Custom |
Custom |
| Best for |
Routine fixes |
Physical counts |
Simple rules |
Complex rules |
Implementing Workflow Rules in NetSuite
Custom solutions often use a staging record. A user first creates a pending request. A workflow then sends it to the right manager.
After approval, a script creates the actual stock adjustment.
This adds more setup work, but it gives your team control. You can set limits, require comments, and keep records of each approval.
Before building custom tools, check whether Inventory Count meets your needs. Using built-in features can save work later.
Best Practices for Maintaining Accurate Inventory with NetSuite
Adjustments fix errors after they happen. Good warehouse habits can stop many of those errors. Here is what helps our NetSuite Managed Services clients.
Implementing Regular Cycle Counts
Count part of your stock each week. Do not rely only on one full count each year. This spreads out the work and helps catch problems sooner.
Group items by value or how fast they sell. Count high-value items more often. Slow-moving goods may need fewer checks.
Reconciling Inventory Discrepancies Proactively
Do not wait for an audit. Run stock variance reports each month. Look for patterns in the results.
If the same items keep going missing, find out why. It could be theft, a shipping error, or a weak process.
Use NetSuite saved searches to find unusual changes. Flag large or repeated changes for review.
Leveraging NetSuite Features for Enhanced Accuracy
NetSuite has tools that help reduce stock errors:
- Bin management tracks goods within warehouse storage areas
- Lot and serial tracking helps trace specific items
- Barcode scanning reduces manual data entry
- RF-SMART integration supports warehouse scanning tools
NetSuite Inventory Management: A Growth Driver for Wholesale Distributors
Wholesale firms move large amounts of stock. Small errors can add up fast. A 1% loss on $10 million in stock equals $100,000.
Streamlining Procurement and Vendor Coordination
Accurate stock records help buyers order the right amounts. You can avoid buying too much or running out of goods.
Your vendors also get better order plans. That makes it easier to plan future stock needs.
Visit NetSuite for Wholesale Distributors for more guidance.
Optimizing Fulfillment Processes with Accurate Inventory
When your stock counts are right, you can give better ship dates. Staff know what is ready to send. Customers are less likely to face delays.
You may also reduce rush orders and extra shipping costs.
Addressing Wholesale-Specific Inventory Challenges
Wholesale firms often deal with:
- Stock stored in several warehouses
- Vendor-managed stock programs
- Just-in-time delivery needs
- Seasonal changes in demand
NetSuite can support these needs. The key is choosing the right setup and keeping stock records clean.
How Manufacturers Use NetSuite Inventory Adjustments for BOMs and WIP
Making products adds more steps to stock tracking. Raw materials become work in progress. Work in progress becomes finished goods.
Each step needs correct stock records.
Adjusting for Scrap and Rework in Production
Not every item made in a factory comes out right. Some materials become scrap. Other goods need more work before they can be sold.
Your team must record these losses using the right transaction.
Use separate accounts when needed for scrap, rework, and old stock. This helps show where materials go and why.
Maintaining Accurate BOMs Post-Adjustment
Your bill of materials (BOM) lists the parts needed to make a product. Actual use may differ from the plan.
Track these differences. If the same problem keeps happening, review the BOM or work process.
Learn more on our NetSuite for Manufacturers page.
Tracking WIP Inventory with Precision
Work in progress (WIP) includes goods that are not yet finished. These goods still have value, even if they cannot be sold.
Scrap or damage can change that value. Use the right work order or stock transaction to record the loss.
A direct Inventory Adjustment is not always the correct choice for WIP.
Enhancing Inventory Control for Retail with NetSuite Adjustments
Retail has its own stock problems. Goods move between stores, warehouses, and sales channels. Returns and damaged items add more work.
Managing Discrepancies Between POS and ERP
When your point-of-sale (POS) system and NetSuite show different counts, investigate the cause.
Regular checks can reveal missed sales, sync errors, or stock moved to the wrong place. Fixing the number alone may not solve the problem.
Adjusting for E-commerce Returns and Damages
Online returns may come back broken, used, or missing parts. Some goods cannot go back into stock for sale.
Record these losses using the right return and stock process. Track damaged returns apart from other stock losses.
Visit NetSuite for Retail for more guidance.
Optimizing Inventory Across Multiple Retail Channels
Retail stock can sit in many places at once. You need to know how much is held at each location.
Use location-based stock changes to fix counts. This helps prevent a problem at one store from affecting another.
Common Pitfalls and How to Avoid Them in NetSuite Inventory Adjustments
Even skilled teams make stock errors. Here are the main problems and how to avoid them.
Ensuring Proper Account Selection
Choosing the wrong GL account can cause reporting errors. Standard Inventory Adjustments require users to select an Adjustment Account.
Some teams add custom fields or scripts to guide account selection. This can help staff choose the right account.
NetSuite WMS also supports adjustment reasons for certain warehouse tasks. However, these are not a built-in reason-code feature for every standard Inventory Adjustment.
Clear rules make stock changes easier to check.
The Importance of Training for Accurate Adjustments
Many errors happen when staff do not understand the effect of their changes. Train your team on:
- When to use stock adjustments
- When to use other transactions
- How changes affect the GL
- What proof to include
- Who reviews unusual changes
Read NetSuite roles and permissions for help setting access rules.
Establishing Clear Roles and Responsibilities
Decide who can make stock changes. Decide who checks those changes. Write down your rules and make sure staff follow them.
| Common Pitfall |
Risk |
Solution |
| Wrong GL account |
Poor reports |
Set clear account rules |
| No records |
Weak audit trail |
Require notes |
| Wrong form used |
Stock errors |
Train staff |
| Missing approvals |
Unchecked changes |
Use approval controls |
| Large errors missed |
Late fixes |
Review variance reports |
Why Anchor Group Helps Teams Get Inventory Adjustments Right
Stock adjustments may look simple. You enter a few numbers and click Save. But those numbers affect your reports, stock value, and business plans.
Anchor Group helps wholesale firms, manufacturers, and retailers solve these NetSuite issues. We have seen what happens when stock records go wrong. We know how to find the cause and fix the process.
Our team builds custom workflows when your business needs extra controls. We can also review user access, account rules, and stock count steps. Sometimes the best fix is already built into NetSuite.
If stock changes feel out of control, we can help. If you need better records before an audit, we can review your setup. We can also help find the risks that keep causing the same problems.
Schedule a FREE 30-minute NetSuite fix to talk through your needs. No sales pitch. Just useful advice from people who know the system.
Frequently Asked Questions
What is the primary purpose of an inventory adjustment in NetSuite?
An inventory adjustment fixes stock amounts or values without a purchase order. Teams use it when physical counts do not match NetSuite. Common causes include theft, damage, errors, and lost goods. The change also affects your general ledger. You should check the reason before saving it. For physical counts that need approval, NetSuite Inventory Count may be a better choice.
How does an inventory adjustment affect financial statements in NetSuite?
Stock adjustments change the value shown in your inventory account. Adding stock usually raises that value. Removing stock lowers it. NetSuite records the other side in the selected adjustment account. This may affect the income statement, based on the account used. Your finance team should check the account before posting. Wrong account choices can make reports harder to trust.
What is the difference between an inventory adjustment and an inventory worksheet?
An Inventory Adjustment uses the amount of stock you want to change. For example, enter +10 to add ten units. Enter -10 to remove ten units. A worksheet uses the final stock amount instead. NetSuite then works out the difference. Worksheets can help with large stock updates. However, they do not keep FIFO or LIFO cost history.
Your count schedule should match your stock risks and business needs. Many teams review stock differences each month. High-value goods may need checks more often. Cycle counts spread the work across the year. They also help find errors before the annual audit. Review repeated errors, not just single changes. Those patterns can reveal weak receiving, shipping, or warehouse processes.
Can I automate inventory adjustment approvals in NetSuite?
Standard Inventory Adjustments do not have a built-in approval queue. The same is true for Inventory Worksheets. However, NetSuite Inventory Count supports approval before related stock changes post. For direct adjustments, you can build a custom process. SuiteFlow can route requests for review. SuiteScript can create the adjustment after approval. This gives managers more control over stock changes.
