• Purchase order lines detail - Sales Order NO. Field

    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…
  • Inventory transfer form out of MAS

    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…
  • Upload Work Ticket Template with Visual Integrator

    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…
  • Moving a BOM to History

    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…
  • Sales order number validation in PO Line Entry

    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…
  • PO Receipt Labels Custom # of labels to print

    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…
  • ShipWeight not recorded anymore

    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…
  • Lock unit cost in ROG

    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
  • Grouping Warehouses in IRP similar to the legacy MRP module...

    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…
  • JT to PM, all UDF data in JT tables is lost?

    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…
  • We have Sage 100c version 2022 with Operations Management and would like to Print the Work Ticket with Attachments

    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…
  • Way to automate BOM Component Requirement Report with Sales Order line data?

    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…
  • Comparing Cost on Sales Order Drop Shipped line to the corresponding PO line

    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. …
  • Item Codes

    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…
  • Creating a Custom Field that increments

    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…
  • How to map UDFs from the JT_Transaction Entry DIST through to Lot/Serial Transaction History

    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…
  • INACTIVE ITEMS

    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…
  • Invetory Labels - Extended Description

    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…
  • Supressed Entries leave large blank spaces on Picking Sheets after Sage 2021 update

    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…
  • generating a PO from a sales order

    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…
  • Order Total Showing up on Last 2 Pages of Purchase Order Form

    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…
  • SQL - Nested Queries?

    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…
  • Sage 100 packing list

    Good morning, I am working in Sage 100 Sales Order module under packing list! I am wondering if there is a way that when I create the packing list it doesn't invoice! Sometimes when I create a packing list the part doesn't ship. I don't need it to…
  • Printing a Packing List for Drop Shipped Items

    We have two companies - one is a manufacturing company and the other is a company that sells the products that the manufacturing company makes. The manufacturing company only has one customer - our sales company. We are currently creating PO's to tell…
  • Purchase Order, order status drop down menu

    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…