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.
Is it possible to display a page number in a report that displays the count pertaining to each individual company within that report? i.e. Is it possible to reset the page count for the next company within the same report?
For example,
Company AAAA…
We have a healthy annual fixed asset budget which requires regular monitoring and the preparation of reports appropriate to the level of management.
We use advances departments in depth and the system allows for budgets to be applied to the fixed asset…
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…
Hi All,
I am after some advice. We currently use projects in SAGE 50 for costing purposes. We have, in the past had 5 or 6 projects (installation of different energy saving measures) under one contract for which we have separated out the costs & revenues…
When running the report for supplier turnover, subcontractors who are nett and pay CIS tax, as it is a credit note automatically produced on your system, it is deducted from the turnover figure.
We need subcontractor turnover figures to give to the…
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,
We don't fill in stock values for our product codes in Sage 50 accounts, we just don't use that option as we have a different system in place. Is there any way of producing a product activity of products sold (generated from invoices)? All I can…
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…
If there are times when you need to run lots of Sage 50 Accounts reports together, for example, at year end, did you know that you can save time by setting up batch reports? You choose the reports you'd like to run as a group, then any time you run your…
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…
Has anyone connected Sage 50 UK to Microsoft Power BI for reporting? and if so how? as that is something I would really like to do. I wish that Sage would build a Content pack for Power BI so it was a native integration and I don't have to go down a 3rd…
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 there,
The figure in my Aged Debtors report differs from the amount in the Trial Balance. I have managed to trace it to a receipt that is not showing in the Aged Debtor report.
Is there any reason for this?
Will I have to reconcile the reports each…
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
Looking to update the system with a new format for our product codes if I make the changes will it also change the historical data ? Don't want to make the changes and then not be able to run reports properly. Any advice would be really appreciated.
Sage integrated reporting presently requires that criteria be entered by the user in the dialogue.
It would be helpful if the tool were able to pick up criteria from [named] locations in the Excel file.
Eg a set up sheet for a report may specify the…
