Sage 100

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…

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…

As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all! I am working with the Open Sales Order Report now and stuck on suppressing some items in the report. The end goal…

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…

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…

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. …

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…

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…

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…

Hello Team The info below does not print from the history or when I reprint an invoice, only prints when I am creating the invoice and print for the first time. any idea how to add this line and make them appear when I print them in history. (That…

I am modifying our picking sheet and want to save a "test" version. When I am in Crystal Reports and I go to "Save As", I create a new folder in the "SO_PICKINGSHEETPRINTING" Folder. It doesn't show up as a form code when we go to print a picking sheet…

I am trying to make an excel sheet (ideally a custom report), which shows the amount we invoiced every day, and the amount that was promoted from quote to sales order every day. Grouped bar graphs is what I'm trying to achieve. I figure the easiest…

This might be a simple question, but I couldn't find a solution. I have an Excel Spreadsheet with a PostDate column whose value is: VLOOKUP(E2,upload!A:H,2,FALSE) and it shows as a Date. I'm using this spreadsheet as a data source, but my application…

A customer wants to get a report of new inventory to publish on a web site and wants to know if he can get an inventory list by dates created?

Hi, I am sure this is an easy question but I couldn't find the answer: At what point is the Qty Available calculation made in Item Maintenance? My company wants to to make a custom change to the calculation, so knowing when it recalculates would be…

When the Open Purchase Order Report is run, the report shows backorders on lines that have future dates. This occurs on multiple line PO's with deliveries over a period of time. The required quantity shows up as a backordered quantity even though it has…

We are trying to find an easier way to show what is on hand for a costed bill of material inquiry. The report obviously shows what the components are but we want to show the quanitityy of those components on hand. I tried checking all the reports that…

We have products that we purchase from multiple vendors. We have the Vendor codes and descriptions set up as Vendor Alias' in Item maintenance. When we make a PO for a vendor and enter an item that has multiple Alias codes, it will actually print out…