Sage 100

Has anyone come up with a way to search the entire Item Description including Extended Description, if available in Item Lookup? Typing the search criteria in the Item ID will search the entire description but it only displays 10 items at a time. We want…

I want to edit my shipping options in our Sales Order Entry however, I am unsure how to do this. Can someone assist? We are using Sage 100 Advanced 2021 and the current list is no longer valid and I would like to update it and make it easier across…

In purchase order entry, lines tab, there is a sales order number field. Although that field has a lookup button, it does not appear to be validated. Users seem to be able to type in anything they want that's not a valid sales order number. Is this a…

Have a need to lock the unit cost field in ROG, but unable to do so in custom office. Is there another way around this? Maybe a script? Looking for functionality just like this post: www5.v1ideas.com/.../40042

I would like to add the completed (X) to the order status drop down menu. We use purchase orders to order items such as Truck Chassis / tanks that we never recieve or sell in the system. In our prior system when the chassis or tank arrived we complete…

Just discovering the power of Custom Office (I'm a newb). I am running into a wall with one particular item. I have worked my way through creating user defined fields and tables and can successfully customize panels in screens and modules, but I'm stuck…

We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…

So we are trying to determine if we can turn off the auto complete for specific modules. For example one that definitely needs to be turned off is SO Invoice Data Entry. Currently we have it turned off at the company level, but I can't find any info on…

I have a request from our buyers to have the BOM "Where Used" values for items in CI_Items appear on their corresponding I/M Item Inquiry screens. We have BOMs configured in Bill of Materials for items we are going to assemble as kits. All of the component…

Hi all, Does anyone have any suggestions on how to incorporate user-defined functions and additional sub routines in UDS? I have a working (pseudo-codes below), intended to be assigned to Table_Post-Write event for AR_Customer_bus. Basically, there…

Hello all, I have created a checkbox UDF in PO_PurchaseOrderHeader. However, sometimes my users check the box, then press "Accept" to save, only to find that it is not saved. They have to go back and do try to check it several times (sometimes up to…

Re-posting here since I think I was in the wrong section before. Haven't had any luck finding an answer to this so hoping you all can help. Currently when you search using the "Description" option on a web search, it only searches Item Name (short…

We stock all kinds of hardware for some of our installation work like bolts, washers, and nuts. While our company standard is to utilize manufacturer specific part numbers, this doesn't make as much sense for truly generic hardware. I might order hardware…

Hi Forum, We need to delete BOMs with a BOI script. when i use nDelete() the return value is "1" and yet the BOM is still in Sage. I can find the BOM by doing a SetKey with BillNo+Rev. Any inout will be appreciated. Regards, Manuel …

When you enter a Quote you begin by changing the Order Type from Standard Order to Quote. Before you do this the Print Pick Sheets box is checked for the Std Order. After you choose Order Type Quote it disappears. Perfect but...when you convert the Quote…

Is it possible to display the cost of a BOM in the BOM entry screen(s)? My team members are having to complete the build & then run a report in order to see the cost of a BOM.

We are on SQL and light manufacturer. Need the ability to make to order. What have other companies utilized?

I am interested in communicating with other plastic injection molding companies that are using Sage 100.

Business Problem: One of our inventory peeps needs to analyze and see when the PO Required Date changes for an inbound PO. We have a pulling schedule etc... with some partially pulled and staged orders. Those orders are waiting on inventory from inbound…

In the past I have been able to drag a column onto the sales order entry screen on the Lines tab or change the order of the columns but now I am unable to do this. Any advice on what has changed or what I am missing?

We're using MAS 200 4.4 (still). In any of the newer versions, does MAS display a running total of the items ordered in the SO Item Entry Panel? If there isn't one, any tips on how to create this using Custom Office? We get frequent orders where a customer…

Have a customer wanting to expand the sales order number from the 7 to at least 10.Not sure if third party vendors have a solution and am looking now. Suggested a UDF to follow thru the system as work around.

Hi all, In Tab 6 of Item Maintenance (the Order tab), I am trying to Edit the data that shows when I click Sales Order, I want to be able to see Customer PO and Comment on the screen along with the other information that is already in there. I went…

Is there something like the nCopyPurchaseOrderLines (which receives lines on a PO in Receipt of Goods/Invoice) for Sales Order invoices? Thanks!

Can any one tell me if the Sage ERP Mass 200 Multiple bin module is ACS or SWK? We are looking at ScanCo for barcoding and they have asked us that question. Thanks, Chris