Sage 100

I have a crystal report utilizing the shadow text feature to print our pick tickets along with a packing slip.  I am running into a road block on everything thing I've tried, we want to suppress some miscellaneous items on the packing slip, any charge…

I'm looking to create a UDF lookup to the AR_Customer on the Lines tab of GL General Journal Entry.  I haven't been able to use oUIObj.InvokeLookup with a button because it throws an error stating Object required: oUIObj.  Because it's on the detail…

I'm looking to create a UDF lookup to the AR_Customer on the Lines tab of GL General Journal Entry.  I haven't been able to use oUIObj.InvokeLookup with a button because it throws an error stating Object required: oUIObj.  Because it's on the detail…

Hello,

Has anyone found a way to link IM_Item Table to the JC Job Transaction Detail Report Work Table?

We are looking to get an item description included along with a part number on the report when we view for material pricing purpose.

I am sure that…

Hi All,

Just curious if anyone has ever created an SQL query to match up a Sales Order Line's selected bill options with any records in the BM_OptionInteractionHeader that would apply to that combination of selected options.  Trying to wrap my head…

We have a client that has a page footer that is around 3" wide. They oftentimes have invoices that are more than 1 page and don't like all the empty space at the bottom of the page on the pages before the last page. Has anyone else has this complaint…

Hello All,

The current bestsofware shipping tracking will not work for us since we need a custom hyperlink with the tracking to each of the shipping carriers. We have the tracking number in Electronic Delivery Message Document email message body. We would…

I added an UDF to the CI_Item, I can add it through custom office to the additional tab in item maintenance.  However, I can not see it in DFDM and when I go to check off the check box I get the error message "The column is not in the IOList.".…

We currently have a lot of items in sage, we make and sell the same item in different lengths, we want to start keeping track of the inventory on a detail level, keeping track of what length we have in stock. We cannot create different item code for different…

We have the option under sales order options to print the pick tickets by line number.  We also have the group header suppress check box checked off on the crystal report.  When one line has a different warehouse the pick ticket is out of order compared…

Hello,

I have been asked to add the Labor Code to the Payroll Earnings report selection grid under Employee Last Name and have this field filter the report.  I was able to add a UDF to the selection grid and the Earnings report work table.  However, I am…

Is there a way via scrip to hide a column in a DataGrid?   
I've seen similar questions posed but no answer directly to this.   

Example:  User enters a Sales Order line item.  Based on the Product Line of the Item, have certain columns show and hide others…

Hi,

I want to add a UDF in the JT_Employee table and within the UDF maintenance I see i should be able to use a UDT to limit the options being chosen.  When I select the UDT validation button, a few UTDs are available but not the one I want.  How do I get…

We have had several situations recently where recently where we are seeing that customized panels have the elements on the screen duplicated many times layered on top of each other. The number of duplications *MAY* correspond with the number of time that…

Does Work Order module allow UDT? I tried and it seems Work Order module is the only module which doesn't allow me to add UDT. Is it the case?

Thanks.

I got a script to timestamp when a udf is updated, now I am trying to create a view in the SQL DB to display on an excel sheet of what SalesOrders have been updated today.  Is there something specific with Sage on not being able to create a "view" through…

Is there a way to make the Categories in Item Maintenance a drop down instead of text entry? Thanks!  

Hey all,

I was wondering if there is a utility or report in Sage 100 that could list which users switch quotes to Sales Orders?

We are wanting to track who is taking quotes in the system and turning them into Sales Orders without prior authorization from…

Can you copy a customized panel from one user to multiple users (not all users in a company).. I have several users in company that have their own customized panels but I need to create a panel that all users need. So I dont want to include the already…

Hi guys, 

To interactively approve or cancel an entered value by a user, is there a way to make it work just in PreValidation event?  I'm working in SO_SalesOrderHeader

The basic logic flow is as follows

1. User enters a value in a ShipVia
2. Script checks…

I have a suppression formula on the details line in crystal however it is filtering out the items when the order type switches to backorder.  How can I include the backorder order type, is it as simple as removing the last statement in the formula?

formula…

I see where you can source data from the SO Detail to the PO Detail but not seeing anything for the other way around.  What would be the best method to get the data from a UDF on the PO Detail lines to the same named UDF on the SO Detail lines?

In Sage 100, I am attempting to select the earliest and latest dates from the completed date column on the work order scheduling tab.  I need to do this via an SQL table.  Currently, I am using the following calculation: [SELECT srvsch.findte FROM srvsch…

I'm trying hard to make this happen, but falling short.  I need to prevent a sales order from being shipped if a certain condition is met.  Ideally this would occur as soon as the sales order number is specified in shipping data entry (SalesOrderNo…