• Inventory Adjustment Issue

    Our fiscal YE is end of Feb, so inventory adjustments are being made. On the 28th, inventory counts on one item (as an example but this isn't a one-off) were at 27, it was counted at 22, and on the 29th when the manager went to put in the adjustment,…
  • 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.
  • Low Inventory Alerts

    Send an email alert when inventory level of an item goes below a set threshold (when inventory of x is at x level send email notifying low inventory).
  • Data Repair Service Provider?

    Has anyone found a company that can dig deep into a Sage 50 data file to uncover and repair issues. Our file has countless issues now e.g. different inventory numbers for the same item in the same location depending on what report you run and who runs…
  • Paying invoice that has inventory

    Newbie here. When I go to make an invoice paid that has associated inventory items on the purchase it won't let me change payment to cash so my Bank reconciliation is off by these invoices. So the invoice stays as Pay Later. How do I make these payments…
  • Build from Item Assembly - Additional Costs account selector

    When building from Item Assembly, can we get a magnifying glass to allow the selection of the account used in Additional Costs Sage 50 users currently have to go into Setup > Settings > Inventory and Services > Linked Accounts everytime we need…
  • Internal Inventory

    I'd like to keep track of internal inventory. For example employee gloves that we keep in a stock room. I'd like to have a total of what's in the stock room and then adjust as we buy more or when an employee takes gloves.
  • 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…
  • Inventory Summary vs Group Inventory and services

    I am trying to get a download of inventory ready for our Year End. I have categorized and noticed there are discrepancies in value. Through Reports 1) Inventory and services summary approx. $450.00/Inventory icon same 2) Inventory and services list…
  • Building an Inventory Item

    Is anyone able to walk me through the building of an inventory item from start to finish? I'm confused on how to use the program for this... I have a single product, we have multiple things that went into creating this product. I want to be able to track…
  • Deleting inventory that has been invoiced to a customer?

    Hi there, My company has several Inventory Items that we would like to remove from our system for various reasons. Our supplier has discontinued them, upgraded to a new version, etc. However many of these inventory items have been sold to customers…
  • Tracking external processing item costs Sage 50 Quantum

    Hi, I'm trying to determine what the best way to track the costs of external processes on inventory items? hoping some folks around here could chime in. RM=RAW MATERIAL AS=ASSEMBLY FG=FINISHED GOOD EXAMPLE: 1. 10 x Widgets item number (RMWIDGET1…
  • 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…
  • Is there a way to get a report that shows "Last date of Revenue" in Inventory?

    Trying to condense our Inventory list to include those items that have been purchased in the last 7 years. I am trying to find a short cut or report to make "invalid" parts removed from list but not deleted. I don't want to go into each item line by…
  • Price List Markup

    I'm trying to update my price list for a certain customer to be COST + 10% - example I have an item with a MAUC cost of $10.00, want to sell it for $11.00 without manually having to look up the cost every single time. When I pick to markup COST with the…
  • Inventory

    Hi there, We started using an app called Jane and instead of entering the inventory items twice in Sage and Jane, we decided to simplify and keep a detailed account of our inventory in the Jane app only. We entered the expenses and sales in the Sage…
  • Inventory Tracking

    New to book keeping and new to dealing with inventory... I'm confused how we deal with inventory tracking in sage 50 Canadian edition. I set up our inventory module and added inventory items successfully. For each item, it asked me to link an asset account…
  • Changing Inventory Prices

    We own a manufactoring company which means we import a lot of raw materials. our prices are always changing. is there away to view the last date a price was updated to see if it is the current price? Currently I am tracking down the paper invoice for…
  • 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.