I used a VBS script to login to Sage300 with task scheduler
this technique has worked for many sites and many years
Client went to Azure hosting and now......
this line:
Set Signon = CreateObject("A4wSignonMgr.AccpacSignonMgr")
Makes this :…
With identical UDF names in both tables, the original value set into the SO Header UDF via a ColumnPostValidate script from a standard field works to flow the value to SO History Header, but subsequent successful updates directly to that SO Header UDF…
I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.
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
I should start off by saying we are still on v2020 for compatibility reasons.
It appears that the `oBusObj.DocumentTotal` property (Sales Order Bus) doesn't calculate on quotes (it's value is 0). Is this intended behavior? The moment I change the order…
Dear all,
Is there a way to have a short script alone with the BI script to show error message on why my script doesn't work.
In other word, how to trigger error message on a BI script, something related to this code - oBusObj.LastErrorMsg. Correct…
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…
We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…
I have encountered a strange issue with a button script that enters data into a UDT. I have been using this script in testing for about a month now and it hasn't had any issues until yesterday - even after a server restart.
The first time clicking this…
Is there a way to build custom explore views. For example, If I go into Business Insights > Explorer am I able to create one of those views from scratch?
I am wondering if there is a way to make a custom view from the business insights explorer a shortcut within the Explore Tab?
am I able to put a custom view in here somehow as a shortcut?
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…
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…
We are attempting to copy over all of our customized to fields from a test company to a brand new company. Is there an easy way to copy over the customized fields and panels while creating the company?
Hello,
I was hoping to get some advice on scripting the BOI via a Button script that was placed on S/O Invoice Data Entry that would act as a "Quick Tax Credit" button. We use a third party cloud vendor to calculate our taxes but that shouldn't affect…
We are looking to edit the way our format for the schedule of values outputs & prints, is there a way to edit this? Or is this a default that is unable to change? The same goes for our estimate template.
Hello everyone
I try to implement the entry point https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR.htm#APE_30_10 with action REQUETE.
I created the entry point and the processing script in the X3 folder…
Hello everyone
We sometimes have problems when a batch job runs more than once.
In order to prevent this we want to use the entry point SERVEUR with action REQUETE https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR…
I'm trying to create an advanced logic filter that will only capture a few specific customers. With the operand's available I've tried just about every way I can think of including all 20 of the companies. Does anyone have any examples for formatting…
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…
I've created a UDT in AP. Populated the data and then created a UDF in AP Invoice Detail.
The Code field appears from the table but i cannot select it.
what needs to be changed?
UDT
AP Invoice Detail
UDF in AP
Thanks for your assistance…
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…
It's me again.
Looking into using VBA or potentially a vb.net windows form app to potentially create and update Cash Receipt Batches & Deposits. External scripting documentation seems to be pretty limited and I am not sure where to even start when it…
In Customer Maintenance's Invoice tab I am wanting to allow accounting to have the ability to edit the Comment field from the AR_OpenInvoice table. Since this isn't the history table, it wouldn't affect the comment line for invoice history reprints, so…
Need help with new custom field formula. I create custom field "Net Available Stock"
I have added the custom field to below screens, functions. now I need the field to work accordingly. I create a custom script for net availability and still having…