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…
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…
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…
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…
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…
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.
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…