• Reports not matching and Database Utilities tool not working

    I am having an issue with inventory reports not matching, and showing false negative quantities. The inventory quantity report will sometimes show negative Pending Sales Order quantities, and currently I am seeing negative quantities for some items only…
  • Last Time Purchased - Inventory item

    I am looking for a report that identifies the last date an item was purchase.
  • Time Allocations to projects

    HI, I just started with an existing company, all time allocations are posted to projects. Those costs do not show up in the Project Income or Allocation reports. What am I missing? Thanks
  • Projects

    New to projects. I have a few questions about set up. We are a non profit and rely heavily on donations. We aim to allocate all/ most chart of accounts to a project code instead of using sub accounts. We have been using the feature for fiscal year 2022…
  • Report options - Allocation by account

    I am aware that you can print of a report for Transactions by account, and also a report for project allocations. Is there a way to print off a report that would be teh transactions by account, with the project allocation included in the line item…
  • Project Allocation

    My goal: when I enter a sales invoice (for condo fees) for residents, I wish to allocate the condo fees to a project--the project will be the condo suite number. My condo fees revenue account is "4105 Condominium Fees." When I go to enter the condos…
  • Project Allocation to a Revenue Account

    Trying to delete this post
  • How do i generate inventory reports in Sage 50 Premium that will let me omit inventory items with zero quantity

    When I choose an inventory summary report for the 25 warehouses I have, there is no method for me to reduce the size of the report to omit products that have zerol quantities. I use the Sage 50 Canadian Premium version. Any help is appreciated.
  • Aged Inventory

    Good day I am wondering if there is a way to run a report to see all items in stock and their last sale date? Essientally I want to run a inventory report of all of our aged/obsolete inventory based on Sales Date and then be able to sort by bin location…
  • Report - Purchase Order with unit cost per Item

    Hi, I need to run a report with all the open orders to excel file with the following information, and I haven't been able to extract unit cost per item PO #, Supplier name, Item # , Unit cost per item Right now the report just provide total…
  • I would like to know if there is a way to view departmental income statements older than the previous fiscal year.

    Hi There, I would like to know if there is a way to view departmental income statements older than the previous fiscal year.
  • Inventory Report with o/s Sales Orders vs Stock on Hand

    In addition to the Sales Order report by inventory item - detail or summary, is there a way to include inventory on hand? This report is helpful to monitor our sales orders o/s and inventory level to see if we need to order. Thanks
  • Allocated asset accounts not showing up in Projects reporting

    I have a Sage 50 file set up to allocate to projects. Sometimes I'm allocating expense accounts, but most often I'm allocating either inventory or asset accounts to purchase invoices. I want to print a report showing the total (summarized) amounts allocated…
  • Inventory Alert in Client Orders

  • Inventory Quantity Reports incorrect!

    Have an issue with the inventory report: "Inventory Quantity" In the "On Customer Order" column, it is showing amounts that should not be there? Showing negative quantities, like when you have a pending sales order for a customer. The problem it…
  • Journal Entries-Departments-Viewing

    Hello, I am looking at the General Journal making sure the first entries are correct. I see a couple of departments there. Is there a way to sort via departments. I like to view one account at a time.
  • Product catalog

    FormerMember
    FormerMember
    Is there any way to produce a simple product catalog that includes pictures from the inventory module?
  • Lot allocation reports and GST paid

    Hello, We are home builders and am using the lot allocation part of Sage50. I need to run a report that shows a breakdown per lot of purchases, which I can do, but it shows amounts before GST. It doesn't include an option to include a breakdown of…
  • Invoice inventory packing slips

    I'm looking for information on where to enter product information that is required for TDG requirements. The old Sage software I used allowed me to classify products that were a dangerous good, include text requirements and the weight by unit , under…
  • Inventory Report - Cost of Items

    Hi, I'm trying to do a report to find the average cost that we paid for each inventory item. I'm just not exactly sure which report to use. I've done a Price list report and have used the Raw Cost column - is this the average that we have paid for…
  • 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…
  • Project & Activity reports

    Sage 50 Premium 2013 - Just started using Time & Billing. My client has projects A, B, & C, and within those project are activities 1, 2 & 3. We assign both project numbers and activities on each timeslip. Now how do I get one report (prior to invoicing…
  • 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…
  • Purchase Orders

    FormerMember
    FormerMember
    We are trying to implement using purchase orders through our accounting software. I just have a few questions: 1) When I print a purchase order off there is a section for description, but when I am creating a new purchase order in the system I don't…
  • 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…