Can I change an item from serial numbers to normal stock, or back? Switch an item's tracking the only way that works
“Can I change an item from serial numbers to normal stock?” Not on the item itself. Whether an item is tracked by serial number, by batch or by plain quantity is its Sub Item Type, and it is fixed the moment the item leaves draft, which happens by itself once its required fields are filled — the field is greyed out for everybody after that, and no permission unlocks it. What you can do is create a new item code with the tracking you want, move the stock across, and retire the old code. Allow half an hour, more if there is a lot of stock to move.
This page is for whoever looks after the item master and the stock that goes with it.
Meet GadgetSphere
GadgetSphere set up a range of phone cases with serial numbers by mistake, and every receipt and sale now asks for serials nobody has. You want the cases counted by quantity only. The existing code is ACC-CASE-01, with 300 units across the Klang Valley branches.
Before you start
- Confirm the field is really locked. Doc Item Maintenance → the item → Sub Item Type. If the item is still a draft (status TEMP), you can still change it there — and this page is not needed.
- Agree the new code with whoever owns the catalogue. Item codes are unique: the old code stays taken even after you retire it, so the new item needs a different code (for example
ACC-CASE-01Q). - Know how much stock is where. Run Stock Availability for the old item across its locations (how).
Step 1: Create the new item with the right tracking
Doc Item Maintenance → create a new item → Sub Item Type
Create the new item and choose its Sub Item Type carefully. If the field is not on the screen, an applet setting or the item template you picked is hiding it — and with the applet setting, the item saves itself with the default type. Ask your administrator to show it before you start. For a Basic Item the choices are Basic Quantity, Batch Number, Serial Number, Bin Number and UNITY. For the cases, Basic Quantity. Copy the rest of the set-up from the old item: units, category, prices, GL codes.
This choice is fixed again almost at once: a new item saves itself, and locks Sub Item Type, as soon as its code, name, item type, base unit, currency and sub item type are all filled in — you do not have to press Save. Pick Sub Item Type deliberately, and check it before you fill in the last of those fields.
Step 2: Move the stock from the old code to the new one
Stock Adjustment
Use Stock Adjustment: an Adjust-Out of the old item and an Adjust-In of the new one, location by location, for the same quantities. Where an item is serialised — the old one when you are leaving serial numbers, the new one when you are adopting them — each adjustment line names its serial numbers, one per unit, as any serialised document line does. Do not use the applet’s Serial Number Adjustment menu for this: it corrects the serial register only and moves no stock.
Agree the cost the new item comes in at with accounts before you finalise the adjustments, so the stock value does not jump. If you are unsure how to carry the cost across for your items, contact BigLedger support for this step.
Do not use Stock Conversion for this: its FINAL does not currently move stock.
Step 3: Retire the old item
Doc Item Maintenance → the old item → Status → INACTIVE
Once the old item holds no stock anywhere — and no open sales or purchase order, live bundle or price set still names it (what to check before retiring) — set its Status to INACTIVE. An open order still delivers or bills the old code, so finish or replace those orders first. It stays on every historical document, and new documents no longer offer it. Do this after the stock has moved: an item retired while stock remains can disappear from sales screens and stay on stock reports.
What success looks like
Stock Availability Details, with zero balances shown and inactive items included in its search, shows the old code at zero at every location and the new code holding the same quantities (the main listing leaves zero and negative balances out, so an absent row proves nothing); the old code reads INACTIVE; and a test sale of the new code asks for no serial numbers (or does, if you went the other way). For GadgetSphere: ACC-CASE-01Q holds 300 cases counted by quantity, and ACC-CASE-01 is retired with its history intact.
Common mistakes
- Looking for an administrator override. There is none. Changing the type would have to re-check the item’s stock balances, serial and batch records and every document that uses it, and BigLedger does not do that check, so the field stays locked.
- Trying to reuse the old code. Codes are unique, and an INACTIVE item still holds its code.
- Retiring the old item before moving its stock. Move the stock out first, then set INACTIVE.
- Moving stock with Stock Conversion. It does not currently move stock. Use Stock Adjustment.
- Getting the new item’s tracking wrong too. It is fixed again the moment the item saves itself. Check Sub Item Type before the last required field is filled.
If it still does not work
Contact BigLedger support with the old item code, the tracking you want, the stock on hand by location, and whether any open orders still name the old code.
Related documentation
- Choosing an item type: tracking and the final check — why the sub item type locks, and how to choose it right the first time
- Item master: units, prices and retiring — what each item status means
- Stock Adjustment applet — adjusting stock in and out, including serial numbers