• Sales Reports

    Hi, I'm using Sage 50. Could anyone help me on how to run a sales report which can show Item Description from the invoice? Thanks
  • $0 purchase orders

    I need a list of all POs that are $0.00. I can see them when I "Find an Order" under Purchase Orders. But I need to export to excel. How can I do this?
  • Detail Reports For Multiple Years

    FormerMember
    FormerMember
    Is there a way to get a detail report for a Balance Sheet account for multiple years without having to do them one by one? For example. a detail report for the bank account for 5 consecutive years?
  • How to see hours worked in Job Site report after Payroll is submitted?

    I have the 50 Accounting CA version, that allows me access to Job Sites/Time Cards/etc. I recently learned about the Job Site feature; where you can allocate hours worked and materials purchased to a particular project that we have on the go. Currently…
  • Reports - Microsoft Office Documents

    Sage 50 Pro Canadian Edition I'm trying to print a Chart of Accounts with GIFI codes. Since the Code field is not available to the Chart of Accounts report, I went to Reports > Microsoft Office Documents... and found in the resulting list a report entitled…
  • Crystal reports inserting duplicate unwanted field - what am I doing wrong?

    I know there's still some fellow "old school" CR users here ... I am updating our check form - simply making a couple of minor alterations to PAYRLCHQ.rpt I want to replace 47/100 with 47 Cents The form has no 'Page Header' when I begin. I click somewhere…
  • Compare customer sales over two periods?

    Is there a way to compare customer sales over two periods? I would like to see how much we sold to a particular customer last year vs. this year, but I can't seem to find a report that covers that.
  • Project Reporting Only Goes Back 1 Year?

    We have some 'straggler' projects from 2014 that are still active projects. It seems I cannot generate any Project Income report that uses a date earlier than Jan. 1, 2015 now that I have rolled over into 2016. That seriously sucks :( Are there any…
  • Is there a way to get inventory values to subtotal by category?

    I setup inventory items using categories. But I can't find a way to show inventory values with category totals. Is there a way to get inventory values to subtotal by category? I setup a retail jewellery store with the following inventory categories…
  • Report to show sales vs cogs by department by invoice

    Company has four departments, each representing a physical store front. Inventory is setup to the main revenue, cogs, asset and accounts. The department can only be determined at the time of sale. So the invoice is generated, revenue department is chosen…
  • Project Budget Detail Report

    I am trying to run my Project Budget Detail Reports - Actual Vs. Budget, however the first line of expenses has minimal amounts listed under "unassigned budget amounts". I am not sure why that is or where to go look for the error or what was missed. Does…
  • material requirement planning for upcoming orders

    We manufacture cosmetics and we use the Bill of Materials for all of our recipes. When we make a batch of product, the BOM takes the raw materials out of inventory. We have a small amount of make-to-stock inventory, and we also make to order. It would…
  • Tax Summary Print Out for GST

    Does anyone have any idea why, when I print the Tax Summary for GST that there would only be purchase information appearing and no sales information? Any help would be appreciated. Thanks! Elaine
  • Reports

    Good morning. I have two visas set up in my accounting and made some simple errors that i then fixed (ex: using wrong card for transaction). that has been fixed. But now when i print out my transactions by account report for each card... the wrong vendor…
  • Problem with report in EFT

    Hello! Since I upgraded Sage 50 Canadian Edition in October, I get this error from EFT when generating the report "Erreur d'execution 713: Erreur definie par l'application ou par l'objet". Can anyone help me with that please? Thank you
  • Reports Quantities

    Why aren't there any quantity totals in reports? Most of the inventory reports do not total the quantity column; Inventory Summary, Inventory Quantity and Inventory Statistics in particular. Also the Customer Sales Detail reports do not total the quantity…