Sage 50 Accounts

Hi, To import orders to our new warehouse system we need to export them from sage as CSV files with headers. CSV file headers have to be exact and some of these include a space. In the report designer I can choose to Generate Header Row and headers…

Hi, We need to export our sales orders to import to our warehouse system, but the new system requires CSV files to have the first row of headers. However I would try to create headers - they would only appear on excel forma, but not CSV. Please…

Hey everyone, Here's the scenario: My company gets invoices every day, and we want to do reports each week for how much we spent on invoices for the week before. However, sometimes an invoice may arrive a week late (or more). What would be the…

I'm looking to create a report, or (preferably!!) doctor an existing report, that will show me products that have had ZERO sales within a specified time period. Any ideas?

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…

Is there a way to printer 2/3 copies of the same invoice? I have a custom designed report; which works fine. I'm looking to print this 2/3 collated copies without changing the settings - i.e. by clicking the Quick Print Button I have tried to change…

Hi, Could you tell me, is it still not possible to join SOP_ITEM and INVOICE_ITEM within Sage 50 Report Designer? I have tried and can't seem to get it to work. I know it was a know issue years ago, but I would have thought Sage would have fixed it…

Simple question (I think). How do I amend the Agents Commission 10% report to show only the invoice total and commission and NOT every invoice line. Any help would be appreciated Thanks.

I have found on occasions I have lost all of my favourite layouts. This has occurred when I have upgraded to a new PC or maybe when I have had file corruptions within windows for example with my desktop, profile., etc. I would like Sage to create…

Hi All I am new to Sage 50 and im after a bit of support/advice please. I have a client who has a hierarchy to their business. Department 1 and 2 Sub departments sitting under these so 1a 1b 1c and 2a 2b 2c etc each of these sub departments…

We have an issue with a supplier where their account is in quite a mess, however the account we have is all balanced. We have been back and forth a few times trying to help them match their unallocated transactions and each time it seems to open a new…

Hi please could anybody help me set up this report? Covid has played havoc with my brain and I need simple instructions. Step by step kind. I am using Sage 50 Cloud Accounts uk. I’m wanting to set up a new report with the following information shown…

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…

When you wish to reprint a Despatch Note from the Despatches tab of the Sales Order, you do not have the ability to select the report that is produced - it can only use the GDNPRNT.report file, this is hard coded in the system. Obviously, and this is…

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 guys, I'd like to add a field to a report that puts the user ID or user name in the corner (to show who exported it), but can't find the right field in any of the join tables. Does anyone have any idea where I would find the right expression…

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

Is it possible to receive automatic daily reports directly from sage using a scheduled time / date? So if i want a certain report to be emailed to me, or generated, it doesn't it automatically without me having to click on the report & criteria every…

I have looked everywhere but is there anywhere you can print a report where it sorts transactions posted by a certain username on a certain date "posted date". Any ideas or do i need to design my own report?

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'm trying to generate a Nominal Activity Report on one Balance Sheet Nominal Code (1108), but I want to add a field into the report to show the Nominal Code each transaction has been posted against (5000 / 5001 / 5002 etc...). This is picked up under…

I've tried to follow a couple of procedures in order to reveal zero balance codes in my TBs but they don't seem to work for me. Has anyone done this successfully? Specifically I'm running the Period Trial Balance report which at the moment only shows…

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…

I have some unfixable errors on my data so am setting up a new company. I want to transfer customers and suppliers products. Have exported the various reports, set up new shell company and have imported customers csv file. Customers have imported fine…

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…