Hi,
No return value for list box focus event property. How is this property trigger, by clicking on the list box control?
Any information would be helpful.
Regards
-SKG
Hi,
I experiencing errors in customer maintenance on a custom tab. I'm using the debug window and found 1k+ lines on several clicks.
Error:0 Error:11 Error:12 Error:13 Error:14 Error:2 Error:20 Error:23 Error:26 Error:27 Error:36 Error:65 Error…
Bonjour
J'utilise les états paramétrables et en particulier leur option de sortie E-Mail, pour envoyer mes devis ou factures à mes clients par mail , avec un pré-remplissage de l'objet et du corps du mail.
Cela me permets de personnaliser mes mails…
I am trying to write a script in Opportunity that says if the pers_markets field is blank then use the comp_markets, otherwise use pers_markets, but i cant seem to get it to work. What am i missing?
var CompMarkets = CRM.GetContextInfo("Company","comp_markets…
Good day all.
I want to write a small specific with an action on a field.
If Field A = 'condition' then Field B = Mandatory user input. Mandatory user input, users cannot move away from the field until they enter the data.
What is the command in…
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…
Hello,
We have a custom-defined script that triggers Post-Write on the table CI_Item. This script then reads the field 'ItemCode' of that table. We also want to extend this by triggering this script with other tables.
I am seeking a way to retrieve…
Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…
Has anyone had any luck creating a BOI script to print and update invoices when batches are enabled? I keep getting a message stating that batching can't done in the current task. Here's a snippet of my code:
retVal = oSS.nSetProgram(oSS.nLookupTask…
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…
Greetings all,
I was wondering if there is a way of updating a UDT whenever a Sales Order is printing via script.
I have a customer that would like to keep track of the time between when the SO is printed and when the order is shipped. I figured I…
the code...
# Import necessary classes to work with Sage X3 from x3 import BPCUSTOMER, ITMBPS, ZRAPPEL import csv from datetime import datetime
# Get the current year current_year = datetime.now().year
# Perform the query query_result = ZRAPPEL…
I am wanting to show a custom field in Pick ticket PRH1 from Item Master ITM. The field is showing, but it is duplicating the last line to all lines above. I have added the affzo, but I think I am missing the NBLIG and am not sure how to use it.
The…
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…
We need to track all additions/changes/deletions in the AP_VendorElectronicPayment table. Has anyone used scripts to track the changes successfully? We are using Sage 100 Premium. I have not used scripting in Sage, but I believe this could be a solution…
Hello!
I have created a simple workflow and script to display fields that have been modified in a PO where the cost is over $10,000. This works by checking the [M] field against the base [F:POH] field, and using RETVAL to display the changed information…
Can the custom office module handle a request, where if a user choose an item from a list then the choices from the next list change based on the first selection? If I choose "A" then my choices are 1,2,3 if I choose "B" then my choices are 1,4,3? Sage…
$VERIF_MOD
Local Char ZPRODCOD(30)
Local Char ZPRODCODOLD(30)
Local Integer YESNO
YESNO =2
For i=0 To max([M:POH2]NBLIG -1)
For [F:ITM] Where [F:ITM]ITMREF = [M:POH2]ITMREF(i)
ZPRODCODOLD = [M:POH2]ZPRODCOD(i)
ZPRODCOD=[ITM]ZPRODCOD
if…
Hello,
I have a process that sends workflow mail via existing product sites with safety stock, and after it runs, I'd like to set their respective safety stocks to 0. I've marked where I would like to implement this code in my code snippet.
I tried…
Good afternoon!
I am looking to set up a new workflow rule which will automatically email all of the affected product-sites when a product status is changed.
So far, I have managed to set up a rule that will detect when the custom status field we…
Hi,
I'm trying to use vbs script to insert an entry into the AR_InvoiceHistory table using AR_InvoiceHistoryInquiry_bus object but I'm getting the following error:
Can anybody please help.
From the Payment tab in SO Invoice Data Entry I have added a button with the caption "CC Receipt". Upon a user clicking this button I would like a comment (Item code /C) added to the next line number with details from the credit card.
First I actually…
I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker.
Essentially, instead of the user typing the invoice # they would type the sales order…
