Optimising Your Stock with Sage X3

September 3, 2021

Sage Platinum Club Winner

20+ Years Experience

UK&I + North America

First UK Sage X3 Partner

Content

Sage X3 provides all the tools that you need to efficiently control and manage your stock in real time both for now, and moving forward as your business grows.

In this article, we’ll take a look at just some of these:

  • Where to put it all – Location set up to cater for any scenario.
  • Products, goods, items, parts, SKUs – New products made easy.
  • Keeping track of everything – Stock movements with full traceability where you need it.
  • What state is our stock in? – Stock statuses and testing.
  • Getting the right balance – Managing the reorder process.
  • And that’s NOT all folks – The Mysoft difference.

Where to Put It All – Location Set Up to Cater For Any Scenario

Whether you’re working out of one location or you have multiple sites, Sage X3 gives you the flexibility to arrange these to suit your internal requirements. Locations can be internal or external, linked to a customer or supplier, and generally set up according to how you arrange your own storage facilities (warehouses, aisles, racks, bins, etc). If you want to restrict certain locations to certain products, then you can do that too, as well as determining limits on quantities of each product that can be stored there. Allocation and picking rules can be configured based on the type of location, so that stock is always taken from the most appropriate places.

When it comes to consignment stock, we’ve seen a number of different situations amongst our own customers, some involving stock held on-site, some off-site and with myriad different reporting and processing requirements. So, it goes without saying that X3 is flexible enough to deal with most scenarios in this area.

 

Products, Goods, Items, Parts, SKUs – New Products Made Easy

Whatever you call them and whatever your industry, you can create categories, or templates, to make new product set up easy.

Do you need Lot and/or Serial Number management? Expiry Dates? Version management? Allergen tracking? Barcoding? Customer and Supplier Product Numbering? The list goes on and can, on the face of it, appear a bit daunting. But the ability to define Product Categories means that the whole process can be made easy for your staff.

If you’re involved in manufacturing or simple assembly you can also define a full multi-level bill of materials. Or, if you want to offer complementary products to your customers as part of their order you can use a sales kit – all fully costed using a variety of different methodologies.

Keeping Track of Everything – Stock Movements with Full Traceability Where You Need It

Once you’ve defined the structure, X3’s comprehensive solution then allows you to manage the full range of warehouse movements, from Goods In and Put Away (if needed), through to Transfers, Stock counts, Despatch, and Adjustments. These can either be recorded on screens, including tablets, or using hand held scanners all in real time. Plus, more functionality in this area is due from Sage over the next year or two.

If you prefer the idea of integrating with a state-of-the-art warehouse management system (WMS) however, then Sage X3 is designed to make real time integrations seamless.

In industries like Food and Beverage and Pharmaceuticals, it’s also critical to be able to trace the origin of a product and its ingredients back to the source as well as going the other way, to know where else a particular batch of an ingredient may have been used, in case you need to consider a recall. With Sage X3, this comes as standard and is flexible enough to provide you with the level of detail that you need, whether that’s at batch, serial, pallet, all three or simply product level across all of your sites.

 

What State Is Our Stock In? – Stock Statuses and Testing

If the condition of your stock is important and you need a rules-based approach to managing movements according to that condition, then you can define any number of stock statuses in Sage X3. At the simplest level, you can start off by defining a status in terms of whether an item is Available, in Quality Control or Rejected. But you can also have multiple variations on each of these three main headings, with rules and processes linked to each.

When a stock item is returned, spoiled or defective, or simply on receipt or after manufacture, then you may need to place it in quarantine, pending the result of testing. With Sage X3 you can record the results of a quality test in as much or as little detail as you need, with supporting results and documentation attached for future reference and analysis. You can also use Non-conformances to manage issues and assign responsibilities for staff involved in corrective or preventive actions.

 

Getting The Right Balance – Managing the Reorder Process

Optimising your stock usually only means one thing: ensuring that you have enough of the right kind of stock available when you need it without burning an unnecessarily large hole in your finances. With X3 you can define or calculate minimum stock levels, reorder points, and take account of existing demand and forecasts for your products when calculating what you need to reorder. Sage X3 can then provide you with suggestions based on how you order. So for some products you might need to raise POs, manufacturing or subcontracting work orders, or simply organise a transfer of stock between warehouses to fulfil the expected demand.

If you regularly need to plan ahead, then you may also need to build your own forecasts, based on historic activity, and a tool like Sage Inventory Advisor (also known as Netstock) can be used to dynamically forecast demand for each product and recalculate stock levels accordingly – all fully integrated with Sage X3 and all designed to optimise the stock that you hold in each location.

And That’s NOT All Folks – The Mysoft Difference

There’s no doubt that Sage X3 has the power and flexibility to deal with most eventualities and scenarios that we might throw at it. But it’s true that no two businesses are the same, not even competing businesses within the same industry. There will always be subtle (or maybe even not so subtle!) differences in process, regulatory requirements, or levels of competency among staff that mean you need more than even X3 can offer.

At Mysoft we have over 250 collective years of experience working with Sage X3 and since 2005 we have been developing both bespoke solutions and more generic Sage X3 Plugins for our customers to help enhance the overall solution, including enhanced stock enquiries, carrier and WMS integrations, and industry-specific solutions such as our Pharmaceuticals Pack.

We also believe in a best of breed approach to both ERP (hence why we only work with Sage X3) and complementary solutions that exist in and around it, for example Sage Inventory Advisor which we talked about earlier in the article. As we’ve pointed out already, Sage X3 is a highly scalable solution built for companies just like yours. We’d be happy to talk to you about your own particular requirements, whether you’re looking at the short, medium or longer term.

Find Out More:

Read more.

The Cost of Not Knowing
Technology

The Cost of Not Knowing

From disappearing stock visibility to spreadsheet-dependent forecasting and rising logistics costs, our conversations at the Total Supply Chain Summit highlighted an important challenge: businesses have more data than ever, but that doesn’t necessarily mean they have the information they need.

October 19, 2026

Start Now: A Practical Approach to AI in Business.
Technology

Start Now: A Practical Approach to AI in Business.

Where should businesses start with AI? Jamie Watts, Managing Director at Mysoft, shares how AI is already creating value and four practical steps organisations can take to start adopting it responsibly…

October 1, 2026

Mysoft welcomes Cooper Turner Beck as a Sage X3 customer.
Case Studies

Mysoft welcomes Cooper Turner Beck as a Sage X3 customer.

A global leader in safety-critical fastener solutions, Cooper Turner Beck has chosen Mysoft to support its Sage X3 journey, following a competitive selection process against other Sage X3 vendors. With specialist Sage X3 implementation, support and ongoing value-added services, Mysoft is proud to be working with Cooper Turner Beck as they continue to strengthen their business systems for future growth.

September 30, 2026

Next Step

The AI Readiness Assessment places your organisation on the maturity ladder and identifies the specific gaps standing between you and a credible AI strategy.

Your Challenges

Growth Bottleneck

When your back office can't keep pace

AI Mandate

Board has asked for a credible AI strategy

Scale Ambition

Infrastructure for 2X, 3X+ growth

Compliance Event

Acquisition, audit, or regulatory change

Who we serve

CFO & Finance Director

AI strategy, close cycle, scalable infrastructure

COO & Operations Director

Integrated operational ERP and supply chain

CTO & IT Director

Architecture, integration, security, and TCO

CEO & Board

Investment case, governance, strategic finance

AI Transformation Stages

The Journey - Overview

How we take you from stage 1 to stage 4

Stage 1 — Operational Foundation

Building the platform your business deserves

Stage 2 — Intelligent Automation

Remove the manual transactional layer

Stage 3 — AI Augmented Finance

Intelligence at the speed of the business

Stage 4 — Agentic Finance Governance

Finance at scale without headcount growth

Frameworks & Tools

Agentic Finance Governence

Board-defensible AI governance

Finance Operations Review

Structured discovery process

ISV Partner Ecosystem

Netstock, Nectari, Avalara and more

Platforms

Compare Platforms

Sage Intacct vs Sage X3, find your fit

Sage Intacct

AI-enabled, cloud-native finance solution

Sage X3

AI-driven, scalable, comprehensive ERP

X3CloudDocs

AI document and workflow automation

Full Ecosystem

Netstock, Nectari, Avalara and more

Release Hub

Information on each release of our platforms

Services

Sage X3 Implementation

Structured delivery for successful implementation

Support Services

Expert support that keeps you moving

Localisation & Legislation

Local compliance for global operations

Upgrade to Sage X3 or Intacct

Looking to upgrade your ERP or FMS to Sage?

Sectors

Manufacturing & Distribution

Solutions for complex operations

Food & Beverage

FEFO, traceability, compliance, and scalability

Chemical & Pharmaceutical

Formula management, regulatory and quality control

Professional Services

Project accounting, revenue recognition

SaaS & Subscription Business

Subscription billing, revenue recognition

Financial Services

Multi-entity, regulated environments

Charities & Not-for-Profit

Fund accounting, SORP compliance

Content

Content Hub

Selection of blogs and content

Video Hub

Selection of Mysoft & Sage videos

Events & Webinars

Events, roundtables & webinars

Whitepapers & Guides

In-depth PDF DLCs

Demo Hub

On-demand demos

Bootcamps & Insights

AI Bootcamp

AI in plain English for finance

ERP Bootcamp

ERP selection and implementation

FMS Bootcamp

Financial management systems

Cloud Migration Bootcamp

Moving your ERP to the cloud

Strategic Insights

Agentic AI. Reality versus hype

In Focus & Resources

SaaS & Technology Finance

In-focus, ARR, revenue recognition

Master Data Management

In focus, the AI data foundation

AI ready finance guide

Free download asset

ERP Selection Framework

Six stage evaluation process

CFO Strategy

Finance as a growth enabler

Operational Transformation

AI in AP, AR and beyond

Who we are

Our Story

Over 20 years, first Sage X3 partner

Meet the Team

50+ in-house Sage experts

Careers

Join Mysoft

Refer an Organisation to Mysoft

Know any company that might benefit from our services?

Contact us

Start a conversation with our team

Credentials

Sage Tech Partner & Platinum Club

Only UK Tech & Business partner with the highest partner tier badge

Community & Giving Back

Supporting local initiatives