Sage 50 Accounts

Hi All! I'm trying to edit our purchase orders so that it works with both types of orders we do. Sometimes we don't add a code for items we're ordering in on a one off basis and we just use the S1 - Special Item code. When using STOCK.SUPPLIER_PART_NUMBER…

Hi, Over time I've set up custom messages in my report layouts for when these are emailed. I've noticed that on a number of occasions these do not appear and, instead, the message defaults to the " Your report is attached in pdf format. You will need…

Hi I don't know if anyone has some experience setting up and sending invoices and statements by email on a fairly old version of sage. We have recently upgraded our computer and moved over the sage software. To send statements on our old computer we…

The above report almost does what I was hoping for but modifying it to Select Only the Materials Cost Code caused some strange results and a blank Cost Code column. What would be the best way of extracting Material Costs only ? These would basically…

Hello, I have set up my customer statement to email out and altered the text accordingly. Customers invariably request a copy of the invoice as they 'can't find it'. I want to know if it is possible to add a copy of outstanding invoices, detailed…

I'm trying to add a data field with the information from this in the item line of the products description . I cannot find what data field I need for this Some please, please help.

I am trying to re-arrange my statement report design, by adding coloured background instead of transperant. In the field 2. Header_Number footer (from your sage template) I have filled the date - inv. ref - details - outstanding and payments Somehow…

1st post on here, so pls be gentle! Does anyone know how to resolve the below issue: Thanks

This session revisits groups and sections to explore some of the standard reports with multiple groups. You’ll also learn how and why you might need to add multiple groups on a report and how to add group totals. This webinar has now taken place, but…

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…

This session explores the Letters option available within the Customers module. We'll demonstrates h ow to use the Sage Report Designer to edit letter templates. You can easily create a festive message, including details of special promotions, new product…

In this sessionyou'll learn about: The structure of reports in Report Designer. The impact of adding groups and sorts to a report Making some basic amendments to existing reports This session has now taken place, but don't worry a recording…

Hi, To import orders to our new warehouse system we need to export them from sage as CSV files with headers. CSV file headers have to be exact and some of these include a space. In the report designer I can choose to Generate Header Row and headers…

I added a logo to several of my templates, which seemed easy enough. Now when I print I often get the following message. Is there some kind of limit on how Sage50 handles the printing of graphics? The logo details from Report Designer are also below.…

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…

I'm looking to create a report, or (preferably!!) doctor an existing report, that will show me products that have had ZERO sales within a specified time period. Any ideas?

I have a fully working Layout for Printing Quotations (run from Sales Orders) but if I add the WEB_DETAILS data field to the report, it inhibits "M" (Message) items being displayed. Accounts, v28.0.226.0 & Report Designer v5.0.251.0

Hi All I am trying to amend the invoices and credits by customer report so that it shows the carriage charge invoiced. I have added the expression to calculate the carriage charge which it has done but i notice that if the invoice has more than…

Greetings, I produce weekly invoices for a client and currently use a workaround to export invoices from the 'invoices and credits' screen onto a Word template in order to send to the client as I haven't had a lot of luck with Sage report designer in…

When we updated to v28 we noticed that one particular Layout from the Report Designer was deleted from all machines, luckily except one bizarrely, so we have managed to save it back as a favourite on all machines. Today, we've had to remove all machines…

Hi. I find in my library slow moving stock but there is nothing to pin point fast moving products. Is that additional extra in sage50 or is under different name? I really need to have that list and I know that in the past the was report like that. Any…

Thank you for your attention. I have an Invoice Report which has a Data Field that retrieves Invoice Comments (line 1 & 2), however I would like to create a conditional filter/format so that IF either of the Comment Lines are blank, the relevant Field…