Browse By Tags

I have this code which reads the given file and attempts to write it to the lines on the purchase screen. The issue is that it is populating the data into the fields, but it isn't actually "creating" the line on the screen, the same way that it does…

Hi, Please I need serious help, in solving this issue. I created a new field in the management tab called category that is jumps to the product category table. So I am trying to make the selection of itmref field in the line tab in order filter…

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 need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…

Hi all, i have a problem with this function: Funprog SUM_TOTAL(PROJECT,BUDGET) Value Char PROJECT Value Char BUDGET Local Decimal TOTAL If !clalev([F:PJBU]) Local File PJMBUD [PJBU] : Endif If !clalev([F:PJLB]) Local File PJMBUDLIG [PJLB] : Endif If…

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…

Hi I have a task where I have to add a Text Field(CLOB) on the customer screen as a menu item(on right side) So far this is what I accomplished 1.Added menu item and Enabled it in SETBOUT 2.Created a new screen(ZACLOB) with a CLOB field When…

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 have a customized report ZSORDERS I have a script that renames the pdf generated by report (SO#) and saves it in destination.But I need to modify the script so that when the user opens the report in preview the report is renames and the user…

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?

Hi, I would like to clone an invoice after posting, but the "Child" record will have few changes. Would anyone have a piece of script that clones one record to share, as an example? Just to learn the best way to do it. Thank you. Best regards…

Hi all, I am trying to build a SPE to capture a number (Field is a text), split the digits, multiply each one, sum all and validate the result. I have some questions: 1 - Now, I am working with STRING and I need convert this String to a Integer, so I…

Hi, I need to create in Sage X3 V9 (patch 6) a new analitycal dimension (object CCE) on creating new Project (object OPP) with some data from the last one, my client request an automatic function on create so any new button are forbidden, in my specific…

When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL. When I execute the query in SQL, it returns the correct results. For example: When testing the same…

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

Please any help will be appreciated. I am trying to clone a functionality from Customer BP Invoices under the AP/AR Accounting. In the Distribution field in Lines where you can perform analytical distribution I am trying to clone same functionality for…

Hi everyone, I'm using "Call OUVRE_BOITE From GESECRAN" to show a popup window with a progress bar while doing some stuffs. How can I show the same popup window but with 2 bars, the first for the main task and the second for the sub tasks? Thank you…

Good day everyone, I am going to be grateful if I get a reply to one of my challenges. I am trying to create two tabs with the table screen type. I am successfully making on the tab save data to the database but the other tab cant save data into the database…

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…

Hi All, We are calling a REST Web Service via the classic 4GL code with " Func EXEC_REST_WS" . I am using a simple GET to retrieve information. The parameters that are described in the Online Help ( link here ) make use of a Return s parameter.…

We are migrating Sage to a new server. When I move over the custom crystal forms, some of them are prompting for a sa password before running. I have checked all my database connections. There is one difference between the two database connections - when…

I am a complete newbie to Crystal Reporting and have watched several tutorials, but they are all for stand alone spreadsheets. I have no clue how to use information within Sage to create a custom Crystal report and how to connect the two of them.