• 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.
  • Issue with project allocations

    Hi, I have two questions.. 1) When i pull a project allocation report for this fiscal year (April 1 - March 31, I'm noticing that certain accounts are only displaying entries from 9/02 instead of 04/01, for example. The project allocation for…
  • 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…
  • 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…