• Bringing in a large value item, but want it to equal Zero

    We have an item we need to bring in that is a large value item. The problem with this is that we are bringing it in through RMA. We need it in the system but cant have this value show in our books. Is there any way to have its value show Zero in our books…
  • IZ TYPE CODE

    How does an IZ TYPE CODE IN INVENTORY TRANSACTION ENTRY populate?
  • Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • Extended Item description

    I have entered an extended item description for a new item. We have all the options on sales orders to print these out, we print the descriptions daily, but this new item will not print the extended description. Any help would be appreciated.
  • I have used Sage for 30 years and need to utilize purchase order and inventory modules.

    Where do I start? We are a manufacturer and I purchase raw materials and sell the finished product. I currently use the sales order module for sales orders & invoicing. I need direction and recommendations.
  • Non-existent items

    We're currently using the Sage100 C# NuGet package noted below. We've run into a situation whereby a miscellaneous item (CI_Item) is visible in the UI and via OBDC connection however, we're unable to find the item using the MASRecordset utilities…
  • Allow Trade Discount

    Is there a utility that will allow me to check the "Allow Trade Discount" box for a range of inventory items?
  • Item Maintenance - Item Pricing Maintenance roles

    Hi all I seem to be having an issue changing role settings to not allow a user to create new item codes but allow them to override pricing in Item pricing maintenance. Can this be done? When I untick the box on "Create" under item maintenance it seems…
  • Duplicate Item Numbers

    Hello, I was wondering if anyone else ran across this issue and if so, how it was resolved. We have identical item numbers that appear when we search for an item in item inquiry and item maintenance. Selecting one of the item numbers results in…
  • Retaining history when changing item code

    Is there a way to change an item code or merge with a new item code while retaining the sales history from the original code?
  • Item Valuation Change Selection: Phantom Connected Users

    We have had this problem since switching to Sage 100. When we try to change an item's valuation in the Item Valuation Change Selection task in Inventory Management, and all users are logged out of Sage, we get the below dialog: When I click More…
  • Pre-Totals Script - Accessing Item Information Using oLines.GetChildHandle("ITEMCODE")

    I have a script on the pre-totals event, that loops through any line items, and needs to get item related information for a given item. The problem I'm running into, is that in certain cases, the script runs, but the item information is returned as blank…
  • Can you add new products using Visual Integrator?

    I need to add several hundred product from our website into sage. I can export product codes from our website, and I'd prefer to format descriptions on one master excel sheet. Can you "mass add" products using VI? I'm a bit new to VI, so I wanted to ask…
  • Can't Add New Product Codes in Item Maintenance

    When we enter a new item code into "Item Maintenance," it used to create a new product in the system. However now when we enter a new product code, everything goes blank, but it says "NEW" right by the Description (as it would do before). Everything else…
  • Trying to rebuild sort files in Library master Util. And getting an error when running it on Inventory Management

    Hi guys Like I mentioned above when I try to re-build the sort files on Inventory management, I'm getting the following error "You cannot proceed with unposted data in Item Transaction Tier Distribution entry". Can anyone tell me please how can I fix…
  • Add a column in BIE? Help, I am not that smart!

    I am trying to make a custom report in Business Insights Explorer that shows: Item Code Item Description Product Line Quantity on Sales Order Total Quantity on Hand But I cannot link a "Qty. on Sales Order" column to the rest of the report…
  • Script to update a Date UDF

    Hello, I am a bit new to scripting on Sage and would like some assistance if anyone is willing. I am writing a script to update a UDF date field based on any change on the specifications Tab in Item Maintenance. I have attached my script below. I am…
  • Figure incorrect on Item maintenance Screen

    Hi I am having an issue were a figure on an item we have is not being reflected properly. Under orders it shows we have 100 + 80 on purchase order but when we look at PO field it only shows 100. I have ran the rebuild sort files for both item maintenance…
  • Creating a New Line Item in Common Information using BOI

    I'm stuck and can't quite figure out why. Below is a script I wrote to add a new line item to the CI module (I copied and pasted from several places). If SetSession("C/I", "CI_ItemCode_UI") Then writeLog("Connection Complete - Item Maintenance") Try…
  • VI-JOB IM_TRANSACTION_HEADER

    RUNNING SAGE 100 V2017 . trying to create a VI job to adjust inventory for returns. what are the transaction types mean? 1,2,4,6,8 ? also, what fields do I need to import into to make a successful entry. for EntryNo , can i just select Next…
  • Why doesn't standard cost update to the latest price entered in Item Maintenance?

    I am wondering why the Standard Cost does not update in the Item Maintenance window. The item is set to Standard Cost in the Valuation slot, but when we enter a new updated cost in the "Last Costs" category, the "Standard Cost" space, in the Purchases…
  • Using SQL in script

    Does anyone have a very basic example of how I can integrate a SQL statement in to a script? I've run into plenty of occasions where I wish I knew how to accomplish this, here is my current goal: We ship using Starship and for a variety of reasons…
  • Filter Inactive Items in BI Explorer

    Is it possible to filter Inventory Items or Customers that have been set to Inactive from BI Explorer views?
  • MAS90 -EDI 846??

    Hi, Let me start by saying I am new to MAS90. The issue we have is trying to create an 846 doc (using Gentran Director). We have a report called Inventory Stock Status Report, that give's the information that I need for my 846 document. but when I try…
  • Can I create a UDF or use customizer in Item Maintenance to have the ability to view our BOM's for each item?

    When we view items in Item Maintenance, we would also like to see the BOM's listed on the Header. We want to see exactly how we calculated the price directly on IM and not have to open another module, then revert back ti IM. We have a lot of items that…