Blended Lot Traceability

Process manufacturing · Microsoft Dynamics 365 Business Central · On Microsoft AppSource

Apps › Manufacturing Suite › Blended Lot Traceability

Blended Lot Traceability

When lots are blended in a tank or silo, standard Business Central can no longer say which source lots are in a bottle. This app can, for every withdrawal, and for every recall.

✓ Built on standard item tracking

✓ Original lots stay your inventory

✓ Safe with average costing

✓ Built & supported by GMSOFT

Overview

What Blended Lot Traceability does

Business Central item tracking assumes discrete lots. A tank that takes Lot A on Monday and Lot B on Wednesday holds a mixture with no lot of its own, so the one question a recall asks, which source lots are in this bottle?, has no answer in the system. Blended Lot Traceability tracks the contents of each vessel as a composition of source lots and follows it through every movement.

Vessels and blends

  • Vessels – tanks and silos mapped to a location and bin, with capacity and a depletion method.
  • Versioned composition – every movement creates a new snapshot of what the vessel contains, so any withdrawal refers to the exact blend of that moment.
  • Quantity always balances – blending neither creates nor destroys liquid, and postings that would break the balance are blocked.

Movements

  • One posting path – additions, withdrawals, tank-to-tank transfers and losses all go through the same routine, so a later machine feed can use it unchanged.
  • Proportional depletion – a withdrawal from a mixed tank carries a proportional share of everything in it, not the oldest lot first.
  • Standard entries untouched – the app adds a reference to the item and warehouse entries and never edits quantities, costs or lot numbers.

Trace and recall

  • Draw-off to bottling – the blend identity travels with the product through standard item tracking to finished goods and customers.
  • Backward and forward trace – from a bottle to its source lots, and from a source lot to every blend, withdrawal and shipment it reached.
  • Recall simulation – the affected lots, withdrawals and customers for any source lot.
  • Reconcile and rebuild – the composition records can be rebuilt from the item ledger, so they never drift away from your books.

Optional: spirits and alcohol excise

  • Configured at request – for customers who handle alcohol, we can add an excise layer set up around your own needs. It is not part of the standard app.
  • Strength and pure alcohol – alcohol strength and litres of pure alcohol recorded on each movement, with the balance of each vessel.
  • Your rules, as settings – tax warehouses, country regime, categories, rates and reliefs are configured for your company, not hard-coded.
  • Figures, not filing – the app prepares the figures and registers for your excise return. You file with the authority yourself.

App details

  • Platform: Microsoft Dynamics 365 Business Central online
  • Category: Manufacturing, Quality
  • For: distilleries, dairies, edible oils, juice and chemicals
  • Status: Live on Microsoft AppSource
  • Pricing: Paid plan on AppSource
  • Publisher: GMSOFT LIMITED
Get it on AppSource ↗
Read the documentation
Book a demo

How it works

From tank to recall in five steps

1

Set up vessels

Map each tank or silo to a location and bin.

2

Add lots

Receipts into the tank create the first composition.

3

Move and blend

Transfers, withdrawals and losses each create a new version.

4

Draw off

Bottling carries the blend identity into standard item tracking.

5

Trace or recall

From any bottle to its source lots, or from a lot to its customers.

Want to see it on one of your tanks?

Tell us how you blend and bottle today. We will show you what a recall answer looks like.

Frequently Asked Questions

Q: Does it replace Business Central item tracking?

A: No. It builds on it. Original lots stay the real inventory, and the blend is a traceability record on top.

Q: Does it change how stock is costed?

A: No. It never edits posted quantities, costs or lot numbers, and it is designed for average costing.

Q: Do I need SCADA or machine data?

A: No. Movements are entered on one screen. A machine feed can post through the same routine later.

Q: Does it handle alcohol excise?

A: Not in the standard app. For distilleries and other alcohol producers, we can add an excise layer configured to your needs on request. It prepares figures for your return and does not file anything for you.

Q: When is it available?

A: Now. It is live on Microsoft AppSource for Business Central online. Get it on AppSource or book a demo.

Scroll to Top