Browse By Tags

  • This customer often pays late. See the Advice topic "Handling Overdue Accounts" for suggestions.

    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…
  • Sage 50 CA Error with SDK "Customer Ofen pay late. see the advice topic Handling Overdue accounts" for suggestion

    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
  • Export data from Sage 50 CA using SDK

    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…
  • Get all active Sales Taxes

    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…
  • SalesJournal SetShipDate The field you are trying to change or function you are calling is not accessible under current circumstance.

    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…
  • ValidationException when building CustomerCreditMemo - Sage 50 SDK .NET

    Greetings all, We use the .NET SDK for Sage 50 to integrate our software with Sage 50. I've got a situation where we're trying to make a Credit Memo in our software to push over in to sage 50. During a relatively routine step, we are getting a Sage ValidationException…
  • Sage 2018 - upgraded to 2019 and then downgraded back to 2018, now API won't work

    We have written a program for one of our clients using the Sage Peachtree API. Every time they upgrade versions, we always have to get the latest DLLs and rebuild our app to make it work again. However recently they say that they installed Sage 2019,…
  • NullReferenceException when creating invoice line items

    Getting this error when I try and add lines to a new sales invoice: // Create invoice var invoice = Company.Factories.SalesInvoiceFactory.Create(); // Invoice #, Date, Customer ID invoice.CustomerReference = customer.Key; invoice.ReferenceNumber…
  • There was a problem opening company.: (inner exception: FileNotFound)

    var companyId = GetCompany(); try { // Request authorization from Sage 50 for our third-party application. AuthorizationResult authorizationResult = Session.RequestAccess(companyId); This line Session.RequestAccess throws a PeachtreeException: FileNotFound…
  • SDKInstanceManager OpenDatabase always returns false and has no error messages

    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…
  • CriptographicException and System.InvalidOperationException

    I can hit all the sample databases and my private database locally; however, when deployed I get this exception: System.Security.Cryptography.CryptographicException","StackTrace": " at Sage.Peachtree.API.PeachtreeSession.VerifyOrRequestAccess(CompanyIdentifier…
  • Where payment terms are stored for the customer in Sage 50 CA Edition?

    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…
  • Exist the price levels in Sage 50 CA?

    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…
  • Strong-name signed assemblies must specify a public key in their InternalsVisibleTo declarations.

    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…
  • Sage 50 2016 SDK - The type or namespace name 'Sage' could not be found (are you missing a using directive or an assembly reference?)

    Hi, I tried to connect to Sage 50 2016 but It is impossible, when I compile my code, I get this error: Error 4 The type or namespace name 'Sage' could not be found (are you missing a using directive or an assembly reference?) It is a little weird…
  • dbClient.GetConnectionInfo(szFileDir, szHost, szPort) parameters

    I'm writing an application in VB.NET to run custom queries against the Sage 50 database. I've gone through the SDK manuals, but have some additional questions while walking through the sample code. We run the connection manager on the server and install…
  • Purchase orders and character limits

    Currently i am working on a program meant to create purchase orders using excel files to import some data into said order. So far the only problem i seem to keep having is that certain things, such as the Term and Address fields have a "Character limit…
  • SDK Getting Started

    I am a senior developer who is VERY new to Sage. I haven't ever used it or even seen it. A client wants me to use the SDK to get some very basic invoice and payment information out of Sage 50, but even the "Getting Started" info around here seems a little…
  • setting the ReferenceNumber when creating (importing) a new SalesOrder into Sage50

    Hi, What is the recommended way to set the ReferenceNumber when creating a new SalesOrder. Currently I'm doing this: var invoiceList = sageCompany.Factories.SalesOrderFactory.List(); invoiceList.Load(); var top1 = invoiceList.OrderByDescending(x …