Sage 100

Do you have to be a certified sage developer to access the API? The care support informed that you do. myaarpmedicare

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

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…

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…

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

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…

Hello, We are trying to run some basic metrics surrounding Back Ordered Sales Orders, i.e. "How many Sales Orders had back ordered items last month". Problem is, I can't seem to find any data fields in the SO_SalesOrderHistoryHeader table that would…

So we are trying to determine if we can turn off the auto complete for specific modules. For example one that definitely needs to be turned off is SO Invoice Data Entry. Currently we have it turned off at the company level, but I can't find any info on…

I am looking to renumber an Inventory Item code using Visual Integrator. The items have not been used and therefore have no history. Has any used the IM_DeleteChangeItems table to create a VI job? StartingItemCode;EndingItemCode;NewItemCode? Thanks…

I have a request from our buyers to have the BOM "Where Used" values for items in CI_Items appear on their corresponding I/M Item Inquiry screens. We have BOMs configured in Bill of Materials for items we are going to assemble as kits. All of the component…

A button script has been working for 8 years that writes 4 string UDF's and the TransactionDate started failing immediately after upgrading to 2020. After getting successful returns on all the SetValue statements, the Write fails (retVal = 0). The IM…

Does Sage 100 (v. 2019) provide a method for specifying minimum order quantities by vendor for inventory items? We know how to set minimum order quantities for an item at the warehouse level using "Reorder Maintenance," but we have not found a facility…

Hi all, Does anyone have any suggestions on how to incorporate user-defined functions and additional sub routines in UDS? I have a working (pseudo-codes below), intended to be assigned to Table_Post-Write event for AR_Customer_bus. Basically, there…

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…

What is the best way to add the customer Ship To phone number to a shipping label? I have tried to create a UDF and link with business objects but I don't know to link it back to the Ship to phone field. The available tables under business objects in…

Hello all, I have created a checkbox UDF in PO_PurchaseOrderHeader. However, sometimes my users check the box, then press "Accept" to save, only to find that it is not saved. They have to go back and do try to check it several times (sometimes up to…

I am trying to implement Production Management module and make some modifications to some of the tables but I can't find the PM (J/T) documentation on my help screens for Sage 100 ver2019. Has anyone seen any good documentation? Specifically, one of…

Currently, we have the option to search "Item Code" as "number" and "Item Name" as "description" in the search form on our website. Can someone please let me know what I would need to use to have the EBM search the "Long Description" field? Thank you…

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

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…