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 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 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…
Hi,
Is there a way for me to identify where a script is being used other than identify from script name and description itself (unreliable since sometimes there's no description and badly named name).
In specific, I would like to know where this script…
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…
Hi,
Was doing Patch creation (APATCH) to bring customization over.
Noticed these errors:
My temporary solution is to simply delete the linebreak character since if I do not do this it crashes the main screen function.
Is there a way to resolve…
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…
Hello,
I've created a custom drop-down list in the WT03TSA1 (Stock Change Intersite) screen, but when trying to use it, none of the options are displayed. Instead, it says "No Match":
The menu is set up as follows:
The field is set up as follows…
When using the Product selection icon in any of the STOCK inquiries (Stock by site used for example), the fields in the pop-up window for selection are not those defined by the Product ITM object selection. Where can I find the field definitions used…
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…