• Use Sage VAT defaults when using SDO Helper C#

    I'm using the Sage SDO Helper in visual studio to generate a Sales order on Sage. I'm trying to have it use the default VAT settings from sage for the products in the order but instead the VAT ends up being £0 instead of 20% like I have set. I've set…
  • Intermittent Sage 50 Version 28 SDO Error: Sage 50 SDO Invalid data path. Please check your connection settings

    Has anybody else come across this error intermittently ? We sometimes get the error after accessing SDO after 8 hours or so of non use. Running the same script again immediately works fine. The data path is on the local C drive. Makes me wonder if the…
  • Insert customer receipt using SDO

    Hi All, I am using SDO (Sage Data Object) to insert data in Sage 50 UK. I would like to insert discount and bank charges in customer receipt. Can some help to find the object name and field name to use? Should I use 'SalesRecord' to insert? Regards…
  • SDO StockRecord Find/Search - Invalid Index for item retrieval

    Hello, I am doing a script for SDO to update specific products. In the past I did similar things with prices and it was successful. relevant lines Set oStock = oWS.CreateObject("StockRecord") oStock.Fields.Item("STOCK_CODE").Value = CStr(Variables…
  • Sage SDO - TransactionPost.AllocatePayment not allocating the full amount to purchase invoice for foreign currency with different exchange rate

    Hey, We are seeing some differences when paying a purchase invoice which is in a foreign currency when using the UI compared to using the SDO. The purchase payment is at a different exchange rate to the purchase invoice. When creating the purchase…
  • SDO Logs

    If I have an object failing to update, it just returns "false". Is there anywhere to diagnose why the SDO is rejecting the update? Kind regards Adam
  • Where are the SDO (Sage Data Objects) logs stored?

    I'm having some difficulty Posting an Invoice via SDO, the .Post() methods just returns "false". I'm assuming there must be somewhere I can look to diagnose why I can't update the ledger, as the invoice is added fine. Cheers Adam
  • 64bit SDO

    Please can you update the SDO to run 64bit. We are trying to develop integrations and many programs are 64bit now.
  • currency change in sales order

    Hi All, I am using SDO (Sage Data Object) to import sales orders in Sage 50 UK. I would like to import Sales Order with the currency USD. I came to know that for that I need to use a specific customer who has USD currency allocated. I am using currency…
  • Set value in TEXT field in invoice line item while importing Invoice.

    Hi All, I am using SDO (Sage Data Object) to import invoices in Sage 50 UK. I would like to pass a multiline text in the details(Text) field. I tried many ways but unable to set value in that field. I tried to pass simple text but the value does not…
  • Sage Invoice items in JSON that do not appear in Sage50 invoice detail view. ?

    Hi Extracted Sage Invoice items to JSON and I am seeing some duplicated invoice lines in the data that do not appear in Sage50 view. I have noticed these items have duplicated indexes so I have 2 invoice items but Sage only displays 1, cannot find…
  • Sage SDO - Invoicing - How to post to ledger

    Hi All, We are working with the SDO and have setup the ability to post most things, Sales Orders, receipts, invoices etc. When I want to post a receipt against an invoice, I search for the customer account, and then search for the invoice by invoice…
  • Import Budgets in Project

    Hi All, I am using SDO (Sage Data Object) to import Project by programming, In SDO v 22. I am able to import a new project. I also would like to update budget values but unable to find the property of an object to set budget values. Can anyone help…
  • Pass value minus (-) in Invoice Line Items.

    Hi All, I am using SDO to import Invoices bt programming, In SDO v 22 it allows me to import (-) minus unit price, but in newer version 26 it is not allowing. Has anybody faced this kind of issue? Is there any idea how I can solve this? Thanks…
  • Add the ability to get GoCardless mandate references through SDO or report

    FormerMember
    FormerMember
    We generate invoices using SDO and only take direct debit payments for certain invoices (recurring monthly fees). We can not get any sort of report to be able to match customers with mandates to our own systems. Mandate references don't appear to be available…
  • Allow Posting of Project Structure Info via SDO

    We currently import projects to Sage 50 via the SDO without problems, but would like to incorporate structure information. However, the structure fields are currently not exposed via the SDO. Can this be considered for a future update please?
  • Is there a fix to stop SDO switching off?

    Hiya, We have Sage SDO enabled to integrate with third party software. I have entered the serial number and activation key. However, I'm having a recurring problem where it works for a week or so before switching off and I have to re-enable it by…