Questions tagged [sage-erp]

Sage enterprise and accounting software

Sage enterprise solutions http://na.sage.com/us/erp has a large suite of software including many database solutions. Sage city http://sagecity.na.sage.com/ is a good place for questions as well.

104 questions
0
votes
0 answers

Why are autogenerated fields being removed when I use an event listener in jQuery JS

I am using jQuery on Sage Intacct and am trying to have this grid update live time when information is entered, this information being quantity and price, these two will be multiplied to update the total amount field. [![picture1][1]][1] as seen in…
mferraro
  • 65
  • 5
0
votes
1 answer

Is there any method to connect SAGE 50 data to Power BI?

So i have my whole business data in SAGE 50 UK, i want to import the data (sales...) from SAGE 50 to Power BI desktop to create a dashboard but unfortunately Power BI doesn't support importing data directly from SAGE, is there any solid method to do…
Hamza B
  • 3
  • 3
0
votes
1 answer

sage x3 3rd Party Webservice XML

I'm trying to make a call to a 3rd party webservice using Sage X3 scripts, I'm using the func ASYRWEBSER.EXEC_HTTP which is working fine and it's calling the webservice and receiving the answer The Answer:
Rui Leming
  • 61
  • 10
0
votes
1 answer

Sage50 Canada SDK location

Does anyone know how to access the latest sage50 Canada version SDK? With the UK version it is included in the application files but I cannot locate the equivalent with the Canadian version.
Tim Bowers
  • 41
  • 3
0
votes
1 answer

Referencing different ActiveX versions from C# as one

I'm quite struggling when trying to to what follows. I'm currently using an ActiveX, through an interop dll generated by Visual Studio (more precisely tlbimp, implicitly). Different versions of this ActiveX exist, that sometimes add, remove,…
Poc
  • 109
  • 10
0
votes
1 answer

Sage 200 : Could not add many *.dll files in to my visual studio c# project to make sage 200 basic functionality work

I am trying to add about 200+ dll files into my visual studio project (sage 200 assemblies files) but when i go to Project -> Add Reference section and browse for the files it show me nothing. I can browse around 30-50 files easily and that can show…
Harish Kumar
  • 927
  • 3
  • 20
  • 46
0
votes
1 answer

How to pull email addresses from Sage50

Is there a way to pull all the email addresses ever entered from Sage50? I have tried report designer and csv export, to no avail. I can export a huge number of phone numbers, but would ideally like email addresses.
user14563189
0
votes
1 answer

Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.PeachwServer.Application' - Sage SDK 2018 CreateCustomerDemo c#

I'm very new to Sage 50 SDK and when I try to run the sample c# code sample, I get the following error message. 'Save failed: Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.PeachwServer.Application'. This operation…
Shekinah Budhai
  • 77
  • 1
  • 2
  • 11
0
votes
0 answers

Sage 300 V2020 development environment

I've inherited a couple of Windows Form Applications written in C# - MS Visual Studio 2012 that interact with Sage 2016. Both apps interact directly with Sage's SQL Server database. Additionally, one of them also uses Sage / ACCPAC classes. The…
NickSO
  • 33
  • 2
  • 6
0
votes
1 answer

Date to numbers word in SageX3 Crystal Report

Problem: I tried to create a formula in Crystal reports to convert dates from numerical to text in French (example: 01/01/2002 -> deux mil deux le un janvier) but when I print it in sageX3 it converts to ENG. This is my code: Local StringVar year_…
Anas El
  • 9
  • 2
0
votes
0 answers

Using sage dll's within .NET Core

I have a console application with .NET Core and need to use the dll's from Sage which depends on .NET framework. I need following: Actually it can compile and run through, but then I get following error while creation a session and mandant: Could…
everydayXpert
  • 785
  • 2
  • 11
  • 27
0
votes
1 answer

Issue migrating a SQL Server 2000 database

We are migrating a SQL Server 2000 instance to SQL Server 2017. I was able to move all databases successfully through SQL Server backup-restore but having problem with one database. I am even able to move this database but the problem is when users…
0
votes
2 answers

How to fix : The multi-part identifier "%.*ls" could not be bound

i'm working on one big query to retriview certain DATA in a SQL Express DB and i'm facing issues while merging two queries. I already tried to make an inner join on the global second query but since i use a certain GROUP BY for my sum, i didn't…
0
votes
1 answer

How to get Sage 50 Api key and secret

I am new to the sage 50 and not able to find any proper documentation on this. I have created account in sage 50 also registered developer and have developerId and applicationId. According to this documentation…
Pritika
  • 296
  • 1
  • 17
0
votes
1 answer

How to create SOTAMAS90 DSN?

I have a Sage 100 ERP install running on a server and I would like to make a database query through Excel to pull data from the database. I'm running a 64 bit operating system and when I look in the 32 bit ODBC Data Source Administarator, the only…
Nick Ysidron
  • 36
  • 1
  • 10