Browse By Tags

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

  • Report Filter Expression Based On DATE, But Limited To 12 Months

    I'm trying to find out how to add a filter expression on a report for Sage 50 Accounts, such that the report only looks at GDN_ITEM_DATE that is from the last 12 months from the CRITERIA.GDN_ITEM_DATE_TO specified when the report is run. I then need to…

  • How to do a select distinct in Query tool

    I'm trying to create a new query so that my user can have a list of new prep lists on their landing page. using table STOPRELIS, I was able to create a query but there is a line per product, when I only want the prep list, pick ticket, and so number.…

*Community Hub is the new name for Sage City