• How to remove the selected customized menu folder from menu file "MenuDifferentialFile"?

    Hi all, In my developer environment, I have customization for multiple customers, lets say customer A, B, and C. I create folder in the menu for each customer, and place the customized forms for each company accordingly. When I export the MenuDifferentialFile…
  • How to write off quantity programmatically?

    Hi all, My Stock Item is sold by weight quantity in decimal. this situation often left the balance as less than 1 i.e.: 0.002, 0.003 and so on. This happen to a lot of stock items, so I wanted to write off the Actual Quantity and Free Stock Quantity…
  • Error Sage.Common.ProgrammingByContract.PreconditionException: 'Contract Failure: A referential integrity exception on update has occured. This method should be overriden by the subclass.' when trying to add new financial currency on another compa

    Hi all, Lets say I have 3 companies of the same base currency, Company A, B, and C. When I add new financial currency on Company A, I want to add to Company B and C as well. So I am using the code below, which I refer to this site https://my.sage…
  • Disable option to dispatch an order if customer account is over credit limit

    When an account is over credit limit and you add a sales order it rightly goes on hold. However users are able to change the order status to off hold, then dispatch the order via the sales order list screen. (if the order is opened, click save and dispatch…
  • 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…
  • How to get the transactions of stock item, programmatically?

    Hi All, I have an inactive stock item that have not been use for so long (>2 years) and the known transactions has already been archived. My customer would like to remove it from the system. But we encounter this error as attached. So I attempt to delete…
  • Report Designer

    Hello, I have a question about getting a net value on a nominal transaction report. I have a column for Debit and Credit but the net value is not calculated. Thank you
  • 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…
  • How to sort currency on Currencies & Exchange Rates with default currency on top?

    Hi all, I need to sort the order of the currencies & exchange rates but with several important currencies such as EURO, Pound, and USD on top, while the other currencies (in the red circle) should be sorted alphabetically. I have tried "Allow…
  • MPS Read Demand routine is already in progress

    Hi, For some reason our MPS read demand routine failed last night and now we cant run it again as it says its in progress "somewhere", but its not and there is no disconnected logins, so obviously its a flag set somewhere. I have googled around and…
  • How to automatically add customized form to Menu after assign roles?

    Hi all, I am a developer making customized solution for my customer. Usually when I create forms, I will have to assign the roles to the forms, and after that I need to add the forms 1 by 1 to the Menu. If I have 20 new forms, then I will have to do…
  • sage bank feed login window cannot be displayed

    Hi there, I am trying to set up a bank feed, but I am getting this error message.
  • Sage 200 budget allocation/amendment

    Is there a way of adding budget values within a project? For example, we have a project agreed for £5,000.00 materials, £2,000.00 sub-contractors and £1,000.00 lab analysis = total £8,000.00. When the contractors are on-site they realise they need additional…
  • 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…
  • 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…
  • 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. …
  • 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…
  • 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…
  • 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…
  • 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…
  • 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…