Maximise Operational Efficiency and Productivity

De Facto ERP & E-Commerce for the Wine, Beer and Spirits Sector

ERP and E-Commerce for the Drinks Industry
Software Solutions for the Drinks Industry

Our Solutions for the Drinks Industry

Fully-integrated, cloud-based ERP solutions designed for the Drinks Industry, Distributors, Wholesalers, Agencies, Fine Wine & Spirits Suppliers, Traders and Brokers.

De Facto Software: Evolving your business.

Under bond, duty paid pricing and stock handling  

Seamless supply chain Integration  

Sophisticated cost control  

Integrated multi channel E-Commerce and CMS  

ERP Project Journey for the Drinks Industry

The De Facto project journey

Our multifaceted ERP supply chain projects, which entail integration with numerous partners, represent some of the most complex and impactful initiatives for any organisation. To ensure their success, we follow a 3-step process.

Firstly, we establish a clear project definition. Next, we create an agile project implementation methodology that's finely tuned to meet both the project's requirements and our client's needs, ensuring a smooth and successful project delivery. Throughout each stage of the project process, our dedicated team will guide and support you, ensuring your business maximises the project benefits. Customer satisfaction is our key driver, and we’re committed to continuously improving our solutions to support our partners on their journey.

 
 
 
1. Clear Definition
  • Establish joint project team
    • Client - Project sponsor & functional leads
    • De Facto - Business analyst & project manager
  • Agree agile implementation methodology
  • Document detailed scope
 
 
 
2. Agile Implementation
  • Create configuration & development stories
  • Agree deliverable sprints & milestones
    • Configure & develop
    • Test & release
    • Demonstrate and sign off
  • Train the client project team
  • Client project team acceptance testing
  • Client project team deliver end user training
  • Data mapping & transfer
 
 
 
3. Complete Support
  • Go live
    • Planning
    • Support
    • Project review
  • On going
    • Support
    • Evolve & improve
    • Upgrades
       

"Our relationship with De Facto stretches over 10 years. The ERP system is easy to use and does everything one would expect. Together with the team, we have enhanced it to suit our needs. This has led on to many other innovative projects that are embedded in our business."

Nick Gurney - Financial, Logistics & IT Director

John E Fells & Sons Ltd

Partners in your industry that trust De Facto

EDP The De Facto Platform

De Facto ERP for the Wine, Beer and Spirits industry is built using our Enterprise Data Platform (EDP), leveraging its solution architecture to deliver long-term, scalable, enterprise-grade ERP solutions.

  • Unique data driven design
  • Intuitive consistent user interface
  • Workflow driven
  • Real-time processing
  • Open service based architecture
  • Robust user security
  • Multilingual
  • Scalable
  • Cloud hosted
  • Integrated document management 
  • Integrated with Microsoft BI Tools
  • Integrated E- Commerce / CMS
  • Powerful extensible ERP solution

EDP User Interface

A consistent, intuitive interface, providing powerful, accessible features, allowing all levels of users to quickly gain understanding and confidence, maximising their ability to use the system effectively.

The consistent and intuitive interface ensures that as the system is further developed, users will easily understand new interface and business process functionality.

Unified interface  

Browser based application  

Workflow based solution  

Generic Interface Functionality  

EDP Functionality

A platform that delivers future-proof, functional and scalable solutions to match the ambitions of your organisation.

Extensible database architecture  

Real time processing  

Multiple Organisations and Companies  

Multilingual  

Security, Logging and Compliance  

EDP Architecture

A fully integrated infrastructure that allows your ERP project to reduce reliance and cost of internal IT resources, and frustration of managing multiple providers.

Cloud based services with dedicated infrastructure  

High availability solution with inbuilt Disaster Recovery  

Comprehensive dashboards, reporting and analysis  

Flexible document and file creation  

Flexible document management and processing  

EDP Integration

Easily integrate your EDP solution with external stakeholders whether they are customers, suppliers, warehouses, or any other third party.

Configurable outbound communication Processes  

Configurable inbound communication Processes  

Product Supply Chain

De Facto ERP Supply chain for the Wine, Beer and Spirits industry is built using our EDP platform, leveraging our latest solution architecture. Delivering, operational efficiency and productivity, for the supply chain from producer to customer.

  • Products & Pricing
  • Stock Control & Warehousing
  • Sales Order Processing
  • Purchase Order Processing
  • Transport & Logistics

Extensive Products Data Solution

Using the EDP Platform flexibility to handle any extended data, of any type, including, rich text, images or documents.

For the drinks industry, extended data encompasses details such as ingredients, allergens, and precise grower source information. Customisable units of measure range from bottles of varying sizes to cases, pallets, and bulk containers.

Specifications  

Multiple units of measure  

Multiple product codes and descriptions  

Alternative and associated products  

Product restrictions  

Product and Waste Packaging  

Complete Stock Control

Provides real time visibility of stock levels and availability. Flexible warehouse configuration. Extensive batch control and traceability.

Within the drinks industry, especially in the realm of fine wine and spirits, our system manages condition data, images, and provenance documentation. It also enables control over customer-owned stock reserves in any warehouse.

Multiple companies, sites and warehouses  

Third party warehouse control  

Customer owned stock control  

Batch, lot or serial number control  

Internal and external rotation numbers  

Pallets and containers  

Bonded warehouses and rotations  

Quality control and positive release  

Extensive Prices, Discounts and Promotions

Prices and discounts can be set in a variety of ways, for instance, by account, groups, bands, promotions, volume breaks, or from dynamic calculations. Products can be sold and priced in different units of measure. Future prices can be calculated and automatically applied when relevant, whilst a full history of price and discount changes is maintained.

In the drinks industry, our system accommodates pricing for under bond and duty-paid scenarios. It automates duty changes and supports pricing by the bottle, case, or per litre.

Company, country, currency, account and delivery point prices and discounts  

Price and discount groups, bands and breaks  

Calculated pricing and selection rules  

Date based price changes  

Versatile Transaction Types

The De Facto ERP supply chain modules, provide many transaction types and options, from enquiries, quotations through contracts, call of orders and service transactions.

Specifically for the drinks industry, we offer functionality tailored for Ex cellar, En Primeur, Under Bond, and Duty Paid transactions. Those managing client reserves can efficiently handle the brokering and commission sales processes.

Contract, call off and scheduled orders  

Stock reservations & allocations  

Back-to-back ordering, direct or drop shipments  

Bulk distribution and fulfilment orders  

Auto generated recommended orders  

Sales enquiries, quotations and purchase RFQ’s  

RMA returns processing  

Under bond transactions  

Warehouse transfers, counts and adjustments  

Transport service requests  

Sundry service requests  

Comprehensive Transaction Processing

For the picking, receiving, dispatching or invoicing of transactions, for their complete, part or consolidated processing. Reducing workload and costs for the warehouse and simplifying financial transactions for all parties.

For the drinks industry supply chain integration with suppliers, warehouses and customers offers substantial operational efficiency gains, speeding up processing and reducing errors.

Optimised data entry  

Transaction notes, attachments and documents  

Delivery schedules, methods and INCO terms  

Pre-Invoicing, deposits and payments  

Warehouse operation picking and putaway rules  

Digital supply chain integration  

Financial Integration

The complete seamless and real-time integration of supply chain data with the financial modules, ensures that real time credit control and management accounts are easily achieved.

In the drinks industry, meticulous control over supply chain costs and variances is a top priority.

Cost accruals  

Integrated accounting  

Reporting & Analysis (BI)

A comprehensive range of standard ERP reports with extensive filtering and sorting are provided. All reports allow easy single click exporting of data into PDF, Excel etc. The reporting system is included within the overall ERP security solution for controlled access.

Effortlessly access and analyse your data with our business intelligence and reporting solutions. We provide standard and custom layouts, offering data in the form of reports, charts, dashboards, or seamless integration with Microsoft Excel.

Rollback reporting  

Custom reports and charts  

Report delivery  

Dashboards  

Documents & Files

Comprehensive functionality to generate, process, store, and retrieve documents or files. For example, for quotations, contracts, orders, deliveries or invoice transactions, which would also be linked to their related accounts.

General files such as Terms and Conditions are also stored, and then where applicable attached or embedded within system generated documents.

While files such as product images and specifications can be stored for display and download within websites.

To alleviate the paperwork challenge faced by the drinks industry and similar sectors, our integrated document management solution efficiently generates, receives, and stores documents, surpassing the capabilities of third-party solutions.

Design  

Outbound document processing  

Inbound document processing  

Storage and retrieval  

Financials

De Facto ERP Financials for the Wine, Beer and Spirits industry, built using our EDP platform, leveraging our latest solution architecture. Delivering comprehensive, real-time and transparent financial control throughout the enterprise.

  • Nominal Ledger
  • Sales Ledger
  • Purchase Ledger
  • Banking

Financial System

A scalable solution, minimising workload, benefitting from full integration with supply chain, document management and business intelligence functionality. Based on a hybrid ledger structure, providing the data efficiency and transparency of a unitary ledger, combined with the ease of use and control offered by separate ledger modules.

Within the drinks industry, we excel in managing accruals for En Primeur, customer-owned reserves or landed costs, ensuring automatic reconciliation and transparent analysis.

Multi-company  

Multi-currency  

Primary business transactions  

Security  

Nominal Ledger Structure

A flexible multi company chart of accounts and cost centre-based solution, which can be extended to support multiple other independent analysis dimensions (for instance: projects or activities).

In the drinks industry, agencies can configure analysis dimensions by supplier and brand, enabling comprehensive financial attribution of costs.

Account Based Controls  

Account structures  

Budgets, Forecasts and Comparatives  

Transaction Processing

Standard financial business transaction types are provided, their behaviour is configurable and can be extended. If required, additional transaction types with specific functionality can also be created.

Our self-reconciling control accounts, such as 'goods received/despatched not invoiced,' play a significant role in maintaining real-time financial control. This extends to managing landed and delivered costs, as well as rebate accruals.

Efficient data processing  

Allocations  

Reconciliation  

Customer and Supplier Account Journals  

Pre-Payment processing  

Contra accounting  

Accounts, Addresses and Contacts

The structure of customer and supplier data, like all areas can be configured and extended to support any additional requirements.

In the drinks industry "on trade" is an example of the benefit of supporting multiple delivery points and regional structures within a single account. While for larger groups the ability to maintain multiple contacts for specific roles within an account helps direct communications to the correct recipients.

Accounts  

Address Points  

Contacts  

Supply chain integration  

Credit Control

Comprehensive facilities that are fully integrated into the supply chain process, using approval workflows for the controlled setting of limits or release of held orders.

Strong credit control is paramount in the drinks industry, offering the capability to set group credit limits for comprehensive account management, especially within larger groups.

Account Data  

Credit checking  

Statements and chasing documents  

Taxation

Flexible future proof configuration that can support any type of transaction-based system, such as value added or sales tax.

Our fully configurable transaction taxation system future-proofs users in the drinks industry against potential tax changes.

Configuration  

Tax Returns (MTD)  

Tax Data Trail  

Banking

Multi-currency banking is provided for a variety of account types, payment methods and manual or automated processing.

Banking integration may be considered one of the less configurable areas in ERP, in the drinks industry, on trade especially, the ability to automatically generate and process Direct Debit batches can be beneficial.

Account Types  

Flexible Processing  

Reporting & Analysis (BI)

A comprehensive range of standard ERP reports with extensive filtering and sorting are provided. All reports allow easy single click exporting of data into PDF, Excel etc. The reporting system is included within the overall ERP security solution for controlled access.

For the drinks industry like all others, easy access to extract and analyse data is a must, this is provided in standard and custom layouts, as reports, charts, dashboards or simply having direct access to data from Microsoft Excel.

Configurable Financial Statements  

Rollback Reporting  

Custom Reports and Charts  

Report Delivery  

Dashboards  

Documents & Files

Comprehensive functionality to generate, process, store, and retrieve documents or files. For example, for POD’s, invoices, statements, which would also be linked to their related accounts.

General files such as Terms and Conditions are also stored, and then where applicable attached or embedded within system-generated documents.

The drinks industry like most can be deluged by a sea of paperwork that has to be generated, received and stored. The integrated document management takes care of this in a way that 3rd party solutions are unable to do.

Design  

Outbound Document Processing  

Inbound Document Processing  

Storage and Retrieval  

E-Commerce

De Facto E-Commerce for B2B, B2C and multi channel organisations, is fully integrated with ERP for the Wine, Beer and Spirits industry. Leveraging our latest solution architecture to deliver long-term, flexible, scalable, enterprise-grade ERP and website solutions.

  • Personalised design
  • ​Supporting multiple brands and identities
  • Extensible functionality
  • Easy content management
  • Full real time ERP integration
  • Cloud hosted with the ERP platform
  • Security, PCI compliance
  • SEO informed Design

Website Design & Functionality

Scalable solutions, for individual or multiple B2B and B2C websites, providing E-Commerce for multiple companies serving multiple countries, supporting their local language, currency, tax and operational requirements.

In the fine wine industry, traders empower their clients by allowing them to monitor their portfolios and offer their stock for sale on a brokered basis.

Personalised Design  

Responsive and adaptive design, optimised for performance  

Intuitive user experience  

Added value functionality  

3rd party Integrations  

E-Commerce Processes

Begin with being able to effortlessly find the required products, their availability and pricing. Followed by the easy adding of products to basket, with clear feedback. Ultimately, then the ability to quickly review the basket and move smoothly through a clear and concise checkout and payment process.

Users managing their fine wine or spirits portfolios, have the flexibility to relocate their products to alternative bonded storage or forwarders for international shipment.

Checkout processing  

Secure payment functionality  

Realtime ERP integration  

Product Catalogue and Pricing

The ERP platform provides all product and price related data. Additionally, any type of structured dynamic content can also be maintained directly within the ERP system, rather than individually with the website CMS. This could for example be used to provide Product help systems, FAQ’s or Service tracking.

Within the drinks industry, we offer both under bond and duty-paid pricing. In the fine wine sector, the product catalog is structured around stock consignments, complete with provenance documentation and condition imagery.

Product Catalogue  

Prices, discounts and promotions  

External data feed integration  

Content Management System

Used to easily generate and maintain static pages and content elements, templates can be used for these, such as : -

  • Home, info, about us pages
  • Landing pages
  • Blogs
  • News Items
  • Case Studies
  • Press releases

Especially in the fine wine and spirits sector, the SEO value of well-crafted blogs, news, and press releases should not be underestimated. Additionally, landing pages are ideal for those creating specific product offers or introducing new brands to the market.

Easily managed content  

Targeted Content  

Multi-language  

New content release  

External and Internal Portals

The E-Commerce CMS can be used to develop very specific additional sites, sub sites and pages that are specifically for non customer use.

In the drinks industry, these features are instrumental in enabling brand owners to access real-time stock and sales information. They also serve field-based sales teams, facilitating access to customer data, the recording of visit reports, and the setup of agreed prices and discounts.

Supplier portals  

Supply chain partners  

Internal user functionality  

Search Engine Optimisation (SEO) Practices

Whilst the primary element for good search engine ranking is relevant and engaging content, this must be well presented to search engines. Requiring the adoption and ongoing application of recognised best practices. These should not be an afterthought but rather an integral aspect of the design and maintenance of the website.

Websites in the drinks industry, like most others, greatly benefit from an optimised information architecture that aids search engines in indexing all product pages efficiently.

Website Structure  

Tags and mark-up  

Working with search engines  

ERP Supply Chain and Financial Integration

The seamless integration between ERP and Website, eliminates data duplication and processing. Customers created on the website immediately appear within ERP, products added for sale in ERP can immediately appear on the website, while baskets submitted on the website immediately update stock and create orders in ERP.

Particularly in multi-channel scenarios within the drinks industry, real-time integration with ERP supply chain and financial systems ensures precise and constant control over pricing, stock, and credit management.

  • Customers, addresses, contacts
  • Products, prices and stock
  • Orders, shipments, payments, invoices
  • Documents
  • Account reporting
  • Any other required data

Reporting & Analysis (BI)

Using Microsoft SSRS, SSAS and Power BI , incorporating data from website, ERP and external sources, such as GA4 and GTM , to provide comprehensive, insightful information.

For the drinks industry, easy access to data extraction and analysis is crucial. Combining analytics with ERP and website data enhances data analysis in reports, charts, dashboards, and through direct access via Microsoft Excel.

Custom Reports and Charts  

Report Delivery  

Dashboards  

Documents, Images & Files

Comprehensive functionality to generate, process, store, and retrieve documents or files. For example, for orders, deliveries or invoice transactions, which would also be linked to their related accounts.

General files such as Terms and Conditions are also stored, and then where applicable attached or embedded within system generated documents.

While files such as product images and specifications can be stored for display and download within websites.

Websites in the drinks industry can improve the user experience by offering downloadable PDFs for tasting notes, vintage reports, and direct access to fine wine condition images and videos.

Design  

Outbound Document Processing  

Inbound Document Processing  

Storage and Retrieval  

Document Management

De Facto ERP Document Management for the Wine, Beer and Spirits industry, is built using our EDP platform, leveraging our latest solution architecture to deliver long-term, scalable, enterprise-grade ERP solutions.

  • Document Design
  • Outbound Document Processing
  • Inbound Document Processing
  • Storage and Retrieval

Comprehensive functionality to generate, process, store and retrieve documents or files of any type, eliminating the need for integration with 3rd party solutions and providing seamless access to files and documents throughout the ERP system.

Document Functionality

Comprehensive functionality to generate, process, store, and retrieve documents or files. For example, for quotations, contracts, orders, deliveries, POD’s, invoice transactions or statements, which would also be linked to their related accounts.

General files such as Terms and Conditions are also stored, and then where applicable attached or embedded within system generated documents.

While files such as product images and specifications can be stored for display and download within websites.

The drinks industry, like many others, often faces an overwhelming volume of paperwork that needs to be generated, delivered, received, and stored. Our integrated document management system efficiently addresses this challenge in a way that surpasses the capabilities of third-party solutions.

Design  

Outbound Document Processing  

Inbound Document Processing  

Storage and Retrieval  

Reporting & Analysis (BI)

De Facto ERP for the Wine, Beer, and Spirits industry, is constructed on our EDP platform, utilising the latest solution architecture. It harnesses a suite of leading Microsoft reporting and analysis tools, including:

  • Microsoft Reporting Services (SSRS)
  • Microsoft Analysis Services (SSAS)
  • Microsoft Power BI

Diverse Data Sources

Our ERP database, designed with full relational capabilities, is adaptable to encompass all project-specific data requirements. This enables comprehensive reporting and analysis by integrating data from multiple sources, such as:

  • ERP databases
  • Website databases
  • Website analytics
  • Other internal data sources
  • Other external data sources

For the drinks industry, data may encompass under-bond stock, pricing, brand specifics, sub-brands, vintages, customer types (off-trade, on-trade, consumers), subtypes, and more.

Simplified Data Models  

Data Security  

Other Data Sources  

Financial, Supply Chain and Website Reporting

We provide an extensive assortment of standard reports with robust filtering and sorting options. All reports support one-click exportation to formats such as PDF and Excel.

Like all industries, the drinks industry demands powerful reporting capabilities. We provide standard reports and the flexibility to create custom reports, charts, and dashboards. Additionally, our system allows direct data access from Microsoft Excel.

Configurable Financial Statements  

Rollback Reporting  

Custom Reports and Charts  

Report Delivery  

Dashboards  

Harnessing Microsoft Tools

By deploying data analysis and reporting tools from Microsoft, EDP based solutions benefit from the very latest technologies that are utilised in the provision of standard and custom outputs.

Easy data extraction and analysis are essential for the drinks industry and other sectors. For websites, the ability to integrate analytics with ERP and website data enhances data analysis through reports, charts, and dashboards, leveraging Microsoft business intelligence tools. This is complemented by direct data access from Microsoft Excel.

Microsoft Reporting Services (SSRS)  

Microsoft Analysis Services (SSAS)  

Microsoft Power BI  

Contact us
Book a call with De Facto Software
 

De Facto Software Ltd.
Epsilon House
West Road
Ransomes Europark

Ipswich
Suffolk
IP3 9FJ
UK
 

01473 276555
 
 

Office Hours



Monday — Friday