ERP and NetSuite

NetSuite for Food and Beverage and What to Get Right First

Jithesh Manoharan, Chief Executive Officer. . 5 min read

In short

NetSuite for food and beverage is won or lost on lot traceability, shelf life and yield. Every lot has to carry its source, its expiry and where it went, from the first transaction onward. You cannot rebuild that record later. Most of the build can improve over time. That part cannot.

One question decides how a food business runs its systems. It has nothing to do with accounting.

If a supplier calls tomorrow morning and says one ingredient lot is affected, how long does it take you to know which finished product it went into and which customers received it.

Almost everything else in a food and beverage build can be phased or improved later. That one cannot. A traceability record cannot be created after the fact. It either built up correctly as transactions happened or it does not exist.

In NetSuite for food and beverage, lot control is a design job

Lot numbered inventory and expiry dating are standard features. Turning them on takes an afternoon. Designing them is the project.

The decisions that count are which items are lot controlled, how a lot number gets assigned, and whether it comes from the system or from your supplier.

Carrying the supplier lot through is more work at receipt and it is usually right. When a supplier issues a notification they quote their own lot number. A system that generated its own and threw theirs away forces somebody to translate by hand at the exact moment nobody has time.

Where you produce, the finished lot has to record which ingredient lots went into it. That link is what lets you trace in both directions. Forward from an ingredient to your customers. Backward from a complaint to a supplier.

Shelf life has to drive picking

Recording an expiry date is useful. Enforcing it is what stops the write offs.

If the system holds expiry dates but lets anyone pick any lot, short dated stock will collect at the back of the warehouse. The picker takes what is nearest. That is not carelessness, it is speed. First expiry first out has to be the rule the picking process applies, with an override that needs a reason and leaves a record.

The other half is minimum remaining shelf life on despatch. Plenty of retail customers require a share of shelf life to still be left when product arrives. If the system does not know that rule, you find out through a rejected delivery. Hold the requirement on the customer record, check it at allocation, and a recurring argument turns into an exception report.

Yield, waste and what a unit really costs

Food production does not turn inputs into outputs at the ratio the recipe states. There is trim, evaporation, giveaway and the occasional failed batch.

If nobody records actual output against the batch, two things go wrong quietly. Ingredient stock drifts away from what is physically there. And the finished unit cost comes out too low by the value of the waste. A business can carry that for a long time before a stock count forces the conversation.

Record actual yield per batch. Let the variance post where people can see it. That turns an annual adjustment into a weekly operational discussion, which is much cheaper.

Catch weight belongs in scope from day one

Where you sell by weight but handle by unit, invoice value depends on what physically shipped rather than on a count. Cheese, meat, fish and some bakery lines all work this way.

Catch weight touches pricing, picking, invoicing and inventory valuation all at once. It is not a report you bolt on later. If you need it, it has to be in scope from design. If you do not, leaving it out keeps the build a good deal simpler. Deciding this early is worth more than most other scope conversations.

Co packing raises the same questions

Plenty of food businesses produce through co packers. That gives you the familiar problem of owning inventory standing in somebody else building. It adds one more thing. The lot chain has to survive the handoff.

Ingredient lots issued to the co packer have to be recorded. The finished lots they produce have to link back. Without that link the trace breaks at exactly the point where most of the risk sits. The general pattern is in our guide to contract manufacturing in ERP. The food specific addition is that the lot chain matters as much as the stock value.

You need to be able to stop stock moving

A trace is only half of a recall response. The other half is stopping affected stock from going anywhere.

That means a hold that works at lot level, blocks allocation and picking in every location at once, and can be applied by somebody with the authority to do it without waiting on an IT change. Businesses that lack this find out during an incident. That is the worst possible time to learn that the only way to stop despatch is to phone the warehouse.

Regulatory records are an output

Food businesses carry record keeping duties that vary by market and by product. In the United States the Food Safety Modernization Act extends traceability records for certain foods. The broader expectation of tracing one step forward and one step back has been part of food law in most developed markets for years.

What that means for a system build is simple. If the lot chain underneath is complete and queryable, producing a record for a regulator is a reporting exercise. If it is not, no amount of reporting effort will invent the data. Build the chain and the compliance output follows.

Sequencing around your season

Most food businesses have a period they cannot go live in. Seasonal peaks, harvest windows and retail resets all create weeks where the operation has no room to absorb a change.

Map those before you set a date. Then scope the first release around traceability, inventory accuracy, purchasing and the financial core. Leave demand planning, advanced analytics and customer electronic data interchange for a second phase. The implementation timeline guide covers how these phases usually fall out.

Getting it designed properly

TechCloudPro sets up NetSuite for food and beverage businesses through NetSuite implementation where traceability is the controlling requirement rather than an afterthought, across the whole sector. We do the same for wholesale and distribution businesses moving that product onward. If you cannot answer the lot question in minutes today, start there.

Common questions

Does NetSuite handle lot and expiry tracking out of the box
Lot numbered inventory and expiry dates are core inventory features. The work is not switching them on. It is deciding which items are lot controlled, how lots get assigned at receipt and production, and how picking rules enforce first expiry first out.
What is catch weight and do we need it
Catch weight applies where you sell by weight but handle by unit. A wheel of cheese or a cut of meat. If your invoice value changes with the actual weight shipped rather than the count, you need it. Adding it after go live is painful.
How fast should we be able to produce a recall trace
Fast enough that the trace is not what holds up the decision. The test is whether you can go from one lot number to every customer who received product containing it without leaving the system. If the answer involves a spreadsheet you have a gap.
We use co packers. Does that change the build
Yes, in the same way outsourced production changes any consumer goods build. You own components sitting at a site you do not run. On top of that, the lot chain has to survive the handoff in both directions.

About the author

Jithesh Manoharan, Chief Executive Officer

An IT consultant with experience spanning more than two decades, across startups and the Big 4 alike. Jithesh has worked as a NetSuite ERP consultant, principal advisor and solution architect for companies including Wells Fargo, Hampton Creek, Anastasia Beverly Hills and JUST Inc. He runs several concurrent programmes across industry verticals, and advises boards and executives on enterprise wide technology strategy.

Related reading

Talk to the team that wrote this

If any of this matches what you are dealing with, a short conversation will get you further than another article.

Book a consultationERP and NetSuite at TechCloudPro