Browse By Tags

Hi Guys, I'm getting the error "Navigation to the webpage was cancelled" Screen print attached Any ideas? Regards Michael

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…

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…

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…

I've successfully imported a journal with a numeric reference. Now I would like to be able to create a transaction report that is selectable by Reference, so I can see all the lines on the journal on the same page. How do I do that? The journal is across…

Afternoon, 1st time posting here.... Could someone please tell me if it is possible to produce Sage report with "customer order no." (which we enter on all invoices) included? I need an excel export of all SIs posted in month including this detail…

Backgound on the challenge I am facing: A vendor sends us an import file that combines three customer data fields into one, separated by a ‘/’. (These are Unit No / Account No / Order Reference) This combined field is imported into our Sage Line…

Hi I was wondering if it would be possible that credit notes could be picked up in the supplier invoices due and overdue report at all i have included a screen shot of the report and the filter for the "type" as i am assuming this is what will need…

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…

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…

Hi please could anybody help me set up this report? Covid has played havoc with my brain and I need simple instructions. Step by step kind. I am using Sage 50 Cloud Accounts uk. I’m wanting to set up a new report with the following information shown…

Hi if anyone can assist.. I have taken the Analaysis of Employee Payments reports and save it as my own and changed which payments it picks up. How do you reduce the output of the report so it only gives you any of the payment details with a value…

We've gathered the common questions you're asking us about reporting and Report Designer in March 2021. This includes: Adding reverse charge messages to your layouts. Issues emailing documents. Finding the best report in your software Read…

Hi When I export a bespoke report to 'Data to excel' the data columns are not in the correct order: IE. Column G - PaymentAnalysis.Desc2 Column H - PaymentAnalysis.Desc4 Column I - PaymentAnalysis.Desc6 Column J - PaymentAnalysis.Desc10 …

I have been asked to print out reports for meetings. This report specifically is for SOPS - printing out an itemised quote list. I usually enter an "M" Message line on the first line of every quote which I input the customer's enquiry reference. I sometimes…

The report could not be generated. No applicable method 'StartsWith' exists in type 'DynamicClass13' I'm using a modified zero value order lines report to get invoice item descriptions and their respective invoice numbers into columns. When I try…

Is it possible to receive automatic daily reports directly from sage using a scheduled time / date? So if i want a certain report to be emailed to me, or generated, it doesn't it automatically without me having to click on the report & criteria every…

Is it possible to use the report designer to add the name of the user who is running the report?

Hello, I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…

Hi, I'm trying to put a delivery address on my invoice in Report Designer. I'm using the following variables: SOPInvCredAddresses.C_AddressLine# - invoice address SOPInvCredDelAddresses.C_AddressLine# - delivery address I want to put in…

We run Sage 200 and I'm trying to produce a report that shows our Customers average time to pay. The Account Details report under SL - Reports - Account Analysis gives me the information I need, however it shows the Average Time to Pay for the entire…

Our business is driven around using the Project Module within Sage. What I cant seem to do is find any report within Report Designer that enables me to simply print my Cost Code Budgets (Set pre start of Project) against the actual Spend figures. It…

Can anybody advise on how to stop zero balance letters being generated? I am using report designer to create a Dunning Letter but I cannot stop a letter being produced when the 'Grand Total' field shows zero. I have looked at adjusting the report filters…

Hi, Trying to edit the Sales Order List report as the current report does not repeat the headers below per line how do I edit it to repeat the information per line for each product Order # Date# Account Number Account Name

Hi, i get this error when open BI Report Manager I'm on Sage 2014 PU3 "The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : - SELECT…