Browse By Tags

  • 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…

  • Error HRESULT E_FAIL has been returned from a call to a COM component.

    Good day, I am trying to export data from my local sql DB in sage. I am new to sage integration, so i have narrow knowledge on this subject matter. When i inserting InsertInvoiceDetailSoftCols() i get an exception "Error HRESULT E_FAIL has been…

  • PORCP1headerFields.FieldByName("RCPHSEQ").SetValue("0", false) || Returns "Object reference not set to an instance of an object"

    Good day, Please assist, I have C# code to export data from my local DB to Sage. When inserting invoice headers I get "Object reference not set to an instance of an object" I am fairly new to project and Never worked on sage before. I have a very…

  • Missing record to calculate taxes

    I am getting this error "Missing record to calculate taxes." while trying to import Sales order in Sage using BOI. Has anybody faced this issue before? OR anyone has some idea how to solve this. Appreciated your help

  • How can I get the last date the item was updated in the inventory?

    Hi Expert, Currently, I need to get last date and time the item was updated in the inventory and date and time when the item was created ,I did not find the field related from the method which can get the inventory information supported in the Sage…

  • How to set date range for customer export? sage50 api question.

    Im exporting sage50 customer details in this code. Please let me know how can I set date range to the exporter object so that will pull only contact updates within certain dates. Code- exporter = (Export)ptApp.CreateExporter(PeachwIEObj.peachwIEObjContactsList…

  • Export G/L Trial Balance

    We are using COM API to export G/L Trial Balance data from sage. We are getting current balance but we require last year ending balance, so anyone have any idea to fetch last year ending balance through COM API for trail balance.

  • BOI SETVALUE/CLEAR Error Handling

    Hello, We recently ran into a problem while importing AP invoices as a batch. Here is a summary of our code in C#: // Loop though AP invoices a batch foreach (var invoice in batch.NonInventoryInvoices) { try { service.Call("nCLEAR"); service…

  • Importing and Exporting using .NET API

    Hello Everyone, I am having trouble figuring out how to import and export to and from Sage 50 Quantum using the US SDK. I have gone through several of the sample apps and I am just not seeing how things are transacting. I want to import CSV files in…

  • All lines have not been distributed - Invoice Import using Interop DLLs

    Hi All, I got the issue while trying to import the Invoice into Sage. I am using BOI Interface with the C# code. I am getting this "All lines have not been distributed." error while importing, Can anyone suggest me to solve this problem? Thanks…

  • Duplicates Customer Id skip and Import to sage 50

    Hi, I am using sage 50 U.S Edition and Visual Studio 2013. I need to import sales order csv file to sage 50 if customer id is not available in sage 50 customer details that sales order customer id will be import to customer details ,if already exists…

  • Import using interop DLLs program

    Hi ALL, I have imported the Invoice record in Sage 50 US using interop dll program, But it is not returning GUID is. Can any one help me to get the working? string path = System.Windows.Forms.Application.StartupPath; string FileNameXML; string…

  • Unable to read line level data

    Hello I am trying to read data from SO_SalesOrderDetial i tried setting key value to read data for a given sales order i am able to get data using GetResultSet but i am not able to read values like price , ordered etc and when i am trying to use…

  • Error 26 : variable type invalid

    Hello i am trying to read data for each line in sales order and i am getting a error , i am not sure why i am getting this error cause the same code is working for few lines but not for few this is my code ##################################################################################################…

  • item price using boi in sage 100 /mass 90 /mass 200

    Hi i am trying to read item code, item description,and item price of all the items, i am able to read both item code and item description in an object but i am getting item price as null or empty string . can any one help me out on how to read a…

  • Creating Sales Order with Payment/Transaction data

    FormerMember
    FormerMember
    I'm trying to create Sales Orders within Sage 100 via C#, but I've been having trouble including payment information. I wonder if anyone could please help get me on the right track. I've been able to set a Freight Amount, but I've not be able to set any…

  • Is it possible to import employee pay into Sage using the SDK?

    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…

  • 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…

  • Add payments to invoices added through the SalesJournal?

    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…

*Community Hub is the new name for Sage City