Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Merchanter
English (UK)
US English (US)
GB English (UK)
  • Home
  • How to use Merchanter
  • OData

Merchanter OData Tables

Which tables are available in Merchanter for reporting and analysis?

Written by Ian Oldrey

Updated at January 3rd, 2023

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Getting Started
    Training Sessions
  • How to use Merchanter
    Sales Invoicing & Credits Products Purchasing Stock Control OData System Settings & Administration Milling & Value Added Processing Sales Order Processing Customers System Release Updates Pricing & Costs Certification Order Picking Agency Sales
  • API Documentation
  • Integrations
    Sage 50 Woo Commerce ECS Webshop Link NearSt QuickBooks Xero ShopWired
  • FAQs
  • Industry Articles
+ More

Table of Contents

Reporting Tables Afinitis Reporting Tables

Reporting Tables

Use in Excel, PowerBI, etc.

  • Credit notes - the credit note records including invoice and account credit notes
  • Customer - details of customer records
  • On Costs - the additional costs around purchases and forward contracts
  • Payments - the payments associated with cash sales
  • Pricing - price tables
  • Product - the product records
  • Suppliers - details of supplier records
  • Sales Analysis - All sales order lines (less matched credit note values where applicable)
  • Sales Analysis 9 Week - All sales order lines from the last 9 weeks (filtered to speed return of data for high volume databases)
  • Sales Header - All sales order headers including totals (less matched credit note values where applicable)
  • Stock Summary - shows the stock quantities and values at a point in time (see article on stock summaries by period)
  • Stock Value Movement - all the stock movements from purchases, milling, sales and adjustments
  • Stock Value Movement by Length - all the stock movements from purchases, milling, sales and adjustments with additional split by Width, Thickness and Length.  This also included breaking down packs by length as well as loose stock.

Afinitis Reporting Tables

Afinitis is a Business Intelligence platform that can be used with Merchanter.  These tables have the data formatted for feeding the advanced trading analysis.

  • Afinitis Companies - Financial business details
  • Afinitis Customers - Customer records
  • Afinitis Invoices - Sales and associated credit notes
  • Afinitis Stocks - Product and stock details
  • Afinitis Suppliers - Supplier records

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • How to produce Stock Summaries using Merchanter OData
  • How to extract Merchanter data into Excel
Solution Vendor Color.png

sales@ten-25.co.uk

01202 861606

Peartree Business Centre, Cobham Road, Ferndown, BH21 7PT, United Kingdom

BMF Service Member logo.jpg
  • linkedin
  • twitter
  • facebook
Privacy Policy

©2020 by Ten-25 Software Ltd.. Proudly created with Wix.com

Expand