Browse By Tags

  • Inventory Valuation Report, Decimal Places for Last Unit Cost

    Is there a way to increase the decimal places on the report for Avg Cost or Last Unit Cost? The reporting for cost, is inaccurate as it rounds to the nearest penny. The value of many products may be based on purchases in hundreds or thounds of an item…

  • 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 …

  • Last Time Purchased - Inventory item

    I am looking for a report that identifies the last date an item was purchase.

  • Warehousing Items Sold to A Customer & Accounting

    We are producing a custom item for a customer. They will be charged $20,000 for their first order on Net 30 terms...which covers the full run. They will only be taking a portion. The remainder will be on our property and when we ship out any of the balance…

  • Low Inventory Alerts

    Send an email alert when inventory level of an item goes below a set threshold (when inventory of x is at x level send email notifying low inventory).

  • Automatic Inventory BOM add on

    Good day I am seeking an add on to Sage in which an inventory BOM runs on raw material when a finished product is invoiced out. Is there such an add on available? Thanking you in advance Nadine

  • Inventory

    I am really new to Sage program. I ran a physical count variance report after a physical count was done. However, the Quantity on Hand shows zeros for every item. What did I do wrong> Thank you

  • Data Repair Service Provider?

    Has anyone found a company that can dig deep into a Sage 50 data file to uncover and repair issues. Our file has countless issues now e.g. different inventory numbers for the same item in the same location depending on what report you run and who runs…

  • 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…

  • Inventory

    Just had sage 50 premium installed at work. I manage our supply warehouse. I issue cleaning supplies, office supplies and forms to other areas of the facility. I know Sage has a lot more features than I actually need. I don't receive money, I don't spend…

  • SAGE 200 Diagnostic Tool

    Hi all, SAGE Evolution Version 10. There is a small issue with the diagnostic tool, Inventory, Transactional Quantities. The script does not provide for warehouse quantities. If you need to run the script, use the on below directly in MS SQL Management…

  • field to assign specific inventory items to specific customers

    im in manufacturing and having a slightly more in depth 'customer profile' would be extremely helpful. I have 100 or so regular customers that only order items specific to their company, trying to look up their specific parts (inventory items) becomes…

  • Point in Time Inventory

    We have purchased a company using Sage 100 and will need to identify the inventory on hand at a particular point in time. The ERP system we have has all inventory transactions in one table, thus it is possible to start at the end or the beginning and…

  • A further automation of Lot Tracking and Bin Tracking

    Client tracks medical supplies with Lots and expiration dates, which are stocked in bins using Orchid Bin Tracking. They would like to add a few alerts and or processes; for example, when product has X days left before expiration, put it on Quarantine…

  • Build from Item Assembly - Additional Costs account selector

    When building from Item Assembly, can we get a magnifying glass to allow the selection of the account used in Additional Costs Sage 50 users currently have to go into Setup > Settings > Inventory and Services > Linked Accounts everytime we need…

  • Bill of Materials - Parent & Component Serial Numbers

    The Bill of Material allows a parent item with components. Is there a way to create a serial number for the Parent Item and then assign serial numbers for the components? Thanks!

  • Sales Order - Stock Status on Sales Order Quantity and Sales Order by Item Report Quantity are Different

    For one item / warehouse (that we know of so far), the On Sales Order quantity listed on the Stock Status report and the quantity on the Open Sales Order Report by Item report do not match. Actually a difference of 4300. Can't seem to find a reason. I…

  • Adding a large amount of new inventory

    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…

  • Internal Inventory

    I'd like to keep track of internal inventory. For example employee gloves that we keep in a stock room. I'd like to have a total of what's in the stock room and then adjust as we buy more or when an employee takes gloves.

  • Issue updating Inventory Transaction Receipt Multi-Bin Distribution using BOI

    When attempting to create line items for a Inventory Transaction Receipt batch I'm having issues when I attempt to update the distribution. my code was working on Sage 2018 but they are upgrading to Sage 2021 and it now throws an System.Runtime.InteropServices…

  • Inventory Item Type

    Do you have to list a product type on the Item Maintenance screen? What if you don't want to breakdown your inventory items?

  • Update BinLocation?

    Hello, Where in Sage can the user update IM_ItemWarehouse > BinLocation? We had Scanco's MultiBin product and are in the process of disabling it, and there are values in this field but I can't get at them. Thanks!

  • Inventory

    The company uses the FIFO inventory method. The same Item ID is used for sales from stock and also drop shipments. I'm thinking this will/could affect the inventory valuation. Is there a better way to order and invoice drop shipments?

  • Inventory management solutions

    Hi All, I was wondering if anyone has used any 3rd party inventory solutions with BW. We find that the inventory module isn't quite doing enough for us and are constantly forecasting/managing inventory levels using excel via an ODBC connection to be…

  • Bill of Materials and Transfers

    I just want to bounce some thoughts around. We're a manufacturing and distribution company. We are trying to take into account how many boxes we use for packing our finished goods. These finished goods are sold to our intercompany via p.o and receipt…

*Community Hub is the new name for Sage City