Browse By Tags

  • Nominal transaction reports to include a correct brought forward figure

    Customers migrating from Sage 50 to Sage 200 have requested the ability to run a nominal transaction report that includes a correct brought forward value of transactions prior to the period running the report from. Brought forward values are shown correctly…

  • Report Designer help

    Hi All I am trying to amend the invoices and credits by customer report so that it shows the carriage charge invoiced. I have added the expression to calculate the carriage charge which it has done but i notice that if the invoice has more than…

  • How to do styling with Sage.Accounting.Reporting?

    Hi all, on one of my report, I need to do get the column header and its value dynamically. So now, I need to generate the header by coding. But now the header is plain and default font. I would like to do styling on the header. How to do font styling…

  • Report Designer - Distribute and Extend

    With the report designer, can we have 2 more options for laying out objects? Can we have "distribute" which works with 3 or more objects and evenly distributes the objects between the first and last object's anchor points? As per Visual Studio. Can we…

  • Report Designer exporting Data to excel query

    Hi When I export a bespoke report to 'Data to excel' the data columns are not in the correct order: IE. Column G - PaymentAnalysis.Desc2 Column H - PaymentAnalysis.Desc4 Column I - PaymentAnalysis.Desc6 Column J - PaymentAnalysis.Desc10 …

  • Grouping Report Sections

    So this question is based on a report I've been working on for while and just can't crack. I'm trying to create a report which is effectively a total requirement list for a Sales Order. It needs to list the sales line items together at the top (effectively…

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

  • Endpoints relating to dbo.StockItemPeriodBalance

    Unfortunately in the current Sage 200 Professional API there doesn't appear to be an endpoint that would provide an approximation of the data stored in dbo.StockItemPeriodBalance. Altough these tables have great data within them. One example,of Period…

  • Report Designer code-watch tool

    In Crystal Decisions you can test run a report and view the commands as the report steps through them during runtime – this is really useful to see where a bespoke report is falling over. It would be very beneficial to have such a tool for the Sage…

  • Report Designer - Group by one, Sort by another

    I want to create a SOPS report Outstanding SOPS Grouped by Sales Order Sorted by Due Date (Sales_Order.Despatch_Date) I've tried using a standard report; however, I can't seem to change to details to allow both grouping of items by order number…

  • Remittance.Extra_Ref

    Sorry to repost this issue again but I am desperate to find a solution. I am using Sage 50c Accounts Essentials. When I create the email with my remittance attached in pdf format the Extra_Ref value does not appear even though the data field is on…

  • How to make Group Header / Footer not appear on report when no values to show?

    Hi, I've have tried a few expressions and filters to figure this out, but I can't seem to crack it. I want the group header and footer to not show if there are no values in the details section within the group. See image below. For reference, this…

  • [Report Help] Invoice Summary to not take 'Credits' into consideration?

    Hi, I am running a report in the Invoices and Credits section of Sage 50 Accounts Professional. This report gives me the following information: A list of the products sold for that month itemized in alphabetical order The net amount made from…

  • Repeat Order Report

    Hello all Aim: In an attempt to contact customers to offer 'special offers' or encourage more orders, I would like to be able to look through customer's previous orders, recognise the 'repeat orders' and establish a 'special offer' or at least a reminder…

  • Agents Commission Report filtered by Stock Category

    Greetings All, This may not even be possible, but I will do my best to articulate what I'm trying to achieve and hopefully someone is able to help. I'm using a report from the Customers tab > Agents Commission (@10%). I have modified this slightly…

  • PNL

    I want a "Profit and Loss (Monthly Breakdown)" [Filename PNL_MTH] - BUT, for the previous Financial Year. Is there one available?

  • Davis Bacon wage survey report

    I am looking for a job cost/payroll report that will show the the peak weeks worked on any project by trade or department that can be run by period end dates/specific timeframe. Anyone know of a report that will accommodate this?

  • Report Designer - NEWDATE to generate LM(Last Month) and MTD(Month to Date)

    I am really stuck, have spent too much time spinning my wheels on this. I have created a new report with values coming from Job cost, Contracts, Billings etc all coming from transactions using Accounting Dates. I am using a Prompt so I have a "Cut-off…

  • AP Historical Aging

    Does anyone have an AP historical aging report they would be willing to share? Either in report designer or office connector. Thanks in advance, Amanda

  • Report Designer

    i am having some issues with a custom report that i have created in Report Designer. I have created a formula to sum JC data for all building activity and it is returning some weird values on some of our job costs. it seems like it is not recognizing…

*Community Hub is the new name for Sage City