Sage 50 Accounts

I am looking to run / create a report where I can see the following information in one place: Supplier Inv No Inv Ref / PO no Inv Details Net Amt Any help would be really appreciated! :)

Report designer seems to of moved backwards on the last update rather than forwards has anyone had the same, gone have all the shortcuts from the side which is now making it difficult to modify reports. We have also noticed many of our customised…

Does anyone know the expression/data field that i would need for QTY remaining on on the delivery note report. we use the delivery note via reports so the standard SOP is not available. Thank you in advanced

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…

I need to add to a report the last cost price discounted and standard, which variables do I need to add

Hi, I essentially I want to see my nominal ledger, split by department. I'm building a report in Excel that uses the connection properties and command type of SQL to extract data from the SAGE databases, but I'm not seeing any links between departments…

I would like a report that shows me our daily sales invoice and credit note totals, doesn’t matter about any other details, just the total sum, preferably ex and inc vat but either would do. I have scoured the internet and sage city but do not seem to…

Hi I would like to include credit notes on the reminder letter as it s only showing the invoice. Can anyone advise how i do this please Thank you

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, 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…

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…

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…

hi how do i go about printing all the available variables from Sage 50professional and payroll. i wish to create reports in excel but need the exact fields to allow import and export. printing them out will given me the exact spelling etc. thanks

Hi, I'm wanting to created a customised report for the Aged Creditors so I can see a list of suppliers that we DO NOT pay by DD/SO. The simplest way I can think to do this is to filter the report to exclude the suppliers that have DD/SO set as the…

I'm trying to setup a new report under Products & Services to match the requirements of one of our suppliers: what the supplier would like is to know the customer account name rather than the default reference to the invoice number within the vanilla…

As it says above really... My "A4-Sales Order-Plain Paper" report suppresses blank lines in the invoice address (SALES_ORDER.C_ADDRESS_2) which is shown in the Order_Number header but not the delivery address (SALES_ORDER.DEL_ADDRESS_2) shown in the…

I would like to customise the Sales By Product (Summary) to only show a select number of stock codes. They do not run concurrently in my product list. Is there a way to put the specific stock codes into the report so that it then produces it with…

When changing or creating a report or layout and saving to our Server, only "Main" users are able to view these changes. How can "Online" users see these without having to save it down on each "Online" users PC or laptop?