Sage 100

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…

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…

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…

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…

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…

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

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…

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…

I’ve added some UDF fields to the WOHeader table which users access from Work Order Entry screen.

I would like to add these same fields to the Work Order History Inquiry screen, but when I try to add a data field in History Inquiry, the option to…

Brief:   

• We have some UDF's on the line item used for scheduling orders. 
• When Orders go on Credit Hold, most user cannot edit the Line Item Detail.  In particular the UDF which they need to update.
• I can edit with the Admin role, but they cannot.
  
  Question…

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

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

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

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…

We are on Sage 2019 standard.   We are using work order, the original version.   I have added a UDF to the header tab. It is a 1 character multiline that can be Y or N.    When a user creates a new work order they enter data to the ML_UD2_TEXT field on the…

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…