Hi all.
I would appreciate it if someone can help me with the following:
I need a custom ZLPNNUMBER field on the PKP2 screen to be populated from the STOCK table based on the line LOT and Sub-lot fields on a grid
To do so I added the following…
Hi all,
how to Limit access to Columns on custom Stock item list? I only need to show Code, Name, and Reserved Stock (custom column) for specific users.
I have try removing the fields from the extended view. But the columns still showing in the…
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…
Hi folks! I am working on landing pages and I am still not getting this right. Has anyone been able to customize pages?
I would like to make this visible in my Test Page
Hello!
I've added a field, ZMNSTA, to the CLE2 (Close & Reopen Purchase Orders) screen, in order to display a custom field from ITMMASTER for each product.
However, upon entering my code into SPECLE2, it seems that no actions are being called at all…
Hello folks
Is there any way I can call in folder A a method from a script in folder B?
Something like this?
I'm writing an entry point which must be written in X3 folder.
We have library scripts in not X3 folder. Instead of copying those library…
In code block below I am getting a 404 error when creating the request. I assume i need to provide the full path but can't find the documentation as to what that path is.
This began with the lastest patch level. It worked as is before this.
Anyone…
Hi all,
I have a custom module ID that I have create, build, and copied to sage300 installation folder. The module ID only consist of dll to create flat view. I am able to activate it on Sage 300 v70a. then I want to install it on test server with v69a…
Hi all,
I have this SQL query where I have a whereclause l.LineQuantity>six.TriggerQty
select c.CustomerAccountNumber, c.CustomerAccountName, h.DocumentNo,
si.Code as ItemCode, si.[Name] as ItemName,
pg.Code as ProductGroupCode,
six.TriggerQty…
Hi all,
I want to join StockItems and StockItemSupplier table using Sage.ObjectStore.Join below.
StockItems sis = new StockItems();
try
{
Sage.ObjectStore.Join join = new Sage.ObjectStore.Join();
join.RightTable = "StockItemSupplier";
join.RightTableAlias…
Hi All :)
Good day, what are the ways to confirm PO?
I know there are many processes, such as supplier confirmation and signing workflow, but I would like to customize it by having a field called 'Confirmed to'.
Hi there,
I have a need to display the total debit [M:HAE2]TOTDEB and total credit [M:HAE2]TOTCDT screen fields seen in the bottom left of this screen (GESGAS) in the Accounting Entries browser object (GAS) shown on the left. You can see where I've…
Hi all,
I am looping the POPStandardItemLine or an Order using foreach loop. The item lines in the order consists of standard order line and a charge line. While looping, I encounter an error.
this is because 1 item in the POPStandardItemLine is…
Hello,
I want to make some modifications to SPEITM, but I noticed that our Sage x3 provider has done some of their own in a custom file, YSPEITM which they've called at the action runtime in SPEITM:
Unfortunately, this script does not exist in the…
Hello
We have the problem that sometimes the print server not prints out a report. Even though we started the print for a document (e.x. purchase order) in 4GL with the following code:
For a custom development we are looking for an Entry Point which…
Hello everyone
When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched.
Is there any way to create SQL triggers so that they are protected? Like activity codes…
Hi Everyone! I try to edit Column Type Input and chose Enter but after saving error will goes like this
Does anyone know if I am doing this correctly? Thanks!
We have a scenario where we direct ship product from a supplier to a customer. Because of this and because we want to see accurate sales margins on the sales order, we have a need to change the cost of goods on our sales order entry screen so that it…
Hello! I'm Sage X3 developer and I having issues with Grid development. Does someone have a documentation about NBLIG, nolign, counters and grid screen? Thanks.
Hi all,
Lets say I have 3 companies of the same base currency, Company A, B, and C.
When I add new financial currency on Company A, I want to add to Company B and C as well. So I am using the code below, which I refer to this site https://my.sage…
Hello everyone
I built a generic screen "ZTRANSPORTCO" for a customer. The screen is used in multiple windows.
The problem is when I try to "Jump to" another window which also has a tab with the generic screen "ZTRANSPORTCO" I get the following…
I would like to take action in a screen based on which transaction code was use to enter the screen. Is there a variable available that will show which transaction was chosen when launching the function?
I created a custom screen where I am displaying images related to a driver. I am using a datatype of ABB, input of Display, and Graphic object of Photo.I have an issue on how to store those images. I know that it is stored in the CBLOB table. In the screen…
Hi all,
I am a developer making customized solution for my customer. Usually when I create forms, I will have to assign the roles to the forms, and after that I need to add the forms 1 by 1 to the Menu. If I have 20 new forms, then I will have to do…
Hi, how can I add custom view fields into standard (browser) object Left List ?
It's easy to add other tables but , what about views ?
Example:this is a standard object
I've added my custom view into Viste tab:
But in Selezione tab (Selection…