• Replace Operation in Bill of material

    Hi, Due to process changes, we need to remove most existing ones from all our BOMs. Is there a faster way to replace an operation across all BOMs simultaneously? Thanks in advance for any help!
  • Sage 200 MRP SQL Query

    Hi, I am trying to build a excel report using SQL to give me MRP demand. I have built 90% of the report but need to add in the works orders required/demand quantities which haven't been allocated to stock. Below is my current query - any help would be…
  • Site to site VPNs and Sage 200

    This was posted to the ideas hub by one of our customers but is more suited to the Community. "Hi Support, I am looking for migrating the Sage 200 professional server to Azure from the Premises using a Site-to-Site VPN between them. So, my questions…
  • Sage MTD for VAT Submissions Module Error

    Hi Guys, I'm getting the error "Navigation to the webpage was cancelled" Screen print attached Any ideas? Regards Michael
  • Hi to send invoices to Print Spooler in Sage

    Hi Guys The Sales Ledger has now been closed for December, but I am still not able to print the invoice in Sage. How do I get the invoice into Sage Spooler for printing. I don't want to post but just print.
  • csv template to import receipts into Sales Ledger & allocate against invoices

    Hi, is there a csv template to import receipts & allocate the receipts to invoices in the sales ledger in Sage 200? I can import receipts to the sales ledger but then I am manually allocating the receipts against invoices. We have payments that cover…
  • Purchase Order lines Nominal code via API

    Hi, Against a purchase order line you can assign a cost centre. I can't see this in the Pop_order_line_views API endpoint and cannot see a way of linking to other endpoints to retrieve it. i can go from Pop_order_line_views. pop_order_line_analysis_code_1…
  • How do I trace Transaction Listings in Sage 200C On-premise

    We have Sage 200c On-premise. The schema comprises of a Cube, Warehouse and Finally Sage Database. How do I know how data is being surfaced? Example: How do I trace data from Opening Balance, Transaction Listings (movements) through to Closing balance…
  • Sage 200 ODBC

    Hi, I am trying to amend a query from Sage as needed to add in the delivery address details but doesn't seem to be working. Below is the original code that I need to amend and have highlighted in yellow in the table below what I am trying to add - any…
  • NIL Posted Nominal Accounts Enquiry

    Hi, How do I get a list of Nominal Accounts which have never been posted to in Sage 200C?
  • Communication Error: There was no endpoint listening

    A customer is getting this communication error when attempting to access SAGE 200 HELP! Any advice is welcome.
  • How to get the users under specific company?

    Hi all, I have the following code where I list all the companies that have the same base currency as the current company. public List<CompanySelection> GetTheCompaniesSameBase() { List<CompanySelection> companies = new List<CompanySelection>();…
  • Sage 200C Nominal Ledger Import Tool

    Hi guys, Our team are looking for an Excel Add-in Tool to help with hundred of lines of Journals Posting for Sage 200C on premise. We will like the Enforcement of Username when posting Journals and Business rules which can be maintained inhouse. …
  • SQL Help

    Can someone help me with the below code? In the below which I have put in bold it only picks up if there is information in Analysis Code 9, but not if the column is left blank. Is it possible to update the below so it picks up where the Analysis Code…
  • Price Change History

    I am trying to work out if there is a part of Sage200 which logs what users are accessing and or changing product pricing on Sage 200 ? Previous Sage 500 had a log of who and when things were accessed and I wondered if Sage 200 also had this?
  • Handling error code of Ex11073Exception kept going in infinite loop

    Hi all, I wanted to bypass this error message with the code below, by referring to https://my.sage.co.uk/Sage200SDKDocs/html/DOC0078_Overview.html#ERRORS . But I only went into infinite loop if I click Yes, and stop the loop is I click No, but my…
  • Sage 200 creates a new record in the Database after changes data

    Hello Team, I use Sage 200 API to receive data and sync them with my application. For receiving AR documents I use the following endpoint - api.columbus.sage.com/.../sales_transaction_views But, I detected that when I change the Invoice, Credit…
  • Filter $skip doesn't work for method sales_transaction_enquiry_views

    Hello Team, Could you help me with the following issue? I am using the method sales_transaction_enquiry_views to receive transaction allocations. Example: https://api.columbus.sage.com/uk/sage200extra/accounts/v1/sales_transaction_enquiry_views?$filter…
  • Invoice PDF via API from Sage 200

    Hello Team, Could you clarify please, is it possible to receive Invoice PDF via API from Sage 200? If yes, could you provide the link to the API specification? Or maybe you could recommend another way how to receive an Invoice PDF for the integration…
  • Receiving removed Account Receivable entities via API

    Hello Team, During the official documentation, I cannot find an endpoint that allows receiving removed Account Receivable entities (customers, invoices, payments, etc.). How I can receive removed Account Receivable entities via API? Could you provide…
  • Time zone mismatch

    Hello Team, I have a question about the time zone mismatch. I found the following issue. To receive customers we use two endpoints: https://api.columbus.sage.com/uk/sage200extra/accounts/v1/customers https://api.columbus.sage.com/uk/sage200extra/accounts…
  • How to receive allocations using API

    Hello Team, I am creating the integration process with Sage 200 using the following API - developer.columbus.sage.com/docs But I cannot find the method how to receive created allocations. For example, I paid the Invoice using a Receipt . Which API…
  • Sage 200 Self service web site externally.

    I have been asked to make the self service website available externally and while we have the self service website accessible internally (someone can open Sage 200 and select "Show Workspaces in Browser" How does it handle the authentication if I make…
  • Sage 200 UK Trial version. Access to API

    Hello Team, I hope you are doing well. The reason I am writing is access to Sage 200 UK API. I have installed the trial version of Sage 200 UK. The link that I used is here https://www.sage.com/en-gb/products/sage-200/trial/#get-started According…