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

Cant find control on a form there for need to trap for that

I am working with sage 200 summer edition and I have an issue with a piece of code I need to be able to do a null check on the Sage.Controls.Button but even if I place it into a var it will still crash its what is called an amendable button in…
Dave
  • 233
  • 2
  • 12
0
votes
1 answer

DataGrid generating blank rows

I am populating a DataTable with some values (after defining the column names) and then using it as a data source for a Sage Grid - functionally very similar to a WinForms DataGridView. So far, I have tried adding the data type to the DataTable…
Oliver Dalton
  • 379
  • 2
  • 16
0
votes
0 answers

How to connect and query through ODBC connection a Sage 200 database?

How can I connect and fetch data from a Sage 200 database through a ODBC connection using C#? I have no code to show because I'm stuck even with the connection string part... I found tutorial or article only about MySQL, Microsoft Server, and…
Mutu A.
  • 248
  • 3
  • 17
0
votes
0 answers

Duplicate the Database of Sage Server on PgAdmin

Have you any idea about how to duplicate the Database of Sage Server on PgAdmin? I did this with SSMS and it works but i want to get it with PgAdmin. Otherwise, can we add a microsoft database to pgadmin?
0
votes
1 answer

Sage X3 cannot acess table values

Hi there can anyone help me in Sage X3. I made a new table (ZITEMECO) and a new screen (ZITF0) to use inside OITF window but I'm having trouble to read the table, it appears that $LIENS action not working at all, what am I doing wrong? Here is the…
Rui Leming
  • 61
  • 10
0
votes
0 answers

Setting up Sage 200C

I have setup and installed sage 200c but my computer is a domain member and not a workgroup I have added the user into the sageadministrator group but yet I am still presented with this dialog. The same happens for the sageuser group I created. My…
David B
  • 315
  • 3
  • 13
0
votes
1 answer

Connection template, resetting connections and looping thru

Back Story I am working with SAGE Mas 200 software, trying to link to it through Access. This software houses date for 300 investors for my company. With EACH investor I have a different investor ID that goes along with my UID and Password upon…
0
votes
1 answer

php - odbc returning 2 decimal points instead of 4

I have developed a system that gets product data from Sage 50 Accounts via an ODBC connector. The sync works great however I'm struggling hugely with product prices being rounded up/down and I can't figure out why. I have researched this extensively…
LinusIT
  • 1
  • 4
0
votes
1 answer

Sage 50 Accounting SDK Creating Sales Quotes with many Items

I'm using the SAGE 50 Accounting SDK C# and I need to create Sales Quotes with Items. I already achieve to create the Sales Quote record and only 1 item, but if I want to add more than 1 item, seems like SAGE is creating one sales quote record with…
Edgar
  • 194
  • 1
  • 12
0
votes
1 answer

Server 2016 Essentials and Sage 300

We have a small business and just bought Server 2016 Essentials to run Sage 300. When trying to install Sage 300, it says : "Unsupported Environment - Sage 300 does not support installing on a DC". That's a problem because Essentials Server must be…
Shawn
  • 3,031
  • 4
  • 26
  • 53
0
votes
1 answer

Connecting to Sage 50 database using SQL

I want to append a secondary invoice number to the invoice number generated by Sage 50. I want a new number to be generated automatically and appended to the primary number. How do I do this?
0
votes
1 answer

connect to odbc sage 100 using PHP

I want to connect To SAGE commerciale 100 using odbc sage with php : I've succeeded to connect only with MS Excel. But with php I didn't this my php code : try { $conn = odbc_connect("Driver=SAGE Gestion commerciale …
Sabra
  • 177
  • 2
  • 19
0
votes
1 answer

SAPUI5 - Open new app through component.js

I'm developing a type of Launchpad do Fiori but using data from Sage X3. Do you know if it's possible have 2 local aplications where one calls another through Component.js ? Can you help me with this ? Best Regards
0
votes
1 answer

Aged Debt Report on Sage200 - LinqDataProvider

Im trying to pull sql script that builds Aged Debt Report on Sage200 Report Designer. This report is out of the box I have a powerbi model which pulls data from Sage Datawarehouse, however I am struggled to replicate the above report into powerbi…
PeddiePooh
  • 403
  • 8
  • 17
0
votes
1 answer

Sage Murano api

Does anyone know if sage murano has an api? I've been 1 hour searching for documentation about sage murano api or webservice and I didn't find anything. I know sage one does have an api to access from external code but it is possible that sage…
Gerard Luque
  • 163
  • 2
  • 13