Sage 100

For anyone familiar with setting up AR invoice printing form codes, do you know how the crystal report determines the maximum number of digits a field can be? We have one where it's saying a field has a maximum character limit of 15, but it's set higher…

Hi, I experiencing errors in customer maintenance on a custom tab. I'm using the debug window and found 1k+ lines on several clicks. Error:0 Error:11 Error:12 Error:13 Error:14 Error:2 Error:20 Error:23 Error:26 Error:27 Error:36 Error:65 Error…

Have a situation where the frame/theme colors change for users everyday. They are connecting to Sage 100 using Workspace and it's not a dedicated VDI solution. The company and users do not have any theme settings setup. Could the changing colors be coming…

Is there a way to disable the information or other clickable links in Sage100? I have a client that does not have web browsers installed on their terminal server and users are clicking on the links and getting errors. They would like to prevent clicks…

Has anyone ever experienced no companies showing in rebuild sorts? They are there for rebuild keys, etc but just not sorts. I tried replacing all the query files & dde & ddf and sy_exportlink but no luck. Tried creating a custom lookup to see if they…

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…

Some questions on the 2022 interface. Tasks/Modules: The tabs feature in 2014 is a better design...so how do I delete the default Taskview items? Are the default taskview items configurable based on the user type. There is no reason to display all…

Preface: We are only on Sage 2014 for a few more weeks:...so no comments about how old it is..(smile) A user created a custom filter for the Customer Maint table which included a value which is not in the UDT (user defined table) lookup When the user…

I have a .vbs script to rename a file that I would like to run on completion of a VI job. The script runs fine outside of Sage. Following the other threads here, I finally figured out my perform command (..\VI\BM_Perform.vbs), but I get an error when…

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.

I just converted a client to v2021. I used the Desktop Customization Import utility to bring over their tasks, which creates folders in Favorites along with the tasks in each folder. They are unable to add tasks to those folders. Even if I create a new…

The Copy From button is shown on my Sales Order Entry window but not shown on my coworker's. We have the same permission. Would some one please advise me how to make the button shown? Thanks!

We have Sage 100 2016 running on a small network. The server and all the workstations except one show the Business Insights toolbar and side panel when logged into Sage. The one workstation with a problem stopped showing it a few days ago. I tried reinstalling…

Hope a community member can help here. I have a few machines that are running the ARM version of windows 11. The sage pdf converter for paperless office does not include a arm version of the driver. I have reached out to both sage and amyuni (the…

In general, Customizer allows copying and entire set of panels from one user/company to another. When I try to copy and individual panel I get this message, "Unable to create the following new library, possibly because it already exists." However, I do…

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

Sage 100 2014 I have a user who created a custom view in the Sales Order Entry Search Today the View is missing. Are views an object that can be copied from a Sage backup? Are view specific to a single user? Are created views available under…

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…

I'm interested in developing or using some method so I can quickly generate a .csv, or some type of document openable in Microsoft Excel, which will show only a list of product names, (selected based on their inventory cycle), and next to them, their…

Hi Everyone. We have decided to setup Cancel and Reason Codes for all Sales orders and Quotes. On Sales Order Options I have changed "Retain Deleted Orders/Quotes" to Prompt. Now when I go to delete and Order/Quote I get a prompt asking do I want…

Afternoon, For Sales Order: Curious if we have any control over the SO Order Type. Specifically we want to remove Master Order & Repeating Order as an option. For Sales Order Invoice: Same for Sales Order Invoice Data Entry. We would like…

I would like to read through the lines of an invoice in ascending ItemCode order during a SO_InvoiceHeader Pre-Write script, but they seem to be unaffected by a SetBrowseFilter and appear in entry order. Any ideas? Here's my 5 line test case: sItemCode…

Please ignore.