Sage 50 Canada

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…

I am trying to setup Power BI to be able to view data from Sage 50 Canadian Premium. I can access data tables, and specifically tproject using an ODBC connector. dStrExpBal (starting balance) for a project is correct, which is up to and including LAST…

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…

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…

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?

This just started happening today. We have entered new service items into inventory. I have triple checked that they are setup correctly. When adding that service item to an sales quote or sales order none of the information that is setup is being pulled…

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…

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?

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…

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…

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…

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…

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…

Dear friends, I have just downloaded trial version of Sage 50c premium 2016 Canadian edition for evaluating if it will serve my main purpose of invoicing and maintaining updated records of inventory. But after opening invoice module in Sage Drive…

One computer used for Bookkeeping and is also server for 4 monitors that acts as a POS type. Is it possible that one monitor can show zero qty for a certain item and yet other monitor can show 750 pcs of same item? What could cause that to happen? Could…

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…

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…

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…

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 have an issue where my Quantities and Values as of date is future dated. No information in the knowledge base to assist...

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…

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…

Dear Sirs, I am using Sage-50 Canadian, Premium accounting. When opening Report for Inventory-Quantity for a location , the columns of "on purchase" show the quantity as 0 (zeros), even though I have pending purchase orders with vendors; subsequently…

I have never used the inventory feature of Sage as I've never had a client that needed it. Now one of my existing clients opened up a small shop. I took all the invoices of the items she purchased and entered the quantity & value of the goods on the history…