SAP Business One blog

  • Start
  • Versino Financial Suite
  • SAP Business One
    •  Special Functions
      •  Alarm functions
      • Authorisations
      •  approval process
      •  Drag & Relate
      •  changelog
      •  orange arrow
      •  data export
      •  Printouts
      •  UI adjustments
      • User-defined objects
      •  Hide features
      • Excel Import
      • Alternative keyboard layout
    •  base data
    •  finance
      • Posting periods
      • G/L account determination
        • Account determination functions
        • Sales & Purchasing.
        • Stocks
        • Extended G/L account determination
      • tax code
      • Currencies
      • Reference field links
      • chart of accounts
      • Manual journal entries
      • Internal coordination
      • Parked receipts
      • account assignment template
      • recurring bookings
      • Exchange rate differences
      • balance sheet
      • bank processing
      • payment assistant
      •  Authorisations in finance
    •  sale
    •  Purchasing
    •  warehouse management
    •  production
      • The production process
    •  MRP
    •  resources
    •  service
    •  staff
    •  project management
    • SAP B1if
    •  Studio
    •  service
    • data protection
    • Cloud Control Centre
    • WebClient
    • Fields & Functions FAQ
  •  ERP know-how
    • ERP basics
    •  The ERP selection
    •  The ERP project
  • subjects
    • Add ons
    • testimonials
    • MariProject
    • ERP
    • Exactly looked
    • SAP
    • versino
  • Versino trainings
  • glossary
  •  FAQ
  • Contact
  • Deutsch
SAP Business One blog

Tag: Excel

Everything to do with SAP Business One, ERP projects and business software

12 may

BI360 Webinar - Excel connects to SAP Business One

  • LB
  • ERP, SAP, SAP Business One
  • Bi, Business Intelligence, controlling, Excel, Forecast, Reporting
  • Kommentare deaktiviert für BI360 Webinar – Excel dockt an SAP Business One an

We already reported here last year on the successor to the XL reporter for SAP Business One.

Read More
XL reporter successor to SAP Business One
5 Aug

XL reporter successor to SAP Business One

  • zeembe
  • Add ons, ERP
  • AddOn, Datenanalyse, Excel, Forecast, Reporting
  • Kommentare deaktiviert für XL-Reporter Nachfolger für SAP Business One

e versions were delivered: the XL-Reporter. With this you could create Excel reports on the data basis of SAP Business One and manage and distribute them within SAP B1.

Read More
Webinar: Evaluate data from SAP Business One with Excel
13 Nov

Webinar: Evaluate data from SAP Business One with Excel

  • Christopher Bierman
  • Add ons, SAP Business One
  • Excel, Integration, Reporting
  • Kommentare deaktiviert für Webinar: Mit Excel Daten aus SAP Business One auswerten

Somehow obvious: SAP Business One mostly uses an MS SQL database. Instead of accessing the data via the application to generate reports, it is of course also possible to tap directly into the SAP Business One database using Microsoft Query. 

Read More
The dangers of Excel: Why collecting data with Excel becomes a problem
20 october

The dangers of Excel: Why collecting data with Excel becomes a problem

  • LB
  • ERP, Exactly looked
  • Daten, Datenmanagement, Excel, Microsoft
  • Kommentare deaktiviert für Die Gefahren von Excel: Warum Daten sammeln mit Excel zum Problem wird

Evaluations, analyses and calculations? Excel go!
However, Excel is used to record hours from projects, collect orders, purchase orders or sales data. But why is this problematic?

Read More
SAP Business One 9.1 - Using Excel
22 July

SAP Business One 9.1 - Using Excel

  • zeembe
  • ERP, SAP Business One
  • Datenanalyse, Excel, SAP Business One, Video
  • Kommentare deaktiviert für SAP Business One 9.1 – Excel nutzen

A new detail function in SAP Business One makes it easier to edit tables. It is now possible to copy the contents out of table views in SAP Business One and into Excel (or another spreadsheet programme).

Read More
Export SAP Business One data easily to EXCEL with SAP 2 Excel
12 may

Export SAP Business One data easily to EXCEL with SAP 2 Excel

  • zeembe
  • Add ons
  • AddOn, Excel
  • Kommentare deaktiviert für SAP Business One Daten einfach nach EXCEL exportieren mit SAP 2 Excel

The SAP 2 Excel tool wants something more. The programme is actually an Excel add-in that makes it possible to dynamically retrieve data from SAP Business One from the Microsoft programme.

Read More
XL - Importer for SAP Business One
26 Feb

XL - Importer for SAP Business One

  • zeembe
  • Add ons, SAP Business One
  • AddOn, Datenmanagement, Excel, SAP Business One, Video
  • Kommentare deaktiviert für XL – Importer für SAP Business One

The SAP Business One ADDON plugs into Microsoft Excel and makes it possible to import journal entries and budgets directly.

Read More
14 Aug

Copy 'n' paste Excel data into SAP Business One

  • zeembe
  • Add ons, ERP
  • AddOn, Excel, Reporting, SAP Business One, Video
  • Kommentare deaktiviert für Excel-Daten per Copy ‘n’ Paste in SAP Business One

Sometimes you run out of imagination about what you can do with a new add-on idea for SAP Business One. However, this new extension will give some people a few ideas.

Read More

Seek

CANDIS for SAP Business One
Newsletter
Versino AG © 2025 / All Rights Reserved
  • Contact
  • Imprint
  • data protection

Sidebar Menu

  • Start
  • Versino Financial Suite
  • SAP Business One
    • Special Functions
      • Alarm functions
      • Authorisations
      • approval process
      • Drag & Relate
      • changelog
      • orange arrow
      • data export
      • Printouts
      • UI adjustments
      • User-defined objects
      • Hide features
      • Excel Import
      • Alternative keyboard layout
    • base data
    • finance
      • Posting periods
      • G/L account determination
        • Account determination functions
        • Sales & Purchasing.
        • Stocks
        • Extended G/L account determination
      • tax code
      • Currencies
      • Reference field links
      • chart of accounts
      • Manual journal entries
      • Internal coordination
      • Parked receipts
      • account assignment template
      • recurring bookings
      • Exchange rate differences
      • balance sheet
      • bank processing
      • payment assistant
      • Authorisations in finance
    • sale
    • Purchasing
    • warehouse management
    • production
      • The production process
    • MRP
    • resources
    • service
    • staff
    • project management
    • SAP B1if
    • Studio
    • service
    • data protection
    • Cloud Control Centre
    • WebClient
    • Fields & Functions FAQ
  • ERP know-how
    • ERP basics
    • The ERP selection
    • The ERP project
  • subjects
    • Add ons
    • testimonials
    • MariProject
    • ERP
    • Exactly looked
    • SAP
    • versino
  • Versino trainings
  • glossary
  • FAQ
  • Contact
  • Deutsch
Cookie Consent with Real Cookie Banner