• 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
  • Where are supplier email address's stored?

    Hi, I am currently trying to work out where the suppliers email address's are stored, if I go to Purchase Ledger > Suppliers List, there is a column here called "Contact Email" and if I double click an entry then click "Account Enquiry" the address…
  • 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…
  • NIL Posted Nominal Accounts Enquiry

    Hi, How do I get a list of Nominal Accounts which have never been posted to in Sage 200C?
  • Sales Orders List - Slow Searching

    Hey, We often find searching on the sales order list painfully slow, often leading to lock errors and time outs when searching an order number, Even when filtered down to orders from the last week it can still be super slow. Oddly though, if we do…
  • Stock Item Supplier

    Hello, We have a Purchase Order layout that I'm trying to configure to use the Stock Item Supplier Code (From Stock Item details > supplies tab). The issue I'm having is getting this to show the correct stock item supplier code if there are multiple…
  • Sage 200c Professional upgrade

    Currently on sage 200c Professional, now been told by the sage partner that this is coming to end of support January 2023, which means we have to upgrade to Sage 200 2022 R2. We are under support contract etc with the sage partner, but they have quoted…
  • 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…
  • 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…
  • 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…
  • Moving Sage 200 app server to a new server

    Hi, we are currently in the process of migrating our servers to Microsoft Azure. As part of this we would like to test Sage 200c Professional in Azure and determine client specifications etc..as I understand Azure Virtual Desktops is not supported. …
  • Is it possible to integrate data from Sage 200 using access to the Sage database?

    Hello Team, Could you clarify, is it possible to integrate data from Sage 200 using access to the database?
  • Customize form suddenly got error related to Sage library

    Hi all, I have a customize form that have been working for ages. On recent changes, it got error on customer side, while on my local PC the form is still working. Looking at the error, it is related to Sage library. The only difference from customer server…
  • Integration with Sage 200

    Hello Team, Could you please help me with the following questions? 1) Is it possible to integrate data from Sage 200 via web API? 2) Does Sage 200 have a cloud version? or it is just an On-Premise version?
  • Why can't I cancel an order that is part/fully received or part/fully invoiced?

    Why can't I cancel an order that is part/fully received or part/fully invoiced? My business has used the POP module in Sage 200 for a number of years and I only recently explored he possibility of using it for commitment reporting, i.e. goods received…
  • Commercial Invoice Date Criteria

    I need to add a criteria to our commercial invoice sage layout to allow filtering by despatch date. Essentially I need to be able to print the invoice with only items from the order that were despatched that day. Is anyone able to advise what would be…
  • Allocate traceable stock to Works Orders based on Use By or Sell By date

    Would like to allocate traceable stock to Works Orders based on Use By or Sell By date. You can do this in SOP but not in Works Orders. But the requirement is still the same i.e. to use up the older stock stocks first i.e. FIFO. However Works Orders…
  • PEPPOL

    Afternoon everyone, Has anyone come across any solution or add on available for Sage 200 for submitting/uploading invoices via EDI to PEPPOL There does not appear to be anything in the Sage Marketplace, yet it has been mentioned a few times on Ideas Hubs…
  • Execution Timeout Expired creating works order from sales order

    Sage 200 cloud Pro 12.00.0031. After importing stock records and stock opening balances, customer created sales orders. After creating a BOM for one of the products, customer checked the 'Create Works Order' checkbox on the sales order line item and…
  • Allocating Credit Note

    Hi- When we are trying to allocate a credit note in the sales ledger (customer allocation screen) we are getting an error message saying "an error occurred uploading customers. Please try again later" This has been reported to sage but i was wondering…
  • MTD and Visibility to the Sage 200 community of ongoing/ emerging issues

    Hi, I gather from speaking to one of the chaps on Sage 200 technical support that there may be emerging issues with trying to submit Making Tax Digital returns across a number of Sage applications. This manifests itself when the E-submission module…
  • POP Purchase Order Report - Grouped by DeliverToGroup - Where is this set?

    In our POP Purchase Order Report the data is grouped by DeliverToGroup. When printing some Purchase Orders we have the value in this field set as 0, 1 or 2 even though we do not group our orders by different delivery points, at least not intentionally…