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.
To give you a quick rundown, our business runs different programs in several different counties. With that being said, we categorize expenses for each county with jobs (established this calendar year so it is new). This has been working great, but the…
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…
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…
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…
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.
I was looking for a 'Delivered Purchase order report' - basically one that had all of the Goods Received Note details on it, but it also included POP items too from the original PO.
The standard GRN reports exclude things like price, etc. which is…
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…
After completing the monthly CIS return it would be very helpful if Sage automatacially pushed out the CIS statement to the contractors included on the return, as the current process is very long.
Example
Order 1 - 3x product A, 1x product B, 5x product D
Order 2 - 2x product A, 3x product C, 3x product D
Is there a report which can list what products are live orders, such as...
5x product A
1x product B
3x product C
8x product…
Add further company e-mail fields to allow using multiple/different mailboxes for directional customer and supplier communications. This will ensure the e-mail is not hard coded into reports and allows easier amendments as required.
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…
Hi All,
I'm trying to generate a cash flow graph, something like this example taken from google:
I can go to Bank Accounts>Cashflow forecast, but that just gives me all the raw data and it doesn't have any options to show the data visually in graphs…
Hi There should be an option available to change the "Use Data Path for Reports" overall datasets, rather than just individually, or at least a tool to facilitate the deployment of this setting to multiple datasets. Additionally, there should be some…
I'm looking to find the Nominal ledger department analysis. I've gone into Departments - Reports- Nominal Analysis but nothing is there. I'm using the departments to allocate to and it has been there in the past. The only report in that area is Profit…
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…
Looking for a good and straight forward way to get all paypal transactions onto Sage 50c Accounts Pro, anyone have any tips or recommendations?
Ideally an addon or method rather than manual work.
Transactions consist of;
Online sales (held for 45…
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…
I have had the following error message when trying to run the @Sales by product (detailed)@ report in invoices on sage 50.......
"The report could not be generated. Arithmetic operation resulted in an overflow."
Has anyone had this before and…
To be able to create reports that can hold information such as when the customers membership started, how long is left for renewal and what the renewal date is To then be able to run the report for a date range that will then show all renewals due within…
How do you export details of a vat return (Box 1-9 values) to excel ? - I imagine this should be an easy one but I cannot seem to get there.
VAT-Send to Excel just sends a list of all the VAT return totals to excel as opposed to specific vat return…
