Sage 200 UKI

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?

Hi all,

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

Thank you

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…

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…

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…

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…

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…

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…

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

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…

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…

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…

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…

Hi there,

I am trying to set up a bank feed, but I am getting this error message. 

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…

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…

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…

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…

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…

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…

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…

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…