Questions tagged [sage50]
32 questions
0
votes
1 answer
Truncate and Round giving more Decimals than expected in MySQL
I'm trying to take values in a Pervasive SQL database through an ODBC connection that represent dollar values and round them to the nearest cent. However whenever I run the TRUNCATE or ROUND functions, I get more digits after the decimal place than…

iverss
- 106
- 7
0
votes
1 answer
Sage 50 UK V26.2.136.0 - How to update ledger of an invoice with sdk code so that invoice could appear on the customer's list activity
I am using the following sage50 uk sdk code (v26.2.136.0) to create invoice.
//Declare Variables
SageDataObject250.SDOEngine oSDO = new SageDataObject250.SDOEngine();
SageDataObject250.WorkSpace oWS;
SageDataObject250.InvoicePost…

Harish Kumar
- 927
- 3
- 20
- 46
0
votes
1 answer
Pyodbc to SQLAlchemy connection string for Sage 50
I am trying to switch a pyodbc connection to sqlalchemy engine. My working pyodbc connection is:
con = pyodbc.connect('DSN=SageLine50v23;UID=#####;PWD=#####;')
This is what I've tried.
con =…

user2407147
- 1,508
- 2
- 22
- 40
0
votes
1 answer
Getting exception 'Non-zero amount must be rounded to whole currency' Sage 50 C# WPF?
When I try to add an amount in AmountPaid field & if the amount = 55.23 then it throws an exception with stated text "Non-zero amount must be rounded to whole currency"
I tried AmountPaid = Match.Ceiling(amount) which changes the 55.23 to 56 which…

Naveed Alam
- 11
- 5
0
votes
1 answer
Getting exception error while creating sale invoice using sample sdk code of Sage50 Canada 2019
Getting the error : SimplySDK.SimplyErrorMessageException: 'Your chequing account is overdrawn. See the Advice topic "Managing Your Cash Flow" for suggestions.'
I am using the following SDK sample code for invoice create:
// Sales Invoice…

Harish Kumar
- 927
- 3
- 20
- 46
0
votes
1 answer
ActiveX component cannot create Sage Data Object
I'm using some slightly amended VBA code provided by Sage to connect to Sage 50 Accounts - this works on some machines, but not with others, despite them all having the same version of Sage (25.1.128), and has previously worked on all machines…

MrClip
- 17
- 5
0
votes
3 answers
"Column not found" error when using "left" "mid" or "Substr" in MS Query
and thanks in advance for any help.
I'm using Microsoft Query to interrogate Sage 50 tables.
I'm trying to create a user defined field containing only the first digit of a customer account reference.
I have been able to achieve this result when…

Steve
- 1
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
2 answers
How can i resolve this issue of database in crystal report?
I have a report up and running in sage 50 with crystal report.
I have another server up and running with sage 50 but with a diferent filename, same version of sage 50 and crystal report.
When i try to run the report its giving me a error .…

don
- 65
- 2
- 10
0
votes
1 answer
Query taking longer than expected odbc sage
I am doing a simple select with a date filter on it with a months range where only 32 records are present however its taking 15 seconds to query and return the data I am using sage 50 as you can probally tell and c#. I am using odbc to create the…

david
- 87
- 1
- 9
0
votes
1 answer
Sage 50 integration with PHP based web application
We have created a web based application and are trying to integrate Sage 50 system with it. On doing some research we found Sage provides SDK for to access Sage functions pro-grammatically. Is there more options available and which is the best…
user10217709
0
votes
1 answer
Sage 50 ODBC on PHP connection string syntax
Connection string issues . Versions - Sage Line 50v24, PHP 7.2.2, Windows Server 2012 R2 64 bit.
Sorry if there is something I have missed - please ask for any missing info in comments. I have spent hours and hours and hours researching this and…

Lyndon Penson
- 65
- 1
- 8
0
votes
1 answer
Create linked server in management studio to SAGE 50 US database using ODBC Data source administrator
I am trying to create a linked server to SAGE 50 using server in management studio but keep getting an error. I am hoping that someone has done this before and can provide some guidance.I set up and tested "ODBC data source administrator (64bit)"…

Castell James
- 329
- 6
- 23
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
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?

Danolad
- 1