ANS-0504 · INVENTORY & ITEM MANAGEMENT
Why Do NetSuite Transactions Show Amount with Zero Quantity?
Learn why NetSuite transactions, such as credit memos, can show an amount with zero quantity, and how this practice affects serialized inventory items.
Short answer
Unexpected inventory values, where a transaction shows an amount but zero quantity, often stem from standalone credit memos. While sometimes used to apply credit without affecting inventory, this practice is problematic for serialized items. Identify these transactions by searching for records with quantity 0 and an amount.
Scenario
NetSuite users may encounter transactions that display an amount despite having a quantity of zero. This situation commonly arises with standalone credit memos, where the intent is to issue a customer credit without affecting inventory levels. However, this practice can lead to significant issues, particularly when dealing with serialized inventory items, as it creates discrepancies in inventory tracking.
Solution
To identify transactions exhibiting an amount with a zero quantity, users should perform a search for any transaction where the quantity is 0 and an amount is present. This situation commonly arises with standalone Credit Memos. The practice of creating a Credit Memo for an item with a quantity of 0 but a specified amount is sometimes used with the intention of applying a credit to a customer without affecting inventory levels. However, this method is not suitable for Serialized Items, as it can lead to discrepancies in inventory management and reporting.
Expert NetSuite Support
Need help with this NetSuite issue?
Inventory & Item Management consulting and configuration support