Sage 50 Accounts

Since upgrading to version 25 I am unable to print statements, email them or save them as a PDF, it goes to do it but gets stuck on step 4 of 6 saying export to PDF. I have to close the computer down as I am unable to get off the screen. Help!

Hi, Hoping someone might be able to offer some advice. At present the delivery notes we send out show all the stock that we are sending out (which makes sense), however, we'd like it to also show any stock that has been ordered but not sent out yet…

Hi there, I am trying to set up a filter on a Sales Order - Goods Despatched report. The aim is: I only want to see the products that start with "EV" or the ones that end with "EV". Sage report design has a filter "starts with" and "ends with" but…

Sorry to repost this issue again but I am desperate to find a solution. I am using Sage 50c Accounts Essentials. When I create the email with my remittance attached in pdf format the Extra_Ref value does not appear even though the data field is on…

I'm trying to send invoices to our customers and when I double click on the invoice layout I wish to view, it comes up with - The report could not be generated. No data was returned for this report. It only does this on random orders, some invoices I…

Hi I am Michael, I work on the Digital Contact Team here at Sage, I also used to run the Premium health-checks for Sage 50 Accounts before moving to this team. When doing these i was flabbergasted at how many people had no idea about this amazing…

We need to provide managers within our company a detailed breakdown of income and expenditure relating to their areas each month & quarterly. We are currently using the nominal activity report and selecting line by line the relevant nominals' that they…

Hi, Can anybody help with an issue I'm having in report designer? I recently updated our layouts with some new company branding. We use some layouts to generate certificates for each item/product line in the sales order, however the REPORT.PAGE expression…

I installed the update today and since then I can't access my layouts/email reports. Messages - 'The specified data source SageLine 50 v13 could not be found' (I'm on v23) Check that the data source is correctly registered' I'm the sole user and…

Hi, I am running a report in the Invoices and Credits section of Sage 50 Accounts Professional. This report gives me the following information: A list of the products sold for that month itemized in alphabetical order The net amount made from…

Hi, What is the easiest way to get my custom report to show a breakdown of net values for invoices by month? See image below for reference: Kind regards, Danny

Hello all Aim: In an attempt to contact customers to offer 'special offers' or encourage more orders, I would like to be able to look through customer's previous orders, recognise the 'repeat orders' and establish a 'special offer' or at least a reminder…

Hi, I am writing a report to show outstanding items left on an order, so I am using the order confirmation report layout we have, and added SOP_ITEM.QTY_DELIVERED in the ITEM_NUMBER Header. Then added an expression to that line as follows:- If SOP_ITEM…

Hi, I have added a REMITTANCE.EXTRA_REF variable in the REMITPLAINA4.LAYOUT file for Remittance Advice expecting the Ex Ref records to populate this field but it remains blank when the Remittances are generated. Why does this happen and is there any…

I have a message saying that a report can't run because it can't convert system.string to system.datetime How do I know how to fix this? I have tried to look online in the help centre but no luck! Really hard to understand the guides. Also tried…

Greetings All, This may not even be possible, but I will do my best to articulate what I'm trying to achieve and hopefully someone is able to help. I'm using a report from the Customers tab > Agents Commission (@10%). I have modified this slightly…

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…

Hi, Is it possible to create a report which will export the data in the following columns? Order Date / Order Number / Account Ref / Account Name / Product Code / Product Description / Quantity / Price £ / Net £ / Trying to do this without…

I have to run a monthly profit and loss report per department for one of my clients in Sage 50, unfortunately the set one which produces a nice layout in Excel can only be run with one department at a time highlighted or else when a range of department…

After ungrading to v24 some of our reports are not as they were. Specifically, the Remittance Advice to Suppliers does not have the correct wording in the body and when the email is produced it is addressed to PURCHASE_LEDGER.EMAIL instead of the supplier…

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

I have edited the DELNEWA4.layout but cannot see where/how to print this? We have a GDNPRNT.report but this only works after despatch. I need a Delivery Note/Packing List before despatch. I've tried copying the layout file into various folders but even…

I want a "Profit and Loss (Monthly Breakdown)" [Filename PNL_MTH] - BUT, for the previous Financial Year. Is there one available?