Hello everyone
In X3 documentation it is described that it is possible to use a table from Folder A in Folder B.
https://lvexpertisex3.com/x3help/ENG/V7DEV/4gl_file.html
I tried it like this:
Unfortunately it doesn't work with the period between…
I'm trying to add the total deposit on the left list on the Manual Remittance Screen. This value is a summation from the PAYMENTH table on the field AMTCUR and is present on the screen as "Company Total." I'm struggling with how to go about this because…
Good morning,
I'd like to filter a query for a landing page on my X3 v11. I see on X3 online help that you can add a "where" parameter to a menu item and add sdata conditions, but the help says:
Only simple conditions using "le", "ge", "eq", "lt"…
Hi togehter,
we successfully modified an inquiry screen (added columns, changed order of the cloumns...). Now we want to share that inquiry screen with another X3 system.
Unfortunately we cannot choose inquiry screens as an object in the patch creation…
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…
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'm unable to HIDE the delete button in A/R receipt batch and A/R receipt entry screen using UI profiles. The method works with A/P and other screens. but, not with A/R.
Any Advice would be appreciated.
Thanks
Nish
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…
Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement.
mDBLinkCmpRW.OpenView("CS0120", out csQry);
sSQL = "Select Name, Description from MYDB.dbo.Table";
csQry.RecordClear();
csQry.Browse(sSQL, true);
…
Hello everyone
We have programmed a specific inquiry for our client. There should be a back and next button.
Only a part of the data records should be displayed. When you click on next other records should be loaded.
In the function GESGTC (Inquiry…
So I have been presented with an interesting challenge.
In our company we've set X3 to batch allocate all available stock to meet all demand in the system.
We also heavily leverage X3's ADC functionality. Our warehouse users are able to override the…
I was recently asked if there was a way that one could change the default sorting method for the selection of documents in an A/R Receipt Entry. It defaults to "Order By: PO Number" however, it was requested that I change this to default to "Order By…
Having an error on my VBA "Class does not support Automation or does not support expected interface" when assigning Set dsGLJEH = AccpacGL2100UICtrl1.UIDSControls("dsGLJEH")
On "OnUIAppOpened()"
Public WithEvents dsGLJEH As ACCPACDSControl
Private…
Having problem with my SAGE 2020 (300 Premium) (Build 0)
When I tried to add COM Components for example AP2100 (AccpacAP2100.AccpacAP2100UICtrl)
and drag that to my Empty Project .NET (VB), it show's the error below (Failed to import the ActiveX…
Hi,
Is there a way to block the Print Transfer Slip Confirmation Dialog box from appearing for IC Transfer. We have created a custom Print form and wish to suppress the standard Print confirmation alert box which appears after Saving or Posting a Transfer…
I wrote a simple macro in VBA that enters an order and then posts it. On post, SAGE 300 assigns the next order number. How do I return that order number to the macro?
I want to put it in the message box for the user.
I've set up a custom field in the ITMBPC table to denote that a particular customer product needs to have a special dispatch label printed. It's a simple yes/no, so I have linked it to Local menu 1.
How do I get it to display in the ITU screen so that…