Sage 50 Accounts

Since updating to V30 there appears to be a strange bug that has appeared when Exporting or Printing Invoice layouts. It appears that conditional formatting is not being correctly respected for 'Suppress Print' and 'Visibility' on items. It also appears…

I'd like to be able to see the department name instead of the number in the selected criteria shown in the page header. Currently I see "From '2' to '3' (inclusive)", or "All", or "1, 3, 4", depending on how or which departments I select to be included…

I've been asked to print customer memo / notes on aged debtors report. Not sure if you can do this as notes are kept in a separate file - but it would be great if you could add them to a report. Does anyone know if you do this? Thanks Simon

Hi I'm trying to write a IF statement to state IF SALES_ORDER.NOTES_1 , SALES_ORDER.NOTES_2 or SALES_ORDER.NOTES_3 is populated show 'SERIAL NUMBERS' but if not populated leave blank. I have tried the one below but serial numbers is showing when…

We are using Sage Accounts 50 v28. I am trying to write sample report generation app using C# and I am stuck at very beginning because Sage is reporting me back that report file which I am trying to use is not valid even if it runs without any problem…

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…

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…

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

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…

How do I add nominal debit and credit totals to a nominal report footer that only cover income and expenditure but not the bank account balances that are at the top of the report? Have no idea with Sage reports as to which fields i need or the expression…

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…

Hi All. Hope someone can help. The recourring invoice button in the invoices and credits module has a great send to excel button which is really handy, however I'd like a report that also produce the information on this report as well as all the details…

Hi all, We have just moved to Sage 50 and are looking to add the POP_ITEM.DUE_DATE to our Outstanding Sales Order Report, so that on our backorder report it shows the due date for the items ordered. I have been able to add the POP_ITEM.DUE_DATE to…

Can anybody suggest how to design the invoice form to include amounts in words in sage 50 UK.

Hi I'm looking to create a conditional formatting expression where if a stock code is more than x characters (lets say 10) long, then enable word wrap. I know how to enable word wrap, it is the 'if' part of the expression I am struggling with. Does…

Hi When configuring the email settings for a report and attempting to change the Filename (as standard is set to REPORT.DESCRIPTION), an error comes up saying "You must enter an expression that returns a 'System.String' value. What does this mean…

Hi All So I am trying to find or create a report to show all overdue customers however I dont want to include the customers who have promised payment. Is there a report already or would I have to create this? TIA

I've used Sage for years, and have a tiny bit of self taught experience in Report Designer. I'm looking to plug the holes in my knowledge but can't find a book or anything like that online. Can anyone recommend a good way of getting training in report…

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…