Sage 200 UKI

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

Hi Guys The Sales Ledger has now been closed for December, but I am still not able to print the invoice in Sage. How do I get the invoice into Sage Spooler for printing. I don't want to post but just print.

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…

Created by Sage Experts, the Report Library offers a range of downloadable reports that you can add to your software. You can even view a preview of the report before you download to make sure it gives you what you need. View library >

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…

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…

I have tried looking through the forums, and after a long time of trying to do this all by myself, ( with no Sage training at all) I am now swallowing my pride and asking for help. Basically I have been tasked with reporting and bringing forward my…

Hi, I am trying to print invoice in multiple output mode, let say, when I print the invoice, I want it to print to my printer, and also keep a copy in Spooler. So far, I assume that can be done by printing invoice twice, but reset the output mode…

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

Hi, I'm not sure if this is possible through any form of reporting, but I have discovered that there doesn't appear to be a way to view the VAT Registration number that has been entered against a Nominal payment or receipt (i.e. for cheques/petty cash…

Hi, can anyone help me figure out how best to process charging our employees for private use fuel. We use the HMRC advisory fuel rate depending on the engine size of the car but what is the best way to process this through sage so that the VAT element…

Hi We need a report that will show all invoices and credit notes by supplier with the nominal codes they were charged to within the year. Is there such a thing in Sage already? And a similar report but for Customers? Thanks

I have tried to use Bi reports but they keep falling over which makes it impossible.

We use global order discounts and order line discounts. Some customers have a mix of both depending on the products purchased. Is there any way to show these in reports? Or BI? I am spending too much time going into each customer account to check…

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…

Hi, We recently installed the latest version of Sage 200 on premise on a new server. Everything appeared to go well, however, every report I try to go to shows an Unexpected Exception 'Cannot find the report file: PURCHASE\Purchase Ledger Day Book Report…

If you upload budgets for NEXT year do these values appear in Original Budget (and Budget value) after a year-end. I ask because whilst there is a Budget Value and Original Budget field for the current year there is no Original budget for future years…

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…

I am looking to add the cost centre name (not the 3 digits) to my reports but can't find the variable - does anyone know what it is?

Can someone suggest the best way to track our on time delivery of Sales Orders? I have some knowledge of BI and have never used report designer. Is there a standard report that can be amended? Thanks in advance.

The default Suggested Payments Report in Sage200 for Education lists the suppliers in Account ID sequence. I wish to change this to list them in Supplier NAME order. I understand that the sequencing is controlled by the Group header/footer which is…