Sage X3

Hi, Please I was trying to add a new field to a table when trying to save it pops up this error..please help me Thank you .

Hello Everyone, Is it possible to add Dimensions in account/nominal ?? I am able to add dimension under account 31100 (on screen). However, when I click on SAVE button, it throw error " Error in pyramid 31100 " and records didn't save in database…

Hi, I am trying to get a value display on a field on the PO line screen. This is the concept: field description data type [M:POH2]GROPRI entered md8 (internal type: decimal) [M:POH2]DISCRGVAL entered md8 (internal type…

I am attempting to create a simple query showing invoices that have been posted for the day. I'm using SINVOICE, SINVOICEV, SINVOICED, and GACCENTRY all joined via NUM_0, plus a join from SINVOICE.GTE_0 to GACCENTRY.TYP_0. When I attempt to save/validate…

Hi to all brothers & sisters I am currently working on X3PU9 navigation function (Jump to) in table (NBLIG) from customized screen to Journal Entry. I did realized the GAS object is using HAE3 as index key. However, when i apply the code, it not able…

I've created a number of reports intended for Facility Managers to access through a link I made on their Landing Page. What I would like to do is pass their default facility through to the report to restrict the data they can retrieve to just that which…

Hi I am hoping you can help, I have created a custom Class and Representation, that lists some information about our products, and an Image. Below is a screenshot of the end result; Please can you advise if it is possible to increase the thumbnail…

Hello I have design the master detail for testing purpose. I am not able to save the data in the grid (details table) but master table data gets saved Can i get some help?

Hello Guru's, One of our customers noted that Sales Delivery Module doesn't have the standard capability of filtering the Sales Order Selection like the function currently available in Purchase Invoice where the module has a line menu for Purchase Order…

Has anybody tried printing a crystal report via web services by creating a subprogram? If so, could you please send some examples so I can take a look at what was done to get this accomplished? If not, anybody got any ideas on the best approach for this…

Hi I created a custom field in table BPCustomer table. Enabled the item in SPEBPC script.When I enter text it does get stored in TEXCLOB table.(The save button also doesn't get enabled) When I enter text in this field I want to store it.How can…

Hi, I`ve created some fields on the table BPARTNER, after that, I`ve cloned the BPR2 screen and renamed to BPR3 with the new fields: ----------------------------------------------------------------------------------------- After add all fields and…

I would like to make a bundle in node.js, for Webservice consumption and add to X3.

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…

Hi all, I would like to read a value from a field (TEXT) and If the user entered a value different than only numbers the system will replace all non number characters to blank. something like : replaceAll( ' [^0-9] ' , ' ' ) is it possible? …

Has anyone every created an external web app and that app uses the adc functionality or know of a way to do this? So basically, I am trying to create an an external web app, but I want it to behave in the same functionality when I am doing the material…

I'd like to know if I create my own customize Dashboards with Sage X3 to be watched by non-accounting knowledgeable people so the can access them through any mobile devices? The situation is that my client has acquired the Sage Business Cloud from Sage…

Hi all, I would like to know what is the best way (step by step) to create a rules/automation on a custom field. I have a field on SIH0 screen, It is a type A field: 1 - When creating the register, the system populates the field with a sequential…

Has anybody created an API call for an ADC function? More specifically, I am looking at the ADC Material picking screen and looking for information on how to write a write api call for this. Thanks, Chris

Good day everyone, I am Manuel a rookie in the use of Sage X3. Fortunately over time have gotten myself familiar with the Interface and workings of the ERP system but on the development part have been stuck with a few challenge and hoping get it it…

How do you deal with 13th period on X3? Making the last day of the financial year to be the 13 th period is not an option since we have transactions to post on the last day of the financial year. Anyone else who needs this functionality?

I have a problem with this Entry Point. I think it should be FILTRE not FILTER as stated in the Technical Help I created a specific script YPAYPROP1.src (see below) and assigned to standard process PAYPROPAL in Entry Points I have records in table…

Does anyone know how to do the above? I've been asked to update the column names on the invoice screen to reflect what our users actually call it but can't seem to find a way to do that. I've tried updating the title, abbreviated title and the long title…

Has anyone been able to import using SCS and for an intercompany transfer? We modified the import a little and we are stuck with an error: :Non-existent Stock

Hi, I am having trouble getting the substatus to show in the recontrol box. I got the substatus to show as a select but when I select it, it shows the name of the parent status which is A. I want the box to show the sub status AR which I created. How…