• Sage MTD for VAT Submissions Module Error

    Hi Guys, I'm getting the error "Navigation to the webpage was cancelled" Screen print attached Any ideas? Regards Michael
  • Pay Now button on Pro Forma Invoices

    We use invoice payments via Stripe for SOP invoices but would like to extend this to pro forma invoices also. Currently it is not possible to add a Pay Now button to a pro forma invoice layout. The benefits of having this on pro forma invoices are…
  • How do I trace Transaction Listings in Sage 200C On-premise

    We have Sage 200c On-premise. The schema comprises of a Cube, Warehouse and Finally Sage Database. How do I know how data is being surfaced? Example: How do I trace data from Opening Balance, Transaction Listings (movements) through to Closing balance…
  • 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…
  • Matching Transaction Report

    Hi everyone, I'm fairly new to Sage 200 and still trying to discover it's possibilities. I've been wondering if anybody has any idea if there is any report or how to create one that will basicaly generate you a list showing all the Credits and Debits…
  • SumIf not giving correct result

    Hi all, I've been trying to create a simple SumIf expression, which references an expression earlier in the report that I've created to add a small value of 0.50 to invoiced items that come in at 0 value. Here's the referenced expression: SOPInvoiceCreditLines…
  • 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
  • Nominal transaction reports to include a correct brought forward figure

    Customers migrating from Sage 50 to Sage 200 have requested the ability to run a nominal transaction report that includes a correct brought forward value of transactions prior to the period running the report from. Brought forward values are shown correctly…
  • Sage-200 Sales Order analysis codes on reports ?

    Hello, I am trying to add sales order analysis code fields to a copy of the Sales Order (Detailed) report, however they do not appear to be available in the Report Designer 'field picker'. Can anyone advise me as to whether this is possible ? I am aware…
  • 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…
  • Upper / Lower Case | Sage Report Designer

    Hi all One of my colleagues has just asked the following. "Is there any function that converts the first character to the upper case and rests to the lower case? Such as ‘Proper’ in excel? " Many thanks
  • SL Customer | Transactions | Query

    Hi all Where is the query data field stored? Many thanks
  • Tooling information on Works Orders

    Not sure if anyone can help with this, but while we are using Sage 200 Manufacturing, I am trying to get the tool resources listed on the route card in the right sequence that it would need to go in, we do have multiple boms with multiple tools at different…
  • Sage 200 Report Designer - Join Not Detecting New Column in View

    On our picking list report we've got a join to an SQL view called 'SOPAdditionalChargeView' which is used to display the additional charge line for the order at the top of the picking list. Without going into too much detail I have added a column to this…
  • Report Designer transient data linking

    I am trying to work out how Sage/Report Designer link the data between the actual Sage tables and the transient tables that report designer uses. We print out some stock labels and the report uses a Stock_Label_5559 table for its data which is made up…
  • A way of printing multiple copies of documents

    It's not unusual to need multiple copies of some documents - for example, 3 copies of a despatch note, 1 for the office, 1 for the customer, 1 for the haulier. This Knowledge base article suggests setting it in the printer driver, but it can also be…
  • How to do styling with Sage.Accounting.Reporting?

    Hi all, on one of my report, I need to do get the column header and its value dynamically. So now, I need to generate the header by coding. But now the header is plain and default font. I would like to do styling on the header. How to do font styling…
  • Sales Returns - How Do I Make Them Negative On A Report

    Hi I have wrote a report which gives me sales by product, country's, analysis codes etc and is pulling through our w/o cost. However I am really struggling with the logic of how I can turn sales returns into a negative number. Does anyone know…
  • Report Designer, Expressions? or Conditional Formatting? (CONT)

    Further to my earlier post about conditional formatting. I now need to change it slightly and use a different field, but also to have 3 colours instead. I will see if I can explain it. I have butchered a copy of the Purchase Orders and Returns report…
  • make template emails send as part of the authorisation process editable to make them more usefull

    As part of the authorisation process an email detailing the order lines is sent, to the relevant persons, in the authorisation process. but this includes completed lines, lines that are completed shouldn't have to be authorised. there are no due…
  • Report Designer, Expressions? or Conditional Formatting?

    Hi, I need some help with Report Designer, I am currently trying to make some alterations to a report that was created that displays a list of all of the outstanding PO's on our system and I would like to try and get the POPOrderReturns.RequestedDeliveryDate…
  • Report Designer - Distribute and Extend

    With the report designer, can we have 2 more options for laying out objects? Can we have "distribute" which works with 3 or more objects and evenly distributes the objects between the first and last object's anchor points? As per Visual Studio. Can we…
  • Invoice Layout

    Hi all, Whenever I run a layout I would like to send it to the highlighted email address from the customer account. What would be the expression to add to the Email Settings? Many thanks
  • Commercial Invoice Date Criteria

    I need to add a criteria to our commercial invoice sage layout to allow filtering by despatch date. Essentially I need to be able to print the invoice with only items from the order that were despatched that day. Is anyone able to advise what would be…
  • Report Designer - Sage 200 online - Conditional printing not working

    I have got a text box setup on the footer of the SOP invoice layout. if I set single condition - say print if the Account currency is USD other wise suppress print - then this works If however I set multiple conditions - print id Currency is USD or…