Browse By Tags

  • How to add a calculated field to a Representation

    How to you add a custom calculated field to a representation? For instance if you would like to add field populated with the current user. How would you go about doing that?
  • Anyone know how to setup an Export template so that it's output is split into multiple files?

    Hello, We are still using version 7. We have an export template we use to export invoices to be sent through EDI. Currently the export template creates a single text document with information from every invoice that needs to be sent. Is there a way…
  • Import BOMD Lines successful but not updating BOMs

    I was able to update BOMD with a line detail thru Usage>Import and the report indicated that the record was modified. However, the Production BOM detail was not updated even though the properties showing that the record was modified?
  • How can I find processes running in background?

    I'm trying to find a way to view active processes while updating products but I've had no luck since last week. If I try to click from one field to another in Identification tab with or without making a change, it keeps loading for more than 30 minutes…
  • Script Syntax Question

    Please excuse my ignorance, but I'm trying to read some scripts in X3 and I'm wondering what the '!' before a function or command means. Also, can anyone confirm if the : is an end of line notation? I'm looking for 4gl language references that might…
  • CSV formats in CRM.

    Hello All, Today I'm going to explain the differences between the two CSV formats available in Sage CRM. When you are: generating reports, exporting find results to file or exporting group list to file you can find two CSV file formats: 'CSV'…
  • How to Sync Additional CRM Appointment/Task Details to Outlook Appointment/Task

    Here is a feature that I think you will find useful. It can help you to sync more fields from the Company/Person/Address entities of the CRM Appointment/Task to the Outlook Appointment/Task body. Below is an example of how you could acheive this. …
  • Gender & Salutations Script

    Morning. In regards to Gender & Salutations, I'm looking to create a script in which, for example, if "Male" is selected then it only shows "Mr, Sir, etc". Would anyone know where to start with this? Thanks in advance.
  • Custom Entity Link from Communications Regarding field

    Sage CRM v7.0.d.2 Custom entity called Service created using the Advanced Customization Wizard Customization is done using .net, service.dll has a RunDataPage method The Service entity has communications The comm_serviceid field is a Search Select Advanced…
  • HTML rendering in support.js file email.body in case_details field in Cases

    Running into a issue with the support.js file and incoming tickets. We have a issue where the html is not getting parsed out and is being displayed on the case and is showing the html and headers from the email making it very hard to read. I know there…
  • excel reports export problem after turning ON SSO

    Hi guys! My client wants that i created the reports for his needs, but after creating it he says that his excel reports isnt working. After restoring backup they dont work too. After some days, we decide to TURN OFF SSO and we saw that excel reports export…
  • What do you use for automating AP/AR? We are looking for different options that work well with Sage X3 v7

    We are looking for different options that work well with Sage X3 v7 and I thought I'd see what works for you guys.
  • Selection Criterion Formula Wizard question

    I have a recurring task that exports invoices to our EDI system and I'm trying to implement a selection criteria to separate out invoices from selected customers. I have tried variations on the script below but it is constantly rejected by the formula…
  • How to create 2+ records in V7 style "simultaneously"?

    Hi, How can I create two or more instances in V7 Style code ( Leave request representation) ? In this specific case I want to create as many entrys in the table as contracts registered for the Employee. I tried with a For Cycle in "AINSERT_AFTER…
  • Disponibilidad Nuevo parche: Sage Enterprise Management (Sage X3) V7 P18

    Producto: Sage Enterprise Management Version: V7 Fecha: Octubre 2018 Se encuentra disponible parche nº 18 de Sage Enterprise Management (X3) V7. El parche 18 se entrega con el servidor Syracuse SafeX3V2_Syracuse_P18 obligatorio. Se recomienda también…
  • Sage X3 v7.1 Patch 18 & Patch 18 Add-ons has been posted (KB 93815)

    Sage X3 v7.1 Patch 18 & Patch 18 Add-ons has been posted (KB 93815) . To access this download, log into https://support.na.sage.com/ and in the search field type 93815 and click the Search button.
  • Sales Prices / Price Entry in v11

    The price structure for a particular product is: 60.00 for 0 - 9 units, for 10 - 49 units a price of 50.00, for 50-99 units a price of 40.00 then from the 100th unit onwards 30.00 each. We would like the Sales Person to be able to enter a single line…
  • Did You Upgrade to Enterprise Management (X3) v11?

    We are currently using X3 v7 and are making preparations to upgrade. We would like to hear from those who were a part of the upgrade project team for their company and who upgraded to v11 from a previous X3 version, preferably v7 or newer. We'd like to…
  • Workflows and remote cell phone email SSL/TLS setup

    Has anyone ever setup remote (outside of network) email access where workflow buttons trigger the action in the related X3 workflow? I’m searching for information regarding cell phone, or remote email access to X3 generated workflow emails that require…
  • Filtering in Mobile v7 coding

    Hi all, I'm trying to use the "AQUERY_CRITERIA_AFTER" event, in a mobile representation. My only problem here is that the property "THIS" is not available, and because of that i can't use values from the main screen. Do you know how can i solve…
  • How to jump directly to a record in a representation (edit mode)?

    Hi, I need to jump from projects directly to a record that already exists at classes and representations in edit mode. How can I do it passing the record ID as seen in the picture? Basically what I need is something like "Call OBJET("OBJ…
  • How to attach a PDF in native V7 classes and representations?

    Hi, How can I attach a PDF to a record in classes and representations (V7 native)? Best Regards
  • ADATIM in classes and representations

    Hi there, I'm trying to use the datatype ADATIM in classes and representations to manipulate departing times and estimated delivery times. The problem is every time I try to edit the field I get the error "invalid format type" Here is a print…
  • ABC Class

    Hi, I am trying to add more columns on the customer level where the ABC Class option is. I was able to increase the options from A TO Z. But when I try to do " AA","AB" ETC its not allowing me as the number of character allowed is over the limit.…
  • Using IMPORTSIL in V7 style coding

    Hi, How do I use IMPORTSIL in V7 classes and representations style coding? "Call IMPORTSIL("YBPP", WNOMFIC) From GIMPOBJ" doesnt work anymore. Best Regards