Browse By Tags

  • Allow ODBC Connection to Reocurring Data

    Allow ODBC connection or connection via sage report designer to the table that holds the data of reocurring invoices, including frequency, value, start date, invoice item lines etc. This would allow us to audit the reocurring invoices setup in our software…
  • Can I connect to Sage via Data Source Connection in Excel (Data Export)

    Hi there Is it possible to set up an external query / database connection (ODBC/SQL/Web Query), so that I can automatically import & refresh my custom Excel reporting using my Sage Business Online Accounting data? I am currently exporting as csv…
  • Import Excel in SageX3 v12

    Bonjour, Nous utilisons dans la grande entreprise où je travaille Sage X3 comme ERP, dans lequel nous stockons un nombre incalculable d’informations que nous générons d’abord dans Excel. Je cherche un plug in ou quelque chose de similaire qui permettrait…
  • Empty Sage50 database table : Connection with Power Bi/Excel

    Hi, I am a business intelligence developer in my company, importing data from sage50 database into Microsoft Power bi right now. One specific table, Update_Ledger, is not showing any data and this is the main table for our reporting needs. Why is it…
  • Exporting Data

    I need to export all of my data from Sage CRM into excel spreadsheets. I can export Companies, People and Leads into excel spreadsheets but I cannot export my Projects as there is no "export to file" button. Why is this and how can it be fixed? The…
  • Data upload customisation

    Hi All, Is it possible to add new upload option to existing upload options(company, Individuals and leads) ? if Yes, please tell me how. I need to import data from excel/csv into new custom entity.
  • Excel Functions Re-order Levels

    FormerMember
    FormerMember
    Hi everyone! I've scoured the internet and still can't find an answer to my question. I use Excel to keep track of large projects and stock levels, as well as how many complete sets I can make of a project. This also helps me see what is holding…