• 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?

  • How to get current user programmatically?

    Hi all,

    I see that Sage 200 have this class: Sage.Accounting.User, but how do I get the current user?

    Thank you

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

  • 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.co.uk…

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

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

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

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

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

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

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

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