Hi All,
I have an error when trying to print custom report from my C# program.
System.Runtime.InteropServices.COMException (0x80004005): Unknown error 0x80040200
at AccpacCOMSVR.AccpacSvrReportClass.PrintReport(Boolean& pWebReportGenerated, String&…
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'.
If would be wonderful if someone could assist me with the following. I have written an ASP page which displays a list of orders. This list is generated in the code and does not rely on any metadata. A snippet of the code is included below
var list …
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…
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…
When creating a menu item that is just an external link, the iframe fails to load. I even tried just rendering a simple page from a local apache web server and i cannot get it to work, regardless of how I configure the meta CSP values.
Browser shows…
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
I want to write the following SQL Query as 4 GL Link instruction:
As seen in above screenshot this returns a record. With the following Link statement I try to make this SQL in 4GL.
In 4 GL I make a left outer join and check with [F:YCFPJOB…
Hello
I get the error Error 26 : Internal error Inconsistent reference value (11026) at @X3.TRT/REQUETES$adx (153) when trying to read a custom table in a custom batch job script. Part of the key from the custom table is a counter variable which is…
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 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…
Hi alll,
I am trying to compile my module ID but having this error:
makefile(19) : fatal error U1052: file 'ACCPAC.MAK' not found
- Sage 300 SDK 70A is already installed and activated to few companies (I have ~15 companies, SDK is activated on…
I created the following script to populate ShipWeight$ in the CI_Item table when either of 2 UDF's are changed.
I am now receiving an error 88 type mismatch (error window below). Any thoughts?
START OF CODE
Dim retVal Dim cpwgt Dim cpwgtstr Dim…
I can insert a customer, i can insert a Vendor, but when i try to insert an invoice into AR, i get object set to null errors lol no matter what i do. I've been doing permutations of the code in hopes of finding WHY the error happens, i tried their RVSpy…
Does anyone have a sample C# example of how to insert a customer into the AR Customers section of Sage 2017 ?
I have the Visual Basic macro sample, but it looks so complicated, don't know where to start.
I have a request to add an "options" button that will open a custom dialog box with various button scripts performing different functions.
One in particular is hiding some elements on-screen for what I suppose is to sanitize some information for screen…
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!
Sage has built-in support for storing dates in a UDF by simply changing the "Data Type" to "Date". Then under default value, "<SystemDate>" to allow the date to be immediately filled upon new record creation.
Did they forget that dates are usually paired…
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…
The title says it all. Only happens in some folders, v12 Patch 31.
The work around is to take a patch of the graphical query from Problem Folder, integrated it into a Known Good Folder, and after validating, copy the JSON file shown in the error from…
So, so I have a custom report to display a list of costs, and each list displays the total cost per category and there is a navigate function using the on-demand subreport to display detailed costs per category. when I want to export the custom report…
Trying to color the SO header customer# field if the customer type fall = specific value. I appreciate if you can help.
Ctype = ""
retVal = oBusObj.GetValue("CustomerType$", Ctype)
If Ctype = "SDIS" then Set myUIObj = oSession.AsObject(oScript…
Hello
We have a C# program that takes as its input a text file, processes the file and then posts the OE Order using the class ACCPAC.Advantage. We open the OE Views to create the OE Order. The programs runs every 15 minutes on a Windows Server with…
Is there a way to make hidden columns by Transaction Entry type show in transaction types they don't typically? And be editable?
For example, the Unit Cost / Price definition in the Sage Help has this note:
" The transaction type selected in the Transaction…