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