Sage 100

Is there a way to change an old REV of a BOM to history in order for the inactive REVs to not show on every inquiry? We have been using Sage for a long time and some of our BOMs are no longer active as we no longer build those items. We need to keep the…

I'm new to Sage, using 100 Advanced. For SQL, why doesn't this script work: SELECT * FROM (SELECT ItemCode, QuantityOnHand WHERE Warehouse="100" FROM ItemWarehouse) AS STUFF Please disregard spelling errors (if any). I've used this style of…

Do you have to be a certified sage developer to access the API? The care support informed that you do. myaarpmedicare

Hi, Is there a cross reference list of what the WO tables/fields are now called/located in PM. I'm looking to make a new query for PM to replace what I had in WO coming from the WO9 table or WOO depending on Active or History. Thanks, Ryan

I have multiple queries that run in sequence to give me certain fields in the PO module. The main filter is the date created time stamp field. I have the query filtering to show only PO's created since the last time I ran the query. This is done through…

Hello, We are trying to run some basic metrics surrounding Back Ordered Sales Orders, i.e. "How many Sales Orders had back ordered items last month". Problem is, I can't seem to find any data fields in the SO_SalesOrderHistoryHeader table that would…

Hi Everyone, I am wondering if there is a way that I can have excel look up a part number when entered in sage and pull the standard price from the Item Inquiry under the Bill of Materials menu automatically. So my excel sheet is for scrapped items…

Good Afternoon, I am creating a part number in Sage 100 and it is a finished good that's procurement type is a make. From what I have been taught, if it is this kind of finished good, I fill in the Retail price and the Standard price but do not touch…

We are a company that sells plumbing tees, elbows, valves, etc. When customers are finished with a project, they just bring back a large box with a mixture of parts. The warehouse writes up the part numbers and quantities. These parts could have been…

Hello, I'm trying to create a new report and I see that one of the work table has most of the fields that I wanted on my report, So is it possible to use existing work table with many other tables and create a joints in crystal report. If so how do…

On every module or input field where Auto Complete feature should work, if the item is relatively new, the Auto Complete does not function. I am unsure when, if ever, Auto Complete will work on these items. Is there any way to force Sage to recognize…

v2018.2 (Standard). VI job to create WO from csv (set up by someone else, prior to upgrading to v2018). The current problem we are dealing with is that the Req for WO value in IM_ItemWarehouse is not being populated properly (for component items) and…

Hi All, have a customer that carries repair parts that may be old but still could be sold, but they will never be re-ordered. What they would like is for these items to have them automatically set to inactive once the on-hand reaches zero. I could not…

Is there a way to set the default warehouse in item inquiry for example on the transactions page to be ALL instead of 000? Sage 100 2015?

In MAS 200 v4.5 I am trying to find the date that an item was last sold or issued. I can tell the last period an item was sold or issued in IM_ItemWhseHistoryByPeriod, but I was looking for something more specific.

We want to create a general alias for some of our raw material inventory items. I would like to create a custom lookup in inventory inquiry that will sort by the general alias number, how do I set that up? I can't seem to find the field for that when…

We'd like the ability to track changes in sales orders such as when it changes from Quote > Order, line item additions/deletions and quantity changes, status changes (on/off hold), etc. I looked into Business Alerts and Sage Alerts but don't know if these…