Welcome to the Sage 50 Canada Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hi All, I got This customer often pays late. See the Advice topic "Handling Overdue Accounts" for suggestions errors for creating an Invoice using SDK. This line of my code throws an error. => objSalesJournal.SelectAPARLedger(name); //set customer name…
hi all,
I am getting this error while importing Orders. can anyone suggest how to resolve it??
Sage 50 CA Error with SDK "Customer Ofen pay late. see the advice topic Handling Overdue accounts" for suggestion
Thanks,
SF
Hi all,
We're developing a COM-aware .Net assembly that is used in a legacy VB6 app and keep getting the above message when opening a connection via SDKInstanceManager.Instance.OpenDatabase. When we call our method from inside another .Net assembly…
Hi all,
Is there anyone has an idea to export the data from Sage 50 CA? I was looking at the method w the class "CustomerLedger" but it has only the Save method it does not have the get method, Please let me know if you have any idea of hints to solve…
Hi,
I am trying to update invoice's total tax using below code
TaxSummaryInfo taxSummaryInfo = journal.GetTotalTaxAmountInfo(); if (taxSummaryInfo.GetCount() > 0) { double totalTax = 10; taxSummaryInfo.SetTaxAmountByRow(1, totalTax); taxSummaryInfo…
Hi Team,
I am new to Sage50 SDK development in C#. My Sage version is "Sage 50 Quantum Accounting 2019.3 (Canadian)"
Getting started understanding development process, I downloaded Sage50SDK20193 and installed it. Here i found C# sample code, and…
Hi,
I am trying to get all active Tax Codes and iit's taxes using .NET SDK.
From tTaxAuth table, I can get all Taxes ,from tTaxCode I am able to get all taxcodes and from tTxCdDtl table I am able to get Tax rate for each Taxcode's tax.
I have removed…
i'm sure this is an easy fix, but i'm not sure how/what to do...
I have a Small VS C# console app that creates invoices in SAGE 50 for me.
When i enter a existing customer name all is good, but if i make a mistake and the customer does not exist…
Hi Guys, I'm fairly new to Sage 50 SDK
Quickly, i used the sample code and did some modification so it does what i need it to.
I am using a easy peasy loop to read a SQL table and "copy" invoices into Sage.
i'm am getting issues with a few accounts…
Hello Friends,
I am using SAGE 2019.1 SDK for importing invoice in my application. I am getting error at the time of SetShip date "The field you are trying to change or function you are calling is not accessible under current circumstance.". I am getting…
I upgraded our sage .Net SDK to 2018.0. But now when I run our application and try to access sage data I get an exception: System.String Sage.Simply.Work.Repository.get_Func19()
on this line of code:
SDKInstanceManager.Instance.SetAlertImplementation…
I upgraded our sage .Net SDK to 2018.0. And from .Net 4.5.2 to 4.6.2. But now when I run our application and try to access sage data I get an exception: System.String Sage.Simply.Work.Repository.get_Func19()
on this line of code:
SDKInstanceManager…
Downloaded the Sage 50 SDK (Simply Accounting) that has C# Example code to run if we want to add information to Sage 50 Accounting Software.Nothing has been modified on my side yet but running the example code i am getting Following Error.
Could not…
Hi,
A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having.
We are trying to create POs, Time records, and add Cost Codes to the DB.
Reading…
Is it possible to use the SDK to import employee pay into Sage? I'm thinking it would need to be able to create paychecks but if anyone knows of a better way for employee pay please let me know. I know you can import employees but I want to take all their…
Hi,
I'm trying to work through the C# sample project in the Sage 50 Accounting SDK (Simply) but for some reason I can't get the opendatabase connection to let me access the database. I have set up my user in the Sage app and I know my username and password…
I am trying to go through some of the code examples in the SDK, obviously one of the first functions that runs is the database connection function. I have tried sysadmin with various passwords but I can never successfully connect to the database to try…
I am using the .NET SDK (C#) to export invoices and payments of those invoices from my own database into Sage50.
I managed to create invoices (payment type = pay later) in the Sage50 db using the SalesJournal class.
I now need to add payments for…
I need to be able to read the Sage DB using EntityFramework (EF), and The SDK Connection Manager.
Other users are currently working with this company. You may open the company in multi-user mode or wait for the other users to stop using the company…
I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table).
Here is the information that…
I'm working on the integration of Sage 50 CA with a third party application with .NET. And price levels are within the required information extracted from the database Sage 50 CA, but so far I have not found any information to verify the existence of…
Does anyone have an example of how to receive a payment via the Sage SDK? It's looking to me like you have to go directly at the tables (which is a HUGE gap in the SDK in my opinion) but that sounds risky. Anyone know how to do this?
Hi All,
I am getting the message Strong-name signed assemblies must specify a public key in their InternalsVisibleTo declarations. when I am calling OpenSalesJournal in the 2015.3 SDK. The call stack is:
System.MethodAccessException: [F:\Development…
Hey Guys,
Any update on this issue iv been looking all over the internet for a solution to this issue. I have .net 4.5.2 installed on my machine and the target framework set to 4.5.2 to no avail any other suggestion would be greatly appreciated thanks…