• 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…
  • Import inventory list with stock

    Hello - I know this article shows how to upload your inventory listing ( https://ca-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=220924150010124 ). But how I update the stock currently on hand as part of the upload? I can't make…
  • Website integration to sync with inventory in Sage 50

    I am looking for recommendations for syncing our SAGE 50 Premium CDN edition inventory to our website. SAGE still has no functionality for real-time syncing our inventory in our software to a website. Anyone use any third party apps or companies that…
  • CLEARING OUT OLD INVENTORY ITEMS/DATA

    I have a number of old inventory items i would like to clear out but Sage won't allow me to unless I clear the look up data first. However agreeing to this prompt window that pops up does not tell me if the next screen will allow me to choose which inventory…
  • Inventory Item Linked Variance Account

    Is it possible to change a linked account on an inventory item that has been created and already has history of purchases/sales. I inadvertently selected the wrong Variance Linked account and am now trying to fix the error.
  • Last Time Purchased - Inventory item

    I am looking for a report that identifies the last date an item was purchase.
  • Contractor Inventory Materials and Labour

    Hi All, We're a small contracting company, and we just closed our first year. Last year we didn't link our sales invoices to inventory accounts, rather manually adjusted which wasn't a big deal because we have fewer, larger invoices given our industry…
  • Setting up Raw Materials and Sub-Contracts for Inventory Items

    Hi, We are a small company. We purchase raw materials, inventory them in Sage with RM codes, and then we add some services/ cost (printing, perf, or slitting) and sometimes forward RM to sub-contractors for slitting; which are then returned to us…
  • Unable to fix negative COGS due to adjustments in inventory module ?

    We are a factory using Sage 50 Quantum. We use average cost and quantities were not negative. I managed to set the correct quantities and values of the inventory by using the inventory module, by first resetting the value to 0 in the module and then adding…
  • Harmonized Code - Inventory

    Is there a place to enter the Harmonized Code for each inventory Item and have it print on sales invoices.
  • UPC Code Units vs Cases

    Hello, Our business buys all product by the cases, which have a UPC Code. When we sell the product, it can be by the case or by the unit. The unit also have a UPC Code, different from the case one. What is the best way to link both, units and case…
  • Getting started using inventory module.

    Hi, I'm new to Sage as a whole stepping in as the Warehouse/Operations manager. Our company has been using Sage/Simply Accounting for many years but have never used the inventory module. As being new to Sage I'm afraid of messing up any other data within…
  • Inventory for items not for sale

    Hi everyone, We use pallets to ship our produce and we want to start keeping track of the pallets. Can I do this as an inventory item in sage without money involved. I know I would have to assign accounts to the items but not sure what accounts to use…
  • 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…
  • Inventory items that are the same except for the colour

    Hello I have a couple of hundred inventory items that I want to import to Sage 50 Premium using .csv Many of the items I am referring to come in multiple colours. Can I import just the "master" item (as I like to call it) and somehow differentiate the…
  • Fix Inventory count without adjustments?

    FormerMember
    FormerMember
    I realize this question may be very similar to others, I did look around though the forums... the answers to me didn't seem like they were what I was looking for, but I'm not an accountant in any stretch and started using Sage 3 weeks ago so please bear…
  • How to get started with inventory items?

    I am a total newbie with inventory and don't know how to enter all the new products that I bought that I would like to resell. My accountant told me to handle inventory outside Sage but didn't tell me how I should best do that. Plus, it seems that there…
  • Inventory Balance Without Inventory

    FormerMember
    FormerMember
    I'm new to bookkeeping and have taken over from someone else who set up the books. I am unable to close history due to Inventory B having a value of $1,000 entered into history but not having any actual inventory linked to it. Error reads: The total…
  • Inventory Capabilities

    I've been approached by client about the Sage 50 capabilities in comparison to their current program. I believe that Sage can cover all the same but, would like other opinions. Create Purchase Order Receive Purchase order, have items go directly into…
  • Year End can not start a new year due to the inventory value not balanced

    I am stocked and can't start a new year, due to this 0.02 and I can't find out who to make it balanced, does anyone can help me?
  • Setting up the inventory item

    FormerMember
    FormerMember
    Hi, Please help. We buy kit which consist of different parts. And sell each part to customers. How can I set up this in Sage. Right now we can only by kits and sell kits, not parts in kits. Thank you
  • Sage 50 CA, Live commodity prices

    FormerMember
    FormerMember
    We are a jeweler and we also buy scrap gold, gold bars and alloy metals. This question/discussion would apply to any business that deals in commodities. 1) is there a way to integrate live gold/silver prices into Sage? Preferred feed would be Canadian…
  • Suggested Linked Inventory Accounts for New inventory

    When I enter a new inventory item under the Linked tab I am able to assign the item to various accounts based on four categories: Asset, Revenue, COGS, and Variance. My question is how "granular" should I be in regards to the assignment of these inventory…
  • Cannot enter inventory adjustments. Help please?

    Using sage 50 premium accounting. I recently started at a place that has their inventory listed in sage. It is our year end now, and I can't make inventory adjustments to actual because: When their inventory items were originally entered, they entered…
  • Auto-generate purchase order's.

    Hey guy's, So we finally added inventory to our system and we were hoping that by setting stock minimums we would be able to auto generate purchase order's. I was chatting with the tech support and they told me its not possible with the Canadian…