How to Adjust Inventory in Fishbowl
how to adjust inventory in fishbowl
Also searched as
- fishbowl cycle count
- fishbowl inventory status
- fishbowl inventory reports
- fishbowl change inventory quantity
Short answer
In Fishbowl, the audit-friendly way to adjust inventory is a cycle count: you count a location or part, enter the real quantity and commit, and Fishbowl posts the difference. For one-off corrections you can use scrap or add inventory, and move inventory between locations. Check the inventory reports afterwards.
Applies to: Fishbowl Advanced; names and menus vary slightly by version. Accounting effect depends on your QuickBooks integration.
Adjust inventory with a cycle count
- 1Open the Inventory module and choose Cycle Count.
- 2Create a count for the location, part or tag you want to correct, or select the parts that look wrong.
- 3Count the stock physically and enter the quantity for each line in the count.
- 4Review the variance Fishbowl shows between system and counted quantity.
- 5Commit the count so the adjustment posts. Add a note with the reason.
- 6Run an inventory quantity report for those parts and confirm the on-hand now matches the count.
- 7If you use QuickBooks, confirm the adjustment posted or is queued, and check the accounts it hit.
Cycle count, scrap and add: which one
Cycle count adjusts to a counted truth and records the variance, which is what auditors like. Use it for routine accuracy.
Scrap removes known damaged or lost stock with a reason, and add inventory brings in stock that was never received. Both are direct transactions and should have restricted access.
Move is not an adjustment: it only changes location, with no value change.
Inventory status
Quantities in Fishbowl are shown by status such as on hand, allocated, committed or on order. A part can have stock but show little available because most is allocated to open orders.
Before adjusting, check whether the quantity is actually missing or just committed. Adjusting a number that was never wrong creates a false variance and a false cost entry.
Reports to check
After adjustments run the inventory quantity report by location and the valuation report. Compare totals with your last accounting value.
For ongoing accuracy, review adjustment history by user and reason weekly so patterns such as a repeated shrink point show up.
Try it here, free
Fishbowl Inventory Import Worksheet
An editable opening-inventory worksheet with part, location, quantity and cost columns and a valuation total to reconcile before importing into Fishbowl.
Common pitfalls
- !Adjusting without counting, just typing a number.
- !Confusing allocated stock with missing stock.
- !Giving everyone scrap and add access.
- !Counting while shipping continues and not freezing the location.
- !Skipping a reason code on adjustments.
How an ERP-grounded AI assistant handles this
A private assistant over Fishbowl data can list parts with the largest recent variances and show which users or locations they cluster around, so counts are targeted. It proposes counts; people still count and commit.
Frequently asked questions
How do I change inventory quantity in Fishbowl?
Use a cycle count to enter the real quantity and commit, or use scrap or add inventory for single corrections. Cycle count is the better audit trail.
Why does Fishbowl show stock but none available?
Because the quantity may be allocated or committed to open orders. Check the inventory status breakdown before assuming it is missing.
Does an adjustment affect QuickBooks?
Yes, with the accounting integration an adjustment posts a value change to the mapped accounts. Check the posting afterwards.
Which reports show inventory in Fishbowl?
Use the inventory quantity and inventory valuation reports, plus any custom location or tag reports your team has built.
Related
Fishbowl SQL Query for Inventory by Location
Fishbowl stores physical inventory as rows in the tag table, one per part per location per tracking combination. Join tag to part and location, group by part and location, and sum quantity to get on hand by location. Run it read-only through Fishbowl's reporting module or a read-only MySQL user, and verify column names against your version.
How-toHow to Back Up Fishbowl Inventory (and Restore It)
Fishbowl stores everything in a MySQL database on the Fishbowl server, so a backup means copying that database plus your attachments and custom reports. Use Fishbowl's built-in backup for a quick copy, schedule it, add a mysqldump or file-level backup for redundancy, copy the result offsite and test a restore regularly.
How-toFishbowl Inventory and QuickBooks Integration: Setup, Mapping and Sync Errors
Fishbowl runs inventory, orders and manufacturing, and posts the accounting results to QuickBooks. Inventory quantities stay in Fishbowl; QuickBooks receives journal-style postings and documents mapped to its accounts. Most sync errors come from account mapping, missing customers or vendors, closed periods or mismatched names.
How-toHow to Create a Generic Inquiry in Acumatica
Generic Inquiries (GI) are Acumatica's no-code query builder for joining tables, adding filters, and exposing the result as an inquiry screen, dashboard data source, or API endpoint. Open System > Customization > Generic Inquiry, add your base table, define joins and conditions, then run and save. No SQL or customization project is required.
Error fixFix Odoo AccessError: You Are Not Allowed to Access Records
Odoo raises AccessError when a user's security groups do not grant a CRUD right on a model through ir.model.access.csv, or when an ir.rule record rule filters the specific record out for that user or company. Fix it by adding the user to the group named in the error, editing the model's access rights, or reviewing the record rule's domain under Settings > Technical > Security.
How-toHow to Void a Check in Sage 100
Sage 100 voids checks through Accounts Payable > Main > Check and Payment Voiding. Select the bank code, choose the check number, and Sage reverses the Cash Disbursements Journal entry and reopens the invoice it paid. A check that already cleared in Bank Reconciliation or falls in a closed period needs an extra step before it can be voided cleanly.
AI for ERPAI for Fishbowl Manufacturing and Warehouse
Fishbowl on-premise API for custom integrations: socket API, REST API and read-only replica options, plus private AI that leaves the QuickBooks sync alone.
AI for ERPAI for Cycle Counting and Inventory Accuracy: Count the Right Items and Find Why the Numbers Drift
Use AI on ERP transaction history to choose what to cycle count, find root causes of inventory variances and reduce wall-to-wall counts. Private and on-prem options.
Stuck on Fishbowl Inventory?
Talk to engineers who work inside Fishbowl Inventory every week, and who build private AI that answers these questions from your own ERP data.
Keep exploring
Free tools
- Fishbowl Inventory Import WorksheetAn editable opening-inventory worksheet with part, location, quantity and cost columns and a valuation total to reconcile before importing into Fishbowl.
- SyteLine Cycle Count Variance WorksheetAn editable cycle count sheet that computes variance quantity, variance value and record accuracy per line and overall.
- SAP Business One Cycle Count Variance WorksheetAn editable worksheet that compares system and counted stock, values the variance and shows the percentage before you post the inventory adjustment.
ERP fixes and how-tos
- Fishbowl Inventory API Documentation: Auth, Endpoints and ExamplesA practical guide to the Fishbowl Inventory REST API: where the docs live, how login and tokens work, the main endpoints and example requests you can try.
- Fishbowl SQL Query for Inventory by LocationBuild a Fishbowl custom report or query for on-hand inventory by part and location using the tag, part and location tables, with checks and read-only guidance.
- Fishbowl Inventory Integrations, Scanners and ForecastingFishbowl Inventory integration options: accounting, e-commerce, shipping, the API, barcode scanners and mobile apps, and how forecasting and reorder planning work.
Guides
- SyteLine Cycle Counting Configuration and Setup GuideSet up cycle counting in Infor SyteLine with ABC classification, count scheduling, variance thresholds, and approval workflows for inventory accuracy.
- How to Set Up Cycle Counting in SyteLineStep-by-step guide to configuring cycle counting in Infor SyteLine CloudSuite Industrial, including ABC classification, count schedules, and variance thresholds.
- Mobile Inventory Counting and Cycle Counts in SyteLineMobile inventory counting solution for SyteLine: scan-based cycle counts and physical inventory on handhelds, with variance handling and live reconciliation.
AI on your ERP
- AI for Fishbowl Manufacturing and WarehouseFishbowl on-premise API for custom integrations: socket API, REST API and read-only replica options, plus private AI that leaves the QuickBooks sync alone.
- AI for SyteLine Inventory Control and Cycle CountingAI for Infor SyteLine inventory: pick cycle counts by risk, find negative or stale stock, explain variances and review adjustments with the query shown, on-prem.
Integrations
- How to add AI agents to FishbowlHow to add AI agents to Fishbowl: a tool layer over the Fishbowl REST API and MySQL read replica, with human approval before any purchase order or work order write.
- How to add an AI chatbot to FishbowlHow to add an AI chatbot on top of Fishbowl for staff and customers: grounded in live inventory and order data, role-aware, and able to run fully on-prem.