Sage 100

I'm just trying to print, or at least view, a list of all of our UDF's from the UDF and Table Maintenance. I'm getting the dreaded error #65: Window element does not exist or already exists:CM_UDFMaintenanceListing_rpt. Tried renaming the existing file…

Hey All, I am having an issue with our Work Ticket in Crystal Report. For reference, I have Sage 100 2019 Manufacturing. The Manufacturing Module houses all of the JT tables pertaining to the creation of Work Tickets. The Crystal Report for our Work…

1) For inventory, I'm trying to get the sum total of all inventory in warehouses where warehouse number in (100,200,300). Additionally, my formula for getting the inventory is: IM_ItemWarehouse.QuantityOnHand -IM_ItemWarehouse.QuantityOnPurchaseOrder…

How do I get the RefId to generate the Link under cases? Can I get the Java language to Create this link? It used to be there and it is gone.

When issuing receipt of invoce and added comments, I'm not able to see comments when printing DTR. It only shows PO Receipt entry. Is there a way to show comments added when issuing receipt of invoice.?

I'm trying to create a view in search in Item Maintenance that would have the system display the total quantity available by, in a new field, subtracting from IM_ItemWarehouse.QuantityOnHand, IM_ItemWarehouse.QuantityOnSalesOrder and IM_ItemWarehouse…

For most tables, when I create a user defined field (UDF), the history table automatically gets the same field added and the data gets copied into the history table automatically. It looks like AR_InvoiceHistoryDetail may be getting records from both…

We are trying to add a UDF to Cust Maint. The purpose is to select another customer in the Cust Maint tabble to be used as a referral. Eg; If a new customer is created "ABC" and an existing customer referred the new customer, we want to use the…

Hello, In Sage 100, I've added a UDT with a list of items, and a UDF onto Sales Order Header which enables user to select an item from the UDT. After selection, I also want to pop up other fields (also UDF) based on the selected item. Basically, pop…

I've got a UDT that isn't displaying in the list under user-defined field and table maintenance. It used to display but has since disappeared. I wonder if anyone knows some tricks to refresh the menu system? The table I'm looking for is called SY So…

Hello, Our accounting team inquired about the possibility of making the "Comment" field on Sales Orders editable even after they are put into the history table.I do not believe this is possible, but was hoping that it IS possible to add a NEW "Comments…

I'm trying to pass a field from PO Receipt Details to the PO_ReceiptOfGoodsInvoiceWrk table which is used to generate the Receipt of Goods Register. We have added a field in PO Details which is passed to Receipt Details which I want to pass to this Work…

Hi everyone I'm trying to write a script that will mimic the quick pick sheet printing (ask if to save the changes & bring up the pick sheet dialog for the order selected). I'm using a new button for that on the sales order. The reason being, I need…

I am trying to get orders from our website to save the CC when they come into Sage. We currently run Sage 100 5.3.2. There is a checkbox in SO Entry on tab 5 to save CC. I created an advanced field setting in custom office to set this value to Y. …

I know you can print a file layout from the File Layouts and Program Information window but that does not show any custom or UDF field. Is there a way to print the file layout with those fields too? We're preparing to upgrade from Sage 100 v.4.4 and have…

Working on an upgrade for a client from 2015 to 2016. The validate address button seems to be missing in 2016 on the address tab of sales order entry and invoice entry. If you click into the ship to maintenance it is present there. It is also present…

Does anyone know of a function that can be used in VI to evaluate a temp field as to whether it is numeric or not. I need to do conditional value assignment based on whether a temp field is numeric or not. I realize I can do this by adding the field in…

Can someone outline the process to go into AP and change the characters to 50? Appreciate it.

Can someone describe the process that needs to be done for this? Thank you,

MAS 4.5 When adding a new item through the sales order screen, received this error: Error in screen definition Screen item PMAIN Error #2 Invalid Mnemonic or position Name: SuggestedRetailPrice I'm guessing this means the field uggestedRetailPrice isn…

We have a new crystal report that references the largest tables in the database, the sales order header and detail tables, and we had to a UDF field to one of these large tables. The crystal report references this UDF field to make a calculation, and…

we are on MAS100 5.1 using crystal reports 2011 for Sage. I have created a UDF field in Sales Order Detail called UDF_Customer_Item_No , i made this 15 char long as a String, control type multi line. we are using visual integrator to import orders…

Hi all, I'm trying to import into the IM_Physical table for physical count entry but there is no field in the data tab for quantity on hand, only quantity counted. This means that the only way to update the quantity on hand is to freeze the correct…

I need some input and assistance. I have a client on SAGE 100 V 2014 PU3. We added 3 UDF's to the Purchase Order Detail (Line Item) screen and everything was fine for a few days and then we got an error about the grid. After contacting SAGE Tech Support…