Sage 100

I have an end user that is considering DSD's Expanded Price Levels enhancement. I am a little nervous adding an enhancement that will have such a large impact on Sage 100. Just wondering if anyone has any experience with this enhancement. If so, are you…

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…

Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…

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…

Hello all, I am trying to find a way to solve an issue that I have with how the Quantity Available field is displayed in Item Inquiry. It's kind of a difficult issue to explain but I'll try my best here: Lets say I have 300pcs of an item On Hand.…

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…

The back order fill report included drop ship line items from sales orders. It would seem best to exclude drop ship as those lines will not be filled from the warehouse. Rich Garrett DSG, Inc.

I recently found the DROP SHIP PO and it is applicable in our business. However, we still recieve all PO's into our "inventory" which is then offset by a Sales Order. Once we invoice it then it is removed from inventory. We are unable to receive DROP…

Is there a way in Sage 100 to advise when an item is not available? EX: If I am putting in an order for 12 tennis nets and those nets have already been committed to other orders? I know you can pull up each item individually to see what’s on hand and…

We are in the process of an overhaul of our sales / production processes, switching from a made to order on production items, to an inventory management view. Previously, our sales order and job hard files were one in the same, we will now be splitting…

Through a series of processing error the cost related to a particular item is overstated. I cannot correct through a regular so transaction entry because the quantity is where I want it; the cost is now corrected. Since all transactional pricing uses…