• Can't import stocks data SAGE 50 Canadian version

    Hello, I can't import products correctly in SAGE. It works if I only have the coloumns this way : Exporting and importing inventory and services data using CSV format (sage.com) withtout the cost or category or anything But if I do it this way…
  • 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…
  • Inventory

    I have 3000 items added to inventory and completed this by batch import upload. I now need to add quantities and the cost of these items. Is there anyway to do this?
  • Import Export of Price List

    Hello - I have a client who currently uses Sage 50 Quantum. He wants to quickly adjust his inventory prices so I had suggested he export his Price List, make the adjustments there and then import the amended copy. When we try to import we get this error…
  • Importing 19000 inventory items, where do I even start?

    We are looking at setting up 19000 inventory items into Sage 50 Quantum. There has to be away to set up all at once. Then would I go back in and update the sales account, min/max, low order point, etc?
  • 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…
  • Help with export and importing inventory data

    We have just started using Sage 50 Canadian Premium and are implementing a new database for inventory. The problem is that almost all inventory descriptions contain either an inches (" quotation mark) or feet (' apostrophe mark ) sign. I can get rid…
  • Importing price lists

    When importing a price list what happens if some items are not set up in inventory? Do they just get skipped over or does the item get created and pricing added? Hoping they will just get skipped over as I don't want every item in our inventory but…
  • Importing inventory items from a CSV

    When creating an inventory list in a CSV file. Can one of the columns be for listing the category you want each item to be associated with? Also can I include multiple price lists (include my own created lists)? Lastly what order would the columns be…
  • Importing Inventory Data from a CSV

    Hi All, I have been reading the following thread: https://support.na.sage.com/selfservice/viewContent.do?externalId=10124 I need to import inventory data from an excel spreadsheet (exported from Tally 9). I created a .csv file just like it mentions…
  • Importing

    I have 14,000 items already in inventory, that I need to make a lot of changes to the detail/description. I thought Importing a CSV file would be no problem (as that's how I got the initial inventory in) but when I try this, it says I can't import to…
  • importing inventory into Sage 50 Quantum -

    I exported inventory in Sage 50 Format, and opened the text file in excel. I entered the new inventory items I wanted to add, saved as the text file, and tried to import back into Sage 50 Quantum. Error message is "Error importing records. The import…
  • Update Price List

    Hello All! I've run into a problem trying to perform an update using the Update Price List feature on our Sage 50 Quantum Accounting (Release 2015.3). I've created a .csv pricelist and have tried to import it using the Import Records Import Wizard…
  • Change Inventory Item Numbers

    I am using Sage 50 Quantum and am looking to do a mass change of inventory item numbers. Is there an easy way to do this? Keeping the old part numbers as a reference would be a bonus.
  • I imported all my inventory, but now how to I import opening balances

    Hey Everyone, I'm sure this was answered in the past but I can't find the post, maybe someone can help me out. I have Sage 50 2015 Canadian edition, I imported over 16,000 items (yes, 16,000) as we are moving from DacEasy 9.0 to Sage. All my items are…
  • Mass change of inventory item numbers, while keeping old number for reference?

    Hi, My company is looking to completely overhaul its inventory numbering system, meaning that 1000+ inventory items are going to be receiving brand new numbers in our system. We want to still have the old part numbers on record as we will have to be…