Welcome to the Sage 50 Accounts UKI Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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
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!
Followed the instruction in 22152, but our layout data is recorded in 2009, not 2019. 2019 does have DataRestores > Layout Backups001, but not in 2009 Tried using 2019 Data Restore, but still unable to obtain any invoices. Data Restores are avalable in…
I am trying to create a report which has a tiered grouping of line by line invoice details for a multiple clients grouped by the client then by an invoice number, but I have been unable to achieve this with much grace.
We are looking to have the following…
I want to be able to display different text in a text box based on the result of an expression. So far so good, but the text I want to display needs to be displayed as a multi line, and I can't find a way of including a linefeed or carriage return character…
Hi,
We do our stock take just before Christmas every year using the stock take options in products and services, we then do a product valuation based on the stock take for our end of year.
The problem we have is that doing the stock take on sage…
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…
You may already have it…
Our Report Design team have picked out the most requested reports that already exist in the software and we’ve detailed them below. Have a quick check and see if there’s a report there that would work for you.
Which products…
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…
Basically I recently upgraded from an older version of sage to the latest one and everything went smoothly - however I can no longer use the invoices that were designed to fit onto the headed paper we use and so this is quite annoying as I have been having…
I'm trying to find out how to add a filter expression on a report for Sage 50 Accounts, such that the report only looks at GDN_ITEM_DATE that is from the last 12 months from the CRITERIA.GDN_ITEM_DATE_TO specified when the report is run. I then need to…
The August Report of the Month is now available for download
The new report is "Sales by Invoice Analysis Code 1". This Invoice report can be run for a date range and will group invoices together by the Invoice Analysis 1 field. It shows net sales per…
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…
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…
Hi,
I'm getting the following error when I click on a folder when browsing any reports within Sage 50 Accounts Pro on a company laptop (error doesn't occur on other computers). Balance Sheets and anything accessible directly from the menu run fine.…
Has anyone discovered a report to advise total weight of customer invoice or sales order? This would be very useful for us as we prepare quotations for customers. Thank you for any advice on this
Is there anyway of printing a suggested payment report without including the direct debit payments? I am currently printing a Supplier Invoices Due report and excluding direct debits by individually ticking the boxes in 'not in' drop down menu. If I could…
I have edited the standard "Aged Debtors Analysis (Detailed) - By Balance (Descending)", and saved to a different name.
I have modified some fields, and changed the Report Sort order to be by Sales_Ledger.Name, but the sequence of the report does not…
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 everyone,
We've just started using Sage Drive and have got our data uploaded and working correctly for multiple users. However when the main accounts user (connected to Sage Drive data), goes ot Modules, Projects and Reports, we experience an error…
