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…
Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…
Hi everyone, I came across these excellent and useful to improve navigation on X3 V12.
A. Right Panel Actions
ESC + N – new
ESC + B - save
ESC + C - create
ESC + D - delete
ESC + E - cancel
ESC + ALT + U - refresh
ESC + ALT + P - print…
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…
I have query in the Graphical Query Tool that I'd like to see the actual query executed. How do I see the query in SQL syntax? I want to see the tables and how / what they are joined. Is there a way of doing that?
Hi,
I would like to create more representations using Views/Tables. Requestors are very quick to create in X3V12 using Views/Tables, but very limited functionality specially on Landing Pages. The goal is to give user far more interactive dashboards…
I have a custom field in the STOALL table that I would like to transfer to the STOJOU table when the transaction is validated/posted. I've been looking for an entry point to do this, but I can't seem to find it. Does anybody know if there is an entry…
On X3 V12, I want to add a button or menu item that opens an attachment on an object without opening the attachments popup window. I know all of the parameters of the attachment and want to know what the code is for viewing the attachment. I see GOBJTXT…
Hello All,
Please am having issue with PAYMENTH description Table not flowing to GACCENTRYD description table.
I did a transaction on payment screen which was ok and generated a journal number, so i tried designing a report (Supplier statement) which…
How can the three buttons in the top button row V12 UI be customized. For example, in the Sales Order screen, buttons available on top (out of the box) are Allocation, Preparation and Delivery. We don't do any of that and would like those to be Invoice…
Hi,
I`ve created some fields on the table BPARTNER, after that, I`ve cloned the BPR2 screen and renamed to BPR3 with the new fields:
-----------------------------------------------------------------------------------------
After add all fields and…
Hi,
I would like to know if there is a way to increase the number of buttons showing on the screen header. As example:
On Suppliers, I added 2 new buttons, Test 1 and Test 2, but on the header there are only 3 buttons
----------------------…
When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL.
When I execute the query in SQL, it returns the correct results. For example:
When testing the same…
Hello all,
I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join:
((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…