Browse By Tags

  • Sage 50 US. Search for inventory items using "description" keywords, inside the sales order.

    Can anyone please help find out ALL the ways possible to search for inventory items using "description" keywords, inside the sales order. Say, there are hundreds or thousands of ID's, there is no way to know or remember them. But the users know the…
  • Sales tax and Income account from Invoice to General Ledger

    I have a client who has hundreds of invoices to bill clients. They also have various inventory items of which it assigns a cost and charges sales tax. Is there anyway to combine sales tax of an invoice into one line item instead of separate sales tax…
  • Make Pictures automatically pop up in the "Maintain Inventory Items". Please.

    This is the sole reason why we can't switch to Sage50 for inventory purposes which would make our business process much better, since we use Sage50Q for everything else, because inventory and other personnel MUST see the picture right away when they are…
  • Inventory Movement Analysis/Report

    I am looking for reporting that shows both purchases and sales with quantities and $ CR/DB. Found reports do not show data on items with Current O/H of zero or do not show the desired detail. Working with LIFO inventory and would also like to be able…
  • Setting up inventory items and assemblies

    As an example, I sell Receiving Sets which include a Burp Cloth and a Receiving Blanket. I set up the items Burp Cloth and Receiving Blanket as stock items with the inventory account 12000 (supplies). I set up an assembly Receiving Set and put in the…
  • Upload Inventory List

    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…
  • Purchase dates for specific GL codes

    I need to know how much fabric I bought each month. When I purchase fabric, I enter the payment directly. I don't use the receive inventory feature. The GL code I'm looking for is 132 (inventory). I use hybrid accounting, accrual for inventory and cash…
  • Do not sell out of stock

    Hi everyone, From already thank you very much. What I want is to be able to avoid invoices being made with Inventory Items if the Item is out of stock. Or at least give the notice that we do not have quantity on hand Greeting
  • From raw material to finished product

    Hello everyone, Currently in inventory we have raw materials as stock item and finished goods as Assemblies. My question is how to handle the conversion of these raw materials into Products for sale. In short, the production. Thank you very much…
  • Sage 50 US Extreme Slow inventory lookup in Transaction windows

    With Sage 2020 and Sage 2021, my clients that have larger inventory (5000 items or more) are having major problems with Sales Orders, Purchase Orders and Sales Invoices when attempting to enter transactions with the Drop Down List and Automatic Field…
  • Problem with inventory beginning balance

    Hi, I capture inventory beginning balance and in dont show in GL Summary Report, some one knows why this happend
  • Why can I not copy an assembly into a serialized assembly?

    My shop manager and I were trying to create serialized part numbers for some items that would benefit from being able to track serial numbers. It was easy enough, but when it came time to add the serialized part number into an assembly, Sage informed…
  • Setup Inventory System

    My company is using Sage 50 for accounting. Our business is to provide beauty treatment services. We would like to use system for calculating the COGS instead of using excel, such like Botox. (because cost is affected by many situations, like invoice…
  • Outgrowing Sage Quatum

    My file sizes are past the quantum limits and I’m starting to get errors, so I’m exploring options. I’m at 300kb quantum recommends 250 max database size 1 Will the Quantum database sizes be expanded anytime soon? Maybe an enhanced version of Quantum…
  • Inventory Report - Duplicating Items

    I have ran the inventory report multiple times for multiple reasons and have the same issue. When I ran the inventory report and downloaded into excel I am finding that it is duplicating many of the items. I am updating list pricing and am checking for…
  • Inventory items - non stock vs stock item issues

    I am trying to reduce the amount of time to address inventory issues with licenses we purchase for our service business. We do have to track how many are sold to each client per monthly period, and how many purchased for that same period. I've tracked…
  • Invoicing Inventory w/ Negative Qty

    Is there a way to not allow billing of inventory items if they are negative? Or a password protected authorization to do so?
  • Inventory Returned and at what point is it put back in to inventory

    We had a customer return some material. We issued a credit memo for these items...each piece was entered onto the credit memo and the quantity that was returned. When looking at the inventory reports it does not show that the material was put back into…
  • Need a solution for Sales Orders with different ship dates

    We are a metal fabrication shop with a manufacturing division. One of our clients sends SOs which can range from 1 item with multiple quantities to 60 items with multiple quantities and different ship dates. I understand we can't do different ship by…
  • Serialized item/Components in Assembly

    Adding Serialized items to Assemblies is a very important feature that we would like to see added to Sage50. For proper traceability from the assembled item back to serialized components, is critical to many industries. Industries such as Food, Pharma…
  • Multiple GL Cost of Sales Acct for Inventory Stock Items

    Ok, maybe I am doing things completely wrong here but for our purposes with track our sales by territories. We have the US split up into 8 different territories and have GL sales accounts for each one. So as we process orders and make our invoices our…
  • Prepaid Supply Inventory Account

    Hi, I started working in a distributor company. and we use Sage 50. We have only one inventory account in our chart of accounts for our products to sale and for supplies (warehouse supplies-packaging, catalogs). Is it correct to have only one account…
  • Inventory Item Field Length Limitation - Can It Be Increased?

    We are just beginning to use Sage 50 US with Inventory Items and have discovered this past week what appears to be a 20-character Item Id limitation. I have seen some comments here and there that seem to indicate that this filed length can be increased…
  • Inventory Adjustments pulling negative balance

    We use SAGE 50 for tracking job costing. With this, we do inventory adjustments for a high priced part as soon as we know we need it so we can see if we need to get some on order as they are a two month lead time part. As we do this, this part, at times…
  • Sage 50 2017 Connection Manager

    I have an install of Sage 50 on Server 2012 R2. When I run a inventory rebuild from a workstation on the network it is very slow, it takes almost 10 minutes. When I run the same thing on the server it's done in less than 20 seconds. I have searched for…