Browse By Tags

  • Connecting to an external REST with an XML header

    I am trying to connect to an external REST library that requires the content type to be XML and not JSON. The web service configuration seems to indicate that this should be possible since you can select XML as the the content type during the setup process…
  • SEPA BANK FILE CHANGES TO SEPA CREDIT TRANSFER WITH AIB AND BANK OF IRELAND FROM NOV 2023

    Dear Sage, We use the facility for some of our clients to create weekly , bi-monthly and monthly bank transfers. I note from recent correspondence from AIB & BOI they will be rolling out something in the coming weeks. I wanted to check if we need…
  • HMRC Stopping XML submissions

    Hi Letter received today saying HMRC from the 8th April 2021 will no longer accept XML submissions just checking sage have this in hand and that online or sage50 doesnt use XML to submit VAT?
  • Error en archivos XML

    Buenas tardes, En todos los ficheros creados en Septiembre para comunicar los periodos de actividad de los centros de trabajo, muchos empleados salieron con código de actividad >2<, hemos logrado contactar con el SEPE y nos dice que este código no debería…
  • How to generate/download SEPA Credit Transfer XML file

    Hello Everyone, Can anyone let me know that how to download SEPA (FRA legislation) XML file after posting payments through manual remittance. I am not sure whether any other software required to download SEPA XML bacs file or any special setup required…
  • GCRM Logging for Sage CRM

    Sage CRM has a logging mechanism in place that when creating an account, quote, contact or other entities from a Sage accounting product integrated with Sage CRM a lot of detail is added to the log files. For example, the 'GCRMSyncEngine.log' file which…
  • How a WSDL Changes when Changing SOAP Web Services configuration

    I have been updating some Web Services code and was trying my test application against a new install of Sage CRM. I needed to change the setting in Administration -> System -> Web Services from Dropdown fields as strings in WSDL file : No to …
  • A Trick to expose an External Table through Sage CRM's SOAP Web Services.

    Sage CRM has the ability to link to external databases. Once an external database table is linked to Sage CRM the External Access settings of the linked table can be changed to allow both SData and Web Services access. I have discussed in previous articles…
  • Security and the SData Gadget and ReadOnly SData provider

    For an introduction to SData REST based web services then please see the article " Accessing SData Provider " Another example of how SData is used in Sage CRM's Interactive Dashboard feature can be found here: " An SData Example — the Sage CRM Interactive…
  • The Design of Web Service Applications and Performance

    My hope is that if you have attended any of my presentations about the Web Services interface for Sage CRM you will have taken away with you an impression of the importance of the design of the client application and how this would affect performance…
  • More about XML creation and the Record.XML property

    Another way of creating XML feeds from Sage CRM is to use the XML property of the COM Record object. The XML property is available in all currently supported releases of Sage CRM. Example Usage var myRecord = CRM.FindRecord("person","pers_companyid…
  • Creating XML feeds from Sage CRM

    In this article I want to think about the creation of an XML feed from within CRM. The structure of an XML feed may look like this: [code language="xml"] [/code] To test this XML do the following 1) Create an empty text file. 2) Save the file…
  • QFX Export from Capital One Credit Card not importing "Error End Document Tag"

    I have successfully imported transactions from several banks and credit cards. However, Capital One credit cards are giving me an error "Error End Document Tag" Which means there is some kind of problem with the xml file. Anybody run into this…
  • Importing Invoices (.imp) does not contain compatible tax information

    I am getting above error that is Importing Invoices (.imp) does not contain compatible tax information
  • Webservice Problems with create work order

    Hi everybody!. I must use webservice to create an work order. I create a web service script with MFG object, and WJMFGXL1 program. I create a XML parameters with the fields that value is INPUT, but always when I run webservice and invoke this xml…
  • Importar NF-e XML - Estabelecimento selecionado não condiz com CNPJ/CPF do destinatário

    SITUAÇÃO: Acessar a função de Recepção de compra (GESPTH) e realizar a importação de XML pelo botão abaixo. Após realizar a importação a mensagem abaixo é apresentada: MOTIVO O motivo da mensagem ser apresentada é porque o CNPJ da tag <dest…
  • Lost my RTI XML files

    I reinstalled Windows 10 and hadn't backed up RTI XML files. The FPS for Month 10 wants to submit all the way back to Month 1. My processing back ups had RTI files included but the restore didn't bring back my XML files. Is my only option to submit this…
  • Sage Ent. Mgmt.: Find examples of using SOAP web services with XML and JSON formats in the Sage KB

    Sage Enterprise Management provides the convenience of being able to use web services which can provide real-time interfaces between the ERP and external applications. We can expose custom or existing Enterprise Management objects and functions as web…
  • Rejeição - nfe:nro element is invalid

    FormerMember
    FormerMember
    Bem-vindos a mais um Café com Rejeição, pois o tempo não para mas caminhão fica parado esperando nota. Hoje vamos falar de mais um erro simples de validação de Schema The ' www.portalfiscal.inf.br/nfe:nro' element is invalid - The value '' is invalid…
  • Rejeição - nfe:IE element is invalid

    FormerMember
    FormerMember
    Bom, todos nós já tomamos uma rejeição ou iremos tomar uma rejeição na vida, mas quando se trata de SEFAZ, existe uma rejeição para cada gota chuva, um caminhão parado para cada estrela cadente. São aproximadamente 510 rejeições diferentes no Layout…
  • Handling of CDATA commands in XML files

    XML files from external sources and other software can contain CDATA commands. CDATA is used to tell the parser that data should be treated as textual data, not as markup. See also: https://en.wikipedia.org/wiki/CDATA#CDATA_sections_in_XML When importing…
  • Collaboration sought for Import of SO Invoices from XML file with BOI

    I am hoping there is someone out there with an ability and willingness to help me. As a Master Developer with have not really had much need to develop things using BOI since we can always modify the code if needed. We have taken the class and we are…
  • Where stored the data returned by the function wSDBFetchRecord ?

    I'm trying to extract data from tables in the database Sage 50 CA 2016, with a Visual Basic application that uses the SDK Sage 50 CA (Simply.ConnectionManagerService.dll). I'm using the function "wSDBSelectRecords" to extract the data And then I 'm…
  • Creating an invoice using SData

    Hello. We are trying to create a bridge between our custom rental management system and Sage 300. The goal is to push data from our system to Sage using SData to create invoices. Based on what we have read on Stephen Smith's blog and found on Sage Guru…
  • Important: Changes to web ROE submissions for Sage 300

    Hi All, This is a quick heads up. After March 31, 2016, Service Canada is no longer accepting web ROEs that are formatted using version 1.0 of XML File Layout. Our team is working to update Sage 300 ERP in order to make sure you're system is ready to…