Sage 100

Hello Sage Community, Todays question is how to find order(s) in shipping that I cant find! In the image below, I have the part in Shipping and cannot find it!! I've reviewed numerous orders and shipping batches that are not updated yet, they are nowhere…

Hello all again, I've been getting some very good advice here lately, thank you all! I create a custom report in the "Item List" that includes "Total Quantity On Hand". The issues I have is when the report shows a negative qty, however the Item Detail…

Hello, I am running into an issue when importing vendors. We are mass importing items along with the vendors, but are running into a block on the vendor import. It appears that this popup might be blocking the vendors from being imported. Is there…

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.

Hi guys, Would you please lend me your hand in finding the table that stores beginning qty (and also value) for inventory? Basically, i'm trying to replicate the "5.History" tab in Inventory Inquiry. I've looked into IM_PeriodPostingHistory, IM_ItemWhseHistoryByPeriod…

Is there a utility that will allow me to check the "Allow Trade Discount" box for a range of inventory items?

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…

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

My company manufactures products that we categorize by Lot #. As an example, I have an item with Lot # ABCD that we delivered into Sage 4,143 bottles. Of that Lot #, I can confirm that 3,628 have been invoiced and sold, leaving 515 left, which is exactly…

I am writing an html email alert for Sage Alerts and Workflow v9.0 for Sage 100 and I have a table in the email alert and I want the table to be shaded for every other row. I'm using the nth-child(even) method and I can't get it to work. If someone has…

Hi! We have recently created a second warehouse in our system and are trying to find the most efficient/effective way to transfer the inventory in the system as well as physically. I know there is a transfer option in inventory management, but we are…

I have one inventory item that the On Hand Qty showing in Item Maintenance is different than the TotalQuantityOnHand when I query it from CI_Item. How does that happen?

We are considering purchasing this module to use for a new manufacturing division that is schedule to open soon. I was hoping to get some advice on how the installation went well or poorly for your organization and whether you would recommend the purchase…

Was closing out the year and the last process is Inventory Management. Mas200. Received an error IMWPAA...then it showed up again this past month closing out. Anyone know what this is ? I know it's an ancient version... Thanks!

We are a custom manufacturer that provides our customers what we refer to is "Make and Hold" inventory. Because some of our clients don't have the ability to stock the inventory we produce we offer a service that we will stock and keep track of their…

Okay maybe you guys can help me out. Right now we have sales people generate the Pick tickets and the pickers come running across the warehouse to grab a stack of pick tickets, then run back and fill the orders. I want to: Not have to print pick…

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…

Are there any fields in inventory management to enter a product's case dimensions, legnth, width, height? also block and tier for pallets? Or is the only way to create UDF's for these? Thanks

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…

I'm using MAS 200 for my regular inventory. I want to be able to inventory my consumables...shipping supplies, shop supplies, etc. Any suggestions as to how this can be done?

I'm using MAS 200. I'm looking for a simple way to check inventory movement, ie how many of a certain inventory item have we sold and/or issued in a period of time. I know that I can run inventory sales history reports and inventory issue history reports…

I'm using MAS 200. When in inventory maintenance (or inquiry), there is a column under the Cost Detal section called "Other Committed". Can anyone tell me what this field represents?

Is there a way to run an Aged Inventory report?