• Sage 200 Job accounting timesheet entries

    All my timesheet entries from January till now are showing as submitted instead of posted, does anyone know how to change the status? Because they are not showing as posted they have not fed through to the profitability breakdown reports. I'm new to using…
  • Communication error on local PC when installing Sage 200 Professional Client

    When installing Sage 200 client on local PCs i recieve the following error: I have read that this could be due to the certificate not being on the local PC, however i have since copied the certficate to the PC and i still get the same error message…
  • New feature research for Sage 200

    We’re currently working on a potential new feature that will allow the ability to download and import bank transactions for the purposes of bank reconciliation. The data, once imported, would appear within the bank feeds service, allowing you to use a…
  • Unable to save files from Sage to local drive

    Hi, I’m running safe 200 on a Remote Desktop, when I try to download files from safe into my local computer, it says windows is unable to use the network resource. Has anyone experienced this?
  • any function to find items in any transactions and remove it programmatically?

    Hi all, is there any functions to do the following: 1. find the item 2. find the all transactions that uses this item 3. remove the items and transactions. 4. in the meantime, take care of the data to avoid data instability. thank you.
  • BACS

    Hello, new to this community. We are trying to set up BACS in order to pay our suppliers. BACS are asking for a Software Package SFP Reference number. Does anyone know where to find this in SAGE 200 please.
  • Receive a reward when you become a reference for Sage 200

    We are looking for existing Sage 200 customers to join our reference programme that can speak to: Migration from a different solution. Sage 200 features. Third party integrations. You will receive a £75 gift card when you capture a short video…
  • Amending product groups of multiple stock items

    Hi, I'm looking to change and update the product groups of all stock items we have on our system. Is this something that can be done by exporting and importing records, or would each product need changing one by one? Thank you!
  • Sage 200 MRP SQL Query

    Hi, I am trying to build a excel report using SQL to give me MRP demand. I have built 90% of the report but need to add in the works orders required/demand quantities which haven't been allocated to stock. Below is my current query - any help would be…
  • SYSCurrencyIsoCode

    Does anyone know what is this field and how it is populated in the reports. I have a EUR account and when I post entries into this account it randomly takes iso code 46/49 on its own. I want to understand what is driving the postings in this field.
  • Sage Provisioning Portal update

    On 17 January 2024 we will be updating the Sage Provisioning Portal. The portal will be unavailable between 13:00 and 17:00. This update will not prevent your use or access to Sage 200 but you will not be able to access the portal during this time. You…
  • Sage 200 Trial Balance individual months after year end date

    Hello there After having a chat with Sage 50 support, I have been informed that you cannot run a TB with individual monthly movements from the moment of the new year, unless you close the year in SAGE, action which is irreversible. I would like to…
  • Volumetric Pricing

    is it possible to do volumetric pricing in Sage? eg 1-9 = £x, and 10-100 = £x? thanks
  • Sales Orders

    Hello, Does any one know if there is a way in Sage 200 to copy a sales order from one customer account to another customer account without having to re-input all the products? So as an example, one of the team has put a complete order on the wrong…
  • New Sage 200 Ideas Portal now live!

    Exciting news! introducing our new ⁠ Sage 200 ideas portal Sage 200 Ideas now has a new home. Search for ideas to register your vote, log new ones and look around to see what other customers have logged. You can also comment and provide more details…
  • Power BI Errors

    I have linked our Sage 200extra account which runs on a remote server with Power BI. It works sometimes at refreshing data but 90% of the time is returns the below errors. The refresh tends to work on in query editor but basically never in the data view…
  • Invoicing part orders that have a full payment allocated

    Hi All, We receive orders through our website, and the sales orders are entered and the payment recorded under the tick box "Record Payment with order" However, this has caused issues because we part despatch orders, and you cannot generate part invoices…
  • Sales order processing and staged payments

    Can someone help with an issue I have please? We need to process a sales order but the order has staged payments. For example, the sales order would show a stock item with a value but we need to invoice the customer 20% in advance, 50% upon despatch…
  • Does anyone know how to deal with payroll and Cortax nominal ledger accounts that are affected by journal entries in Euro and payments in Sterling for revaluation purposes?

    We are a GB Based company reporting in Euro. Does anyone know how to deal with payroll (HMRC for PAYE) and Cortax nominal ledger accounts that are affected by journal entries in Euro and payments in Sterling for revaluation purposes?
  • List screen total amount of selected rows

    Hi There, When I used to view my sales list I could select multiple sales orders and the footer at the bottom would show me the total amount of the selected rows, However i was adding new columns to my sales list and removed the amount column by accident…
  • Join tables produce ambiguous error

    Hi all, I want to join StockItems and StockItemSupplier table using Sage.ObjectStore.Join below. StockItems sis = new StockItems(); try { Sage.ObjectStore.Join join = new Sage.ObjectStore.Join(); join.RightTable = "StockItemSupplier"; join.RightTableAlias…
  • Sage 200 to power BI connector data missing

    Hi, the API documentation discusses that field nominal_analysis_items is returned when querying endpoint sales_transaction_enquiry_views. but it doesnt seem to return. is there a way to get this data? thanks Gareth
  • Sage Provisioning Portal Update

    On Sunday 1 October 2023 , we’ll be updating the Sage Provisioning Portal between 12:00 and 18:00. During the deployment period, access to the Sage Provisioning Portal will not be available. However, access to Sage 200 Standard, Sage for Education and…
  • Amend Batch Number by Location / Split Batches

    In the Amend Batch/Serial No feature, you can filter batch numbers by location, but changing the batch number applies to all locations where that batch exists. For example we have item GIN which is in stock at SHOP (qty 100) and WAREHOUSE (qty 100)…
  • Sage 200 Product Release - Professional

    We're delighted to announce the release of Sage 200 Professional 2023 R2, which is also available via the Sage Provisioning Portal for Partner Cloud deployments. This release marks a significant milestone in our modernisation journey for Sage 200, building…