Hi all,
I have this SQL query where I have a whereclause l.LineQuantity>six.TriggerQty
select c.CustomerAccountNumber, c.CustomerAccountName, h.DocumentNo,
si.Code as ItemCode, si.[Name] as ItemName,
pg.Code as ProductGroupCode,
six.TriggerQty…
Hi all,
I want to join StockItems and StockItemSupplier table using Sage.ObjectStore.Join below.
StockItems sis = new StockItems();
try
{
Sage.ObjectStore.Join join = new Sage.ObjectStore.Join();
join.RightTable = "StockItemSupplier";
join.RightTableAlias…
Hello,
New to Sage... Probably the answer is very simple but I simply can't figure it out: How do I make a custom form (such as estimate or invoice) the default form? I am unable to save the customized form in the default folder (it says I do not have…
Hello,
I want to make a simple specific script modification for the manual matching screen (SPELTR) however, it seems that actions do not work on the screen. The code is as follows:
$ACTION
Case ACTION
When "AVANTBOUT" : gosub ZSOLCPT
When default…
Is there a way I can change the default line near the bottom of a pre-bill worksheet to show "Remaining Escrow Funds" instead of "New account balance" like it currently does?
Hello
I want to delete database entries which are older than 15 minutes.
datetime$ returns the date in GMT time zone.
But the database entries are stored in CET time zone (CREDATTIM column). The comparison not work as intended because of the 2 hours…
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 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&…
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 all,
I am looping the POPStandardItemLine or an Order using foreach loop. The item lines in the order consists of standard order line and a charge line. While looping, I encounter an error.
this is because 1 item in the POPStandardItemLine is…
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…
hi all,
I am following example on this link https://www.sagecity.com/us/sage300/b/sage_300_erp_r_and_d/posts/launching-non-sdk-programs-from-the-desktop to create a screen using C#. I am able to create and working fine. However, the details is not looking…
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…
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…
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…
