• Last Time Purchased - Inventory item

    I am looking for a report that identifies the last date an item was purchase.
  • 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…
  • 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…
  • 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…