Browse By Tags

Hi all, I wanted to add a bespoke columns from completely different tables to this Stock list. I think the fastest way to do it is to have a custom stock list. However, my customer also need the same right click function that able to have options as…

I am trying to pay my GST/PST on my online banking in Quebec, but I don't know what numbers to punch in from my tax report from Simply software, I need to know what numbers to put for number 105, 108, 111, 113, 205, 208, 211, 213 Can anyone help me…

Hi all,. I wanted to change the action name that is displayed on the screen from "Document Reviewed" to "Document Review". I have try changing it in the workflow rule, did not success. I have try updating it, assuming that the value comes from…

I have recently created a number of new Sage files and input trial balances for the companies. Two of these company files do not have quite the right name on them and it will get them mixed up with other companies. Is there a way to change the name on…

Hello, An employee gets 15 days' vacation per year. It does not accrue and is not paid out every pay period. He is on salary. Is there a way to show how much is owed for the year and how much has been paid out to date?

I am trying to update the Alias Item for new items created for a POS system. I need to create an Alias Item for each new item created and the Alias Item needs to be = UDF_UPC, it also needs to be a "General" type with the Alias Item Description ="SKU…

Hi there, We'd like to add administrative screens such as Users and Batch Server as links in a process map, but directly copying the link or using a relative link such as /sdata/syracuse/collaboration/syracuse/batchServers?representation=batchServer…

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…