Sage 50 Accounts

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…

Is there a way to report on the forecast figures that can be entered in the Advanced Budgeting tables?

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…

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…

Does anyone know how I can run a report of all my customer e-mail addresses so that I can do an e-mail shot with a new price list?

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…

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…

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…

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…

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

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…

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…

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!

Hi folks, Is there any way we can have a report that shows our stock levels as of the 31st Jan 19? Thank you

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…

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…