• 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…
  • 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
  • Report Designer Reverse Criteria

    Afternoon, Can anybody tell me how to reverse the criteria for this report? It is currently showing my works orders by number starting from 1 in the drop down, whereas I would like it to be the opposite and start from largest number first. Thanks…
  • Sage 200 OBDC adding in Delivery Addresses

    Hi, I have the below code but need to add in the the delivery postcode (highlighted yellow below) - how would I add this in, I'm not to sure of the joins? SELECT DocumentNo, DocumentDate, DocumentTypeID, DocumentStatusID, SOPOrderReturnLine.ItemCode…
  • how to Import dif file for each user?

    Hi all, My users, lets say user A,B, and C have their own preferences on the menu sorting/arrangement/naming. Whenever customization update installed, the menu arrangement will reset according to Sage 200 default sorting/arrangement/naming. Each user…