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.
Evening
I have downloaded to excel a nominal ledger (around 450 lines). Once the download has been completed and the information is on a spreadsheet, I have totalled the Debit and Credit columns and the totoals do not agree to figures on the screen…
I have the following report, I am trying to add GRN.ITEM to the join editor so I can use GRN.ITEM_DATE as a criteria filter when running the report so only view goods delivered between certain dates.
I have been unable to add this successfully, when…
Hi all,
I am using the Sales by Product (summary) report located under Invoices and Credits. It gives the option to add date fields but the results on the report is the total sales over say 5 years - is there a way to break down the totals by year to…
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…
Hello,
We have installed Sage 50 on a virtual server hosted by a third party. When we run some reports on nominal codes section, it takes 10 or 15 minutes. The same reports run with in 10 secu=onds on a locally hosted sage.
We have Sage 50 29.2 version…
I have Sage 50 v27, 28 & 29 on my office Server running Server 2019 essentials, also pulling through to several pcs and laptops, all reports work on the pcs but have an issue on server. I know that technically we are advised to not install Sage 50 on…
I need a report to show how much stock was held and its value on a particular date, is there any such report? (The Stock movement report doesn't help much as it requires alot of manual intervention). Thanks
I need a report for an export for obtaining Feefo reports that contains customer information but also some invoice information. I am currently editing "Day Books: Customer Invoices (Detailed)" and I need to add in the product code from the relevant invoice…
Hello,
Does anyone know of a way to produce a report of customers that bought from a supplier in sage 50c.
For example: If I have a supplier and I want to know every customer that bought anything from that supplier for a period of time, what report…
It would be great to be able to download all of the advanced report library in one go, without having to do an restore with each individual report wanted?
Allow ODBC connection or connection via sage report designer to the table that holds the data of reocurring invoices, including frequency, value, start date, invoice item lines etc. This would allow us to audit the reocurring invoices setup in our software…
Stephen Wade said:
Whichever company data set my customer opens, if they go to Email Defaults the same email server settings are displayed, obviously these would then have to be applied to e.g. invoice layouts, but they might not see the folder containing…
Hi All, wouldn't it be amazing if when opayo downloaded receipts in the chain as it does this in sage that you get to change the bank account the payment + invoice goes to ??
at the moment every opayo payment automates to Nominal 1200 bank which would…
I had several reports marked as favourites, and also had some batch reports set up in V28. Having upgraded to V29 I no longer have any reports marked as favourites, and my batch reports will have to be set up again from scratch.
We need to start using the quotations feature. When we go to print a quotation, we're missing most of the templates including some sales order templates.
We want to modify a sales order template so we made a copy of it, renamed it, but it's not appearing…
Hi,
In reference to Quantity on order, is there similar variable to add this information to a report? The current orders, supplier and number?
Currently I need to open each item within products and service, click the "on order" box, wait, make…
It seems odd considering how many reports must be created in SAGE 50 a day that the only way in Remote Data to synchronize a report to all users is:
Stop everyone working.
Backup the Reports in back up
Ask all users to restore the reports backup…
Would be useful to have the facility to export or report unposted bank feed transactions. Handy if there are queries that you'd need to send to someone for assistance on transactions you're not sure how or where to post.
Hello,
We are searching for a powerful sales analysis application that offers comprehensive reporting capabilities. We need detailed sales reports categorized by customer, country, product, and sales representatives, among other criteria.
If you have…
Some of the most popular reports and layouts are available as free downloads from our Report Library.
This session has taken place but you can catch up with a recording >
Hello,
Where do I get a, " "previous 12 months stock usage" report that I use to help with predicting stock reorder levels"? I am working on an inventory project and part of what the consultant is asking me for is a usage report that will show me…
