• How to set up Salary & Supplier Payments in Sage 200

    This video overview is a step by step guide to setting up Salary and Supplier payments in Sage 200.

  • Sage 200 & Go Cardless

    Get paid faster! Find out more about the integration of Sage 200 & GoCardless in our new video 

  • 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 Notes…
  • Sage Report Designer percentage increase in values?

    Hi,

    I have created a simple report that outputs information from purchase orders based on an item code or a supplier and it gives me when,whom and when those items where purchased, with po number quantity and unit buying price. 

    What I would like to do…

  • Cannot find Transaction. This transaction type cannot be viewed here. Please go to Order Enquiries

    Hi,

    I was converting a Pro Forma to a sales order and I recevied an error message. I tried to continue but I kept getting this error.

    I closed Sage and reopened it and it say COMPLETED under document status saying its converted it but it didnt.

    When I…

  • Error during the Online Card Receipt

    Hello Team,

    I know that you are busy, so I'll be brief.
    Could you help me with the following issue?

    I tried to create an Online Card Receipt in Sage 200.
    But Sage returns the following error message:




    Could you clarify which settings I should apply to…
  • 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=cus…

  • Show Analysis codes on Sales Invoice List in the Invoicing Module

    I think that it would be really useful if you could add columns for Analysis codes on the Sales Invoice List in the Invoicing module, in both Sage 200 Standard and Professional. It seems like an oversight that it is missing.

  • Disconnected Logins

    Hi all,

    Just wondering if anyone knows which setting enables someone access to the Disconnected Login screen within Sage 200?

    Disconnected logins would be a frequent support ticket for us and I would like to allow department managers the ability to access…

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

  • To have a field on invoice to populate 2nd ref

    I have had a few clients who wish to raise an invoice from the invoice list and record information at this point which will then post through to the 2nd reference field in the customer transaction enquiry screen.  This could be using the Customer Order…

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

  • Method to identify Reversing Journals and Accruals

    Submitted on behalf of South Tees Site Company.

    Currently when posting Accruals, Prepayments or Reversing Journals there does not appear to be any way of identifying what type of nominal transaction they are.

    So when posting an Accrual and the Reversing…

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

  • Items marked as boms when they are bought parts. Would this affect MRP?

    Hi, can someone answer the question or whether a stock item that is listed as a built part and has a bom attached to it, which has no operations or components because its actually a bought part, would affect anything in MRP if its listed as a subassembly…

  • Sage 200 Stock Movement

    Morning

    I'm trying to get a better understanding of how the Movement Table Works. We are trying to report better on product valuation and aged stock. 

    What does it mean when I have a line where the StockLevelIssued > 0 and the WO and SO in the Movement…

  • Upgrading Sage 200 - Windows 2008

    We have recently been contacted by our Sage Support, telling us our Sage 200 system needs upgrading.

    We are currently running on Windows 2008, and the support have told us Windows have announced they are turning off the server(?) that our Sage connects…

  • Add hash files for downloads on the Sage web site

    When we download files from the Sage web site, it is luck or judgment if the file has downloaded correctly. Can we have either a SHA1 or SHA256 file or hash value supplied with each download so that we can check/verify that a download is complete? Considering…

  • Support for load bearing/roaming servers

    I recently had a case where 1 user was affected when trying to generate payments, several times when they logged in to process the payments it wouldn't generate a unique number, as it is meant to do and this would cause issue with the process.

    The…

  • Importing prices and its stripping out a comma

    Hi,

    We are going through a price increase and for some reason when I try and import the prices some of them fail with a "Price entered for price band is linked to standard price. Price ignored"

    If I look at the Error log I can see that its erroring…

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

  • BOM Bug

    Hi Sage 200 Support

    I have been asking for this since we migrated from Sage 50 to Sage 200. 

    Is this ever going to be fixed? If I am not mistaken this has been like this for years. The last answer was given to my BP:

    "This is in the list of higher…

  • Sage 200 Report Designer - Join Not Detecting New Column in View

    On our picking list report we've got a join to an SQL view called 'SOPAdditionalChargeView' which is used to display the additional charge line for the order at the top of the picking list. Without going into too much detail I have added a column to this…

  • Sage Provisioning Portal update

    On Sunday 13 February, we're updating the Sage Provisioning Portal. This means the portal won't be available between 07:00 and 09:00.

    This update doesn't prevent your use or access to Sage 200, however, you won't be able to access the portal at…

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