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…

We are looking at starting to use Master PO's and as I went into CM and added the 3 Master Order fields (Master Original Quantity, Master Quantity Balance, Master Quantity Ordered To Date), I created a Master PO and it's not showing up on the Orders tab…

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…

On Sage 100 with Operations Mgmt. (Job Ops) - I would like to look into the use of the field Sales Order number to see how users are using this field. Currently I use this field for misc. items only and for custom reports and I am trying to locate information…

Has anyone ever created an inventory transfer form that can be generated out of MAS that a shipping department can complete. I am looking for a picking sheet type of form but the item is simply being transferred from one warehouse to another (therefore…

I am uploading several work ticket templates at one time using visual integrator. I can find the tables/variables where all the field data exists, but am not able to find the extended text. Can you please help and advise the table name where the extended…

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…

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…

Hello, using PO Receipt labels and have a need to set the number of labels needed per line on the PO. For one PO with 5 line items, one line may need 5 label and the other may need 1, etc. This is independent of qty rec'd and t he setting in Inv Maint…

I have a crystal report I wrote that pulls field 33 ShipWeight from AR_InvoiceHistoryHeader. On 9/5/23, my business partner went in and added UPS as a shipping method. He claims he did not touch anything that would affect this field but cannot remember…

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 am wondering if has made any IRP custom reporting for the Sage 100cloud Premium 2023 PU 1 that can address my customer need. Here is the detail request from my client; They want to be able to run a report that looks like the legacy MRP action by vendor…

Customer has been running the "JT" version of Production Management for a couple years, and makes use of UDF's in JT tables. Upgrading them to v2023, and the "PM" version of Production Management, the converted data is missing all the UDF's and the…

I have created a custom Work Ticket report setting with a subreport. The subreport uses the JT_WorkTicketAttachments file. The main report links to the sub report by SalesOrderNo and WTNumber. I have placed an image placeholder on the sub report detail…

Is there an automated way to generate the component shortage data provided by the Component Requirement Report using BOM item numbers and quantities from Sales Order lines as input? We have one product line with standing sales orders to which we add/modify…

I've been asked to compare the cost on Sales Order lines marked for Drop Ship with the corresponding lines on the Purchase Order. The Purchase Order number is referenced, but I don't see how Sage is associating the individual lines of the PO and SO. …

My company has decided to stop assigning item codes to incoming raw materials and instead use generic codes ie: /LAMINATE, /HARDWARE etc. The reason for this change is to be able to issue the receipts directly to a job upon the item being received. This…

Just wanted to run this by for thought. Customer wants to print a form, say an invoice, and have it automatically increment a Reference # field. This reference # is the date plus an A, B, C, etc. It would go on each invoice printed and increment each…

I have added UDF's to the JT_Transaction Entry Dist table and added it to the Serial Distribution Panel in Work Ticket Completion. That works fine. However, I can't see how to map the UDFs to Lot/Serial Transaction History. Does anyone know the table…

We have a ton of components that are set to INACTIVE, that still show up on the WHERE-USED Inquiry lookup and the WHERE-USED Report. How can we get them to not show up? We tested an item and set it to Discontinued and set it to Inactive but it still shows…

I am trying to add the extended item description to the inventory labels. I am at a loss. I've added the CI_ExtendedDescription in the Database Expert and added the field to the report - but when I try to print the labels, they are blank. I'm not that…

Ever since we update to Sage 2021, the suppression in on our forms doesn't work correctly. It will leave large blank areas for al the supressed values. Supress blank sections is already selected in the group and details. It was working perfectly before…

I would like to know if it is possible to only create Po's from a sales order for items we don't have in inventory? If I create a sales order that has lets say three items two that I can pull from our inventory and one that I don't have any in stock…

When printing a Purchase Order with multiple pages, it will print the order total (which is in page footer b) for the last 2 pages. It usually only happens when there is 1 line item or part of a line item on the second page. Right now under Suppress…

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…