Browse By Tags

  • Design a Custom Report

    I am trying to create a large report that must be done weekly. It involves: Must have: 35 Departments to report on Each on its own page Each page is a Transactions by Account Report for that specific Department Summary page of a Comparative…

  • Cashflow Budgeting - Future Payables Report by Month and Vendor Department

    We get long dated terms for several of our vendors, and we are trying to predict cashflow more accurately for several months into the future. Hoping to find a way in sage to produce a report that includes amounts owing per month that are dictated from…

  • Multiple deparments codes per invoice line

    With how we use Sage as a business it would be very handy to have the option to add multiple department codes per invoice line as some of what we invoice crosses over into multiple departments.

  • Departments webinar - Recording available

    Learn how to set up and use Departments in Sage 50 Accounts. This session has taken place, but you can catch up with a recording >

  • Add department option to payment section of batch supplier invoice

    Add department option to payment section of batch supplier invoice

  • Show Totals Only on Departmental Income Statement

    Hi. I have set our Sage 50 Canada (desktop) file to use departmental reporting. I have also set up the chart of accounts to allow for "collapsable" reports (for example, I can select Totals Only and print a more summarized income statement rather that…

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

  • Running Profit Loss report with Department silos

    I am trying to get a report that shows each department to show up on the same report. So far, I can only choose from a drop down box and merges all the data. I want it broken out by department for my client. I believe in Sage 50n you could do this. …

  • Projects & Departments

    Hi All, I am after some advice. We currently use projects in SAGE 50 for costing purposes. We have, in the past had 5 or 6 projects (installation of different energy saving measures) under one contract for which we have separated out the costs & revenues…

  • Automatically assign department to supplier payment

    Idea is for a function where supplier payments are automatically assigned to the department/s of the invoice the payment is made against. It would make my job so much quicker and make my reporting more accurate and complete. I can see that this has…

  • Prior Year Report to be run by Department

    I run the "Prior Year Report" (PRYEAR) (within Nominal Codes/Reports/Profit and Loss) on a monthly basis. I would like to be able to run this by department. "Department reference" isn't an available criteria on this report; please can it be added as…

  • Invoices and Credits - Department Column

    I work for an IP firm where the Sales Invoices are entered in through the Sales and Credits tab. We can filter by order taken - which in our case is the secretary (sage user) who created the invoice or credit. However as some of the secretaries work…

  • Departments and projects

    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…

  • Better advanced budget/forecast reports

    FormerMember
    FormerMember
    Report that shows the forecast and breakdowns by nominals/ nominal groups in advanced budgeting mode would help to be able to formulate business plans easier (and to see total budgets through advanced budgets)

  • Nominal Ledger department analysis

    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…

  • Allocate Employee's pay across more than one department

    On Sage 50Cloud Payroll, is it possible to allocate an employee's pay across more than one department to allow us to time apportion their salary? There are older questions on here similar to this but is this possible in V27

  • Monthly Profit and loss account by department

    Hi, I know there is a profit and loss account report that splits by month for the whole company, it would be great to have that option by department as well. Is that something that could be developed for the reporting options?

  • Departmental P&L drill down reports

    Departmental P&L drill down reports with in departments

  • Departments should have an inactive flag to stop entries being posted to them.

    Departments should have an inactive flag to stop entries being posted to them. It is ridiculous that 999 departments are available to be posted to whether they have a name or not. On a support call I was advised to name the ones that you don't want…

  • Project Departments

    Could you add the department number to projects, to enable all purchases and sales to be defaulted to that department when the project number is entered.

  • Setting up departments...without Payroll?

    Hello, Our company is wanting to set up departments in SAGE 100. From what I have gathered, this function is only included with the Payroll module. Can someone confirm this? I would hate to tell my managers that we can not do this without Payroll when…

  • Department allocation for customer product invoice

    I cannot find a way to include a department number on sales invoicing screen, there is only a field for the carriage. So when I want to run a department P&L, it's so frustrating that the sales are not appearing (only carriage!). Is there a way to resolve…

  • Nominal ledger activity by department

    I used to be able to print a detailed report of all nominal ledger transactions by department code. Initially this was through Nominal Ledger & later through Departments. I can't find this option now does anyone know if it's still available?

  • Adding elements to Department analysis gross to net report

    Hi All, Not sure if anyone can help with this, but i'd like to add some fields into the departmental analysis gross to net report, this is to enable us to see salary, overtime etc. on the report. I've spoken to a consultant at Sage and they said I…

  • Departments and COS

    I hope I can explain this correctly. I'm looking at setting up a Dept for a single business unit that we'd like to track separately from the overall business. So far it looks like it will work very well. The only thing that I can't seem to get to work…

*Community Hub is the new name for Sage City