• Tracking Deleted Sales Order w/SKU detail

    We have numerous SKUs with a reorder point of 0 and most are treated as special order product. We often find that special ordered material arrives from the vendor only to find out the customer cancelled, the SO was deleted and no way to look back at transaction…
  • Inventory Valuation Report and Available Quantity

    Hello! i'm hoping you can help me with something that i'm sure is a very simple fix. We run small inventory counts usually to confirm and reconcile backorders or questions about shipments through the month. Usually, we run an inventory valuation report…
  • Lot/Serial Number being populated on Random FIFO Item Codes during Physical Count Entry in Inventory Management Module

    Has anyone seen this before? The Lot/Serial Column, which is normally blank for a FIFO Inventory Item Code, shows a random serial number, from a random Serialized Item Code (in our case this serial number that's showing up really is a serial number of…
  • SAGE 2020 Warehouse Negative Inventory

    Hello everyone, Does SAGE have an option to not allow inventory for warehouses to go negative regardless of the transaction type? We are running into issues with multiple warehouses. Thank you
  • How to revise G/L account?

    When I enter the purchase order, I s elect the standard order type as shown below. And the PO already has been issuing invoice and batch also has been run. So now the amount of PO shows as inventory G/L account. But it should be purchase G/L account…
  • Inventory Issues

    Hello, my company currently uses inventory management to track in house supplies. We are a medical facility, that has 70+ departments. We do not sell the inventory outside of the company, however as departments need supplies we do an "Inventory Issue…
  • Item Maintenance Tab Orders Count

    Hello, I am trying to come up with a counter for the number of orders (Standard or Backorders) that an item is on. So far I have tried a script that counts the line inside of SO_SalesOrderDetail but it won't write to the two UDFs made in CI_ITEM. Has…
  • Inventory by Program and BIN

    Hi, Is there a way to track inventory by both a "Job number" and by the Bin location? There is nothing that I have seen in Inventory that would allow the Job Number to be defined at the unit level, and nothing in Job Cost that allows for tracking…
  • 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…
  • Serialized item on hand but not available.

    I am trying to assign a serial number that shows it is on hand, but when I try to assign it to the sales order, it is not available? How do I correct this? Sage 100 v.2017 v 5.40.1.0 Any suggestions on how to correct this would be appreciated.
  • 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…
  • Multi-Bin videos and volume

    Want to do training using the DSD prepared videos that download with Sage 100cloud, however, the volume is not loud enough to hear. Have also tried the same videos on the DSD website and have the same problem. How can I get these videos so they are usable…
  • 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…
  • Purchase order and invoice price discrepancy

    How does one correct an item received at the wrong price and billed at a cheaper price? The item cannot be returned as it has been used from inventory. Example: Item 1234 received at 1.80 ea, but billed at 1.65 ea.
  • 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…
  • 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…