x Want to participate? Join the group to interact

  • Purchase Order Report - Report for Goods Received

    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…

  • Add department to nominal ledger

    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…

  • Supplier Turnover figures

    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…

  • Report Designer

    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…

  • Favourite Layouts

    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…

  • Auto Generate Reporting

    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…

  • Sage 50 Accounts: Why is it that in the sales order report, blank invoice address lines are suppressed during printing, but blank lines in the delivery address are not...?

    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…

  • Changing Reports/Templates for both Online & Main user access

    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?

*Community Hub is the new name for Sage City