Sage X3

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

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.

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…

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?

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 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…

Hi Sage X3 Folks! Can the 'Tax' be inputted/edited in the Customer BP invoice? I am not sure about this process. I already changed the input to enter, but still no luck. Any of you know this process?

Hi I try to use zonsui to move cursor in a grid. In After modif subprog field, I added zonsui = "NAMEFIELD", about another field from grid. This optioon no works. I try too zonsui = "NAMEFIELD("+num$(nolign-1)+")" , but no works too. Version…

Can anyone briefly explain what the procedure is in SEI? It would be much better if an example could be added. Thanks in advance!

Hello, One of our user groups randomly started experiencing this warning upon logging in. Does anyone know a fix? Thank you, Zoey

Hey All, My company has purchased a wave picking function in Datalinx. During our first brainstorming session we've brought up Zones(zoning our warehouse). We believe we need to set zones as we go down this road. Problem is where to start? My question…

Good morning I am trying to link ITMBPS to ITMMASTER in the object ITM. However there doesn't seem to be any link that works with any of the indexes. I tried this [F:ITM]ITMREF;"", and of course it did not work. Does anyone have any ideas?

hello how to "grizo" a screen before using the creation that means after creation the screens will never have "grizo" and Thank you very much

Hi, I would like to update 100 function profile's functional authorization. I developed an import template (based on AFP and GESAFP; I did something on AFP object to allow import) but I got this error for special supervisor functions like: AIMP or…

is it possible to hide ' Column Group Heading' form worksheet?

We have a line at the bottom of our invoice about our terms that needs to be updated on our invoices that are printed and sent to customers. We are using Sage X3 and cannot figure out where to go to update that template.

Hello, I am trying to write a query that will show all of the access a given user has and what level of access. I am trying to determine where the option codes are defined but have not been able to do so. Any help in figuring this out would be much…

Hi, I want to create new Purchase Order Print code.

Trying to create a query based on items that are out on loan to customers. My query includes an Expression calculation based on what has been delivered to a customer minus what has been returned. So using two tables QTY on SORDERQ-RETURND, therefore…

Is there a way to utilize grouping in Excel inside of an sei add in report? For example, sales by customer and product, group by customer with the option to expand to see the products?

Hi team, I am running function CONSCPT (Account inquiry) but am getting fewer results compared to date range I have set e.g. am inquiring data between 01st Jan 2023 - 31st Dec 2023 but only 50 results are displayed of Jan - Feb and output capacity is…

Hello, I would like to be able to rename a file in [TMP]. I know I can do it with renameFile(PATH,PATH1) Except the file name is random, let's say : IMPORTME2024 and I want to rename it IMPORTME I tried a lot of stuff like this for exemple but it…

Hello, Please i'm traying to add field to receipt line document with designation 3 information product. Can someone help me please?!

Hi All, I have been using table fields to upload and connect it to its respective screens while working on an import template. But in address tab it uses "Screen fields" Does anyone understand the purpose or difference between the following fields…