Hello, I am running into an issue when importing vendors. We are mass importing items along with the vendors, but are running into a block on the vendor import.
It appears that this popup might be blocking the vendors from being imported. Is there…
I am using sage 50 and the way that I import is —> file—> select import/export —> inventory—> inventory item list where I’m trying to create my own template in csv in order to import item/inventory however it doesn’t go through which I believed the template…
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…
We are adding a large number of new products to our Inventory Master list which requires new part numbers, adding each part to the Pricing list, entering the quantities for each part and its location. What is the most efficient method to add this information…
Is there a way to upload an Inventory List into Sage 50? I have around 70 items that would be a million times easier to upload once, in lieu of keying them in individually.
I have searched the Sage Knowledge Database, but cannot find any articles…
For the past several weeks I've been trying to import my old Peachtree 2009 data into Sage 50 Premium 2021 and everything has been smooth until I import the BOMList Journal and Assembly Journal . I've followed the import/export instructions step by step…
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…
I want to add an item to Sage 50 through SDK. In Sage 50 I added some category and I need to add the item to that category through SDK.
Is there any methods or property present in SDK to do the same?
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…
Hello City Slickers!
I'm running into issues with template FTISMR while trying to import my initial go-live inventory in Sage EM. My products are version managed and I only use the Major version. after I do a single product import test, Sage gave me…
Here is the field description for the "unit cost" field: Numeric (Real) - Unit cost for the line of distribution; it gets ignored for negative inventory adjustments, but gets used for positive inventory adjustments. ( Note: If this field is not included…
Is there a way to keep track of materials used and labour for a project on excel and export it into sage as a sales invoice? I have been weeks trying to figure out the easiest way to keep track. I could use time slips to keep track of labour but it doesn…
Good Day,
I am trying to import my inventory and services in to Sage 50 2018. When I try to import the completed template, I get the following error message:
Error importing records. The import file does not contain a valid version number.Error…
Our company has decided to take on this process and we have a few questions.
I'm already able to export the inventory, update the values in the spreadsheet and reupload them into the system. Am I suppose to do this before or after we use the Yearend…
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…
Hello!
Our legacy data includes special characters and odd formatting for part numbers that I guess we made up along the way and I want to standardise them.
Is there a way to wholesale change part numbers where, for example:
export part numbers…
I'm wanting to add about 600 items to an already existing list of products in our datasbase.
So, I exported 3 lists:
I opened I/C “Items”. I created a script that would contain all the columns we use in that first tab (of the Items Module), and the…
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…
Hello All,
We are currently experiencing a bottleneck where our yearly/bi-yearly pricing increase from our 700+ vendors are not being updated in our inventory system effectively. It seems like a very manual process where we receive pricing increase…
What is the procedure to accurately import to Sage 50 new pricing on inventory items through an Excel spreadsheet? Specifically I am having difficulty in locating the file to import from, does it need to be saved as a certain type of file?