Browse By Tags

  • Importing Vendors

    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…
  • Update Inventory Item Costs

    Hi There, Slight Background: We currently operate on an Average Cost Valuation Method within SAGE 200, With that being said, we are also within the manufacturing industry and thus, once a manufacturing Process Order is closed, A finished product …
  • 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…
  • 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…
  • Inventory Adjustments Journal Field Import descriptions are incorrect

    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…
  • Yearend Utility and Inventory Count

    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…
  • RE: importing item error

    Hi bmorgan21, Thanks for the question! It is possible columns are not matching your import file. Also you can try to eliminate other columns and capture required fields only as outlined in this article. KB 12233: Which fields are required for importing…
  • 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…
  • Importing Inventory Records

    When attempting to import inventory records we get an error "Category Cannot Be Blank" We have an entry in the category field. We even updated the inventory record with the value manually and then again attempted to import and we still get the error.…
  • Bulk Import of Items in I/C

    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…
  • Importing inventory prices from Excel

    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?
  • Inventory - batch processing

    Hello, We have to take inventory and any advice you have is appreciated. Our inventory is in parts bins on the shelves sorted by product code and then part # I envision batching out of BV by product code to a paper report Taking that report…
  • Daceasy 13 to Sage 50

    I bought a manufacturing company that has used Daceasy 13 for the last 10 years. I need to import vendors and customers and products and inventory into Sage 50. The accounting is starting from zero since it was an asset purchase. I have talked with 3…