• Request for Ebanking / Compatible Plug In for 'CitiBank' and 'St George' Bank

    Please can a plug in for 'CitiBank' and 'St George' banks be made available (including ability to use Bank Feeds) as I have a few requests for both respectively now. Thanks
  • Forgotten to tick the update cashbook when importing customer payments into customer transactions

    Hi. SAGE200 I used customer transactions to import my payments, but forgot to tick the update cash book check box. I know this needs to be fixed, but I do not know how. Please can I ask if anyone knows how to do this please? Many thanks C…
  • accounting data issues

    It seems clear to me that Sage 200 is worse than Sage 50 for extracting accounting data. Also seems to be slower. Priting a nominal account transactions is impossilbe amending a journal impossible - software says you can do it, but then refuses when…
  • Anyone using Sage 200 on the new Copilot+ PC's?

    Hi all, We are looking at new laptops for our sales guys and I really want to get the new ARM laptops for the battery life. I can let them use Sage 200 via RDS but some would also want a local install when they are in the office. Has anyone here tried…
  • Is there a way to print the stock take sheets so they are listed by product group rather than in alphabetical order (without having to generate every product group separately)?

    Can I print the stock take sheets so they are categorised by product group rather than just all in one group and in alphabetical order (without having to generate every product group separately)? We have many product groups and we're doing a full stock…
  • Change financial year end when postings are in the following period 1

    We are extending our financial year. There are postings in period 1 of the new financial year but it is still marked as future. If i use "maintain accounting periods" to delete the period from the future year and bring it into the current one will that…
  • I got multi PO number on the invoice. How can I post multi PO on the same invoice

    I received multi PO number on the same invoice and supplier said three POs are related, therefore, they cannot separate the cost between three POs. Can we post invoice with multi POs at SAGE ? I am new user of SAGE 200. Any suggestion link that let…
  • Limit access to columns on custom Stock item list programmatically

    Hi all, how to Limit access to Columns on custom Stock item list? I only need to show Code, Name, and Reserved Stock (custom column) for specific users. I have try removing the fields from the extended view. But the columns still showing in the…
  • 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…
  • 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.
  • 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 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…
  • 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…