Browse By Tags

What is everyone using to manage who is currently using a license for a Module? We have 4 licenses for JC but have to ask 10 plus people who is in it and can they get out (we use a Teams Chat for this). Sometimes someone had it stuck open or left it open…

Is there a way to generate a master list or report to see if clients have been inactive for 3 years or more if they are not marked as inactive already? Not just individual clients, but a list for all clients in your database.

Hi Everyone, I do not see the memo button on my customer maintenance screen. Where can I add the function for all of my users who will need to be able to see and change the memo when needed under the customer maintenance. I tried going into the AR Memo…

Hi i am trying to populate some values on the 'new free text item' screen onchange of selecting a product, i have the following code in the custom content: function setValues() { var prodId = crm.fields("quit_productid").val(); var successProduct…

Hello Does anyone work with Bank of America and develop a Mapping between Sage and their interface? we are starting this process and help and advice will be welcomed. Thanks Patrick

Is there a developer environment available allowing for testing/validation of changes that allows us to push the changes out to production environment at a scheduled time? Ultimately looking for ways to avoid impacting production when modifying.

I created a task in the Sage 100 task scheduler to update PO batches. If I hit 'Run Now' button in the Task Scheduler module, it all works perfectly. However, I can't get it to execute at a certain time each day. Windows task history shows it's executing…

Hello... I created and updated a second BIN location field I wanted to add to the REORDER Maintenance screen. However during customizing screen when I display all fields and UDF's it doesn't show??

I recently inherited a client who is using many macros in their environment. Some of these macros are used in place of the standard Order Entry and Shipment forms. Everything works fine in their current environment which is Sage 300 2021. Recently I installed…

Hello, I know i can design a balance sheet but i want to know how i can choose various accounts but not as a range, just choose in between them.

I am reading that in order to add a lot number of what shipped/invoiced to my query I need to add the STOJOU table in the graphical query tool. I cannot figure out how to link the STOJOU table to anything. I am VERY new to altering queries.

Hello. I'm trying to post invoice payments. We pay via EFT but the system won't let add it. If I choose direct deposit, then it is asking me to enter a supplier's bank account (which I don't have). I can't use cheque, since it looks like it will throw…

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