Sage 200 UKI

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…

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…

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

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…