Browse By Tags

I am trying to find a way to return the description of a UDF using SQL. I am currently using the following: Select * FROM JT_Employee But I need to bring forward the descriptions of the UDF's. So for example, "UDF_F_Name" would return "Employee…

Hi, Reference used: - Where to locate the locales for languages - https://online-help.sagex3.com/erp/12/howtoguides/en-US/legislations/Add%20a%20non%20standard%20language/Content/How-to%20guides/Legislation/Add%20a%20non-standard%20language/T1%20Add…

I'm trying to display the order number from either the SINVOICED or SINVOICEV table in the "Open Items" left panel for A/P-A/R accounting payments. I have it all setup, but the value is always <empty>. I know there is data that could be displayed, it…

When I customize an invoice and then try to save it. Sage tells me that I need permision. if I save to an existing form it tells me that the file is read only. I am the system administrator, so I don't know how to get any higher permission than that.

We have a job (T&M) with one of our clients where they are requiring us to submit copies of all material invoices when we bill. Is there a way in AP 4.2 to have a notice pop up when we input AP for a specific job? We have the ability to have alerts pop…

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…

I enter sales invoices as sales orders initially. Some of the orders have multiple projects. But there is no column to allocate individual lines to a project. Only the entire transaction can be added to a project. Does anyone know if there is a setting…

Hello, I am very new to development with Sage 300 and using the SDK -- in fact I have not started yet, but before I get started I would like to ask a question. First off, I need to clarify that I'm talking about a version of Sage 300 installed on a server…

I have 2 companies run under the same parent company. Is there a way to have a designated invoice for each company with a different logo in the same instance of SAGE 50?

I need to create a button on the screens, but in Sage X3, I only found small icons. Is there a way to create it?

AP Check printing with missing alpha text. Noticed after upgrades to 2023PU1 and 2024PU1.

Right now I use the entitlements tab in the paycheque journal to track sick days, flex days, vacation days (in addition to the vacation tab) etc. These are not actual defined entitlements in the contracts of the employees. I am just using this tab to…

Hello, I set up a new form for A/P Checks, and I have everything printing where it should, except that the check number is not printing at all. Thanks in advance for any assistance, Michael

Hi, I created a report based on Opportunity entity, and then make it available for Interactive Dashboard. The column with numerical value is aligned to right on the report. This same report is available for a dashboard gadget, however, the numerical…

Hi all, I am creating a workflow. in my workflow, I want to have a condition before proceed to the next action. Based on this condition, I will show/hide the next action. for example: if Lead company is match (Lead_CompanyMatch='Y'), show action…

I'm using the line of code below, but I'm getting an error stating: "The Description is greater than 30 character(s)." No doubt this is because the step description is stored in the JT_WorkTicketText table (much like the CI_ExtendedDescription table)…

Hi everyone, 1. Who do you order cheques from? 2. The existing cheques I've been using don't match up to the cheque template in Sage Accounting (cloud). I used these cheques when I used Simply Accounting before the transition to Sage Business Accounting…

We have (3) locations with one having a different logo that will slowly be phased out. What is the best way of organizing the service module based on region? More immediatly, how can I print a different purchase order template for some work orders?

Hi, I have followed the information in this post: Building a List with an Editable CheckBox using the .NET API (in Sage CRM v7.1 SP2 and earlier) - Sage CRM Hints, Tips and Tricks - Sage CRM - Community Hub and have downloaded the latest SDK that has…

I setup an Import Template for Function profile because I needed to do a mass update of site-grouping without losing the options. I exported a functional profile, made changes including to replace the x3 code of the profile to the new code and the import…

I'm sure I've used the usrdf1/usrdf2 in places and changed it to be a number value, but i have noticed lately that when i change it to number it is only accepting and integer and not a decimal. I know i can make custom fields but i avoid them as they…

Hello, I'm creating a UDF field to duplicate a stock field so I can add the udf to the Open Sales Order Report Selection filter area do I need a script to make the ud field equal the stock field. I believe I read a post here that I did if so does anyone…

Hello, I have transferred Sage 100 from my old computer to a new computer and moved my customized forms for printed checks. In doing this step, I had to upgrade Sage from 23.3.23.0 to 25.3.98.0 I tried to pay a vendor using check. However, the spacing…

I set up a data model based on a view in Sage. Then I created a worksheet view and everything works well including the ability to filter based on columns within the data model. I noticed that when I went to set up a distribution job, I didn't have the…

Is there a way to import new UDFs into Sage and to place multiple fields on a panel at one time? I have 50 UDFs that need to be created and I would prefer not to have to manually create and place each one of these fields. Is it possible to mass create…