• Crystal report formula to show zero on base "im_transaction history" issued

    I was wondering if any one has done this type report I did a custom crystal report that i'm able to see specific item code, but for some reason when i'm running the report those item codes that doesn't have any transaction history is not showing and…
  • Food Service manufacturer and distributor

    FormerMember
    FormerMember
    My company is a broad line food distributor and we also manufacture deli products such as bologna, salami, etc. We carry about 1,500 different items. There are about 10 employees that work picking order throughout the day and night and its all done on…
  • Reverse Item Merge

    Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…
  • Sequentially numbering Inventory Items - Pros and Cons

    I have a client that is exploring the idea of converting their inventory numbers (most are vendor numbers) to be generic numbers that will be sequential. They are a service company that has 16 years of Sage data. Some parts are drop shipped to their customers…
  • Where can I find cross reference by program information?

    In the pre-business framework days, this information was available in the resources link. I need to know which files are used by the Inventory Trial Balance report.
  • Historical Inventory Quantities

    Hello Sage 100 Community. I was wondering if any of you know a way to view an inventory snapshot of a particular date in history (historical inventory quantity). I'm just trying to see the quantities for all items at a particular date in the past. …
  • Direct Labor Costs Built into Bill of Materials for Items Sold as a Kit (always explode)

    We have a packaging company with a large variety of items which are packed to order. As we don’t prepack, virtually all our sales are through kits with the option selected to “always explode”. We do have a bill of materials (BOM) for each kit as items…
  • What is the best explanation of how OVERDIST (over distribution) tiers that are created using FIFO?

    I understand how negative OVERDIST tiers occur, but a bit fuzzy on how positive OVERDIST tiers occur. Is there a good write up that someone has done that explains this process for both myself and my clients?
  • Looking for WMS to integrate with Sage 100

    Hello, We are a distribution company that is looking to implement a WMS that can integrate with Sage 100. Preferably one that can stand alone as well. We are going through some growing pains and may also be looking to a new ERP in years to come. May…
  • Inventory Stock Status Report vs. Physical Count Variance Register

    We are currently using MAS 200 for inventory reconciliation. I use the stock status report to balance our physical counts to MAS, giving us a potential variance amount. Once I enter the physical count numbers into physical count entry I am finding that…
  • JobOps with Sage 100 ERP using barcoding with JOScan

    Community, We are a mid-west manufacturing company and are looking to implement the JobOps product with barcoding using JOScan. We are hoping to find another company presently using JobOps with Sage 100 ERP that might be willing to share their experience…
  • 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…
  • system will not let me delete/change an item in inventory

    operating in Sage 100 i have old "incorrect" part numbers that i need to just completely delete out of our system. i tried to go to item maintenance and just delete it while everyone was out of the system and it wouldnt let me. Pop up window came…