• BPSNAM: key too long 505(500) error appears when trying to save a new field in BPSUPPLIER table

    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 .
  • How to add dimensions in account pyramids

    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…
  • GROSS PRICE AND DISCOUNT CALCULATION ON PO LINE SCREEN?

    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…
  • Graphical Query Incorrect Link

    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…
  • 'Jump to' function navigate to Journal Entry

    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…
  • Pass user's default facility through Landing Page to linked report (x3v11)

    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…
  • Changing size of an Image thumbnail

    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…
  • Master Details form

    FormerMember
    FormerMember
    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?
  • How to add a selection criteria for Sales Order in Delivery Window?

    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…
  • Customize Three Buttons on Top - V12

    How can the three buttons in the top button row V12 UI be customized. For example, in the Sales Order screen, buttons available on top (out of the box) are Allocation, Preparation and Delivery. We don't do any of that and would like those to be Invoice…
  • Printing a crystal report via webservices

    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…
  • Line Menu - Data not stored

    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…
  • PJM - Financial Overview - Cost Type Scope

    The financial follow-up of the PJM module claims to be prepared to represent outputs of other modules of the system, from purchases and sales movements typed with the type of cost present in the article or DEFAULT if it has no registered, time management…
  • Add Line to Grid

    HI all, in Sage X3 v11 I need to fill a grid on click but I can't find a way to add lines to my grid, can someone share a script to help me, i'm currently working on Sage X3 SPE Script of that window?
  • Hello friends, I would like to know how to add a bundle node.js to X3.

    I would like to make a bundle in node.js, for Webservice consumption and add to X3.
  • 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…
  • How to increase the number of button on the screen header

    Hi, I would like to know if there is a way to increase the number of buttons showing on the screen header. As example: On Suppliers, I added 2 new buttons, Test 1 and Test 2, but on the header there are only 3 buttons ----------------------…
  • i can't add new field to screen

    i'm trying to add field to screen ,in the first level i add a field to table then i used it in screen but an error has displayed thank for helping me to solve the problem
  • creating a web app using mertial picking adc functionality

    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…
  • Create my own customize Dashboards with Sage X3

    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…
  • Validation rule on a custom field

    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…
  • ADC Soap API

    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
  • Chinese Languiage Process Flow Diagrams

    I am looking for Chinese Process Flow Diagrams. We have Spanish, English, French, but I can't find a cChinese language one. We can change the language on X3 easily by switching the locale, but the flow diagrams are still in English.
  • Filtering of transaction record on left list using object

    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…
  • 13th Period on Enterprise Management (X3)

    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?