Sage X3

I was asked about a shortcut to print a screen array to an Excel export, instead of the user having to click "Excel Export". Thanks, Zoey

Hi Everyone Currently the Word Merge functionality is available on Sales Quotes. I would like to be able to add this functionality to other objects ie Purchase Orders as the customer requires multiple documents to be created from X3 (but editable…

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…

Hello All, Please i tried to import sales invoice into the system and i notice that the template doesn't have serial number included. Please help me how do i add the field to it because sales invoice table doesn't have serial number field. …

Hi, How do you subtract time with the 4GL language? Thanks, Chris

We are creating a customized report for manufacturing. There is a particular field on the Routing screen (Graph>Show list) This displays the Start date which is displayed for the particular operation in date/time format. However we are unable to find…

Hi, I am trying to do a misc issue by import the data in. I changed the file type for the import to be delimited and the date formatting, but everything else for the template is the same. Below is the error message i am getting returned when I try to…

I have used the AOWSIMPORT subprogram IMPORT many times to call an import template from code. This is actually outlined on the Sage Developer site. I have found that some client installations do not have AOWSIMPORT.adx on their X3 instance. I have noticed…

I'm curious to understand the difference between using a trbegin - commit - rollback sequence to update a value(s) on a table vs. using an Update With statement . the Trbegin statement would look like this: Trbegin [TBL] If !fstat Write [F:TBL]…

Has anybody put the stock valuation report (FUNSTVA) on the batch server. I was wondering what the file box is used for and if somebody could give me an example path so I have an idea of what would go in there.

I have a validated delivery to which I want to modify both the delivery quantities and the quantities of the stock movements made; I need to do it by code or template. Would anyone know what template to use or how could I develop it?

Hi, I was wondering of anyone has experience of uploading to the ACLOB table. We want to utilise the comments section in GESBPC and GESBPR for uploading Special Instructions on GESBPR and uploading Historical Sales Ledger / Credit Control comments…

Morning - question from our customer about templates for CRM/ operations: The customer needs an import template for the CRM/operations (object ITN) with material usage. Simple inserts without material usage can be created. However, afterwards the…

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…

What is the difference between ETAT and ETATN when it comes to automatically printing out reports? ETAT () from AIMP3 ETATN () from ETAT

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…

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…

Hello All, Please i did a USD transaction in purchase order, while printing purchase order report, i notice the exchange rate is not displaying on the report. Please how will i go about it in crystal report.. Thanks Samuel

Greetings, All! I'm looking for direction and I apologize if I am not describing this correctly. But I am going based on what was described to me. I'm told in Sage EM there is an "Activity Code Stripping Program" (my quotes added). It is located in…

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…

Hello, I am trying to utilize the RFQ feature in Sage. I am able to create a RFQ, but I cannot enter a response. I have initiated several RFQs but when I go to response management to enter the price, the RFQ numbers do not show up on the left panel…

Is there a way to automatically print the order acknowledgement when somebody presses the create button on the sales order?

Hello, has anyone has experience building auditing reports (we are looking to do it on sales orders, but general process knowledge would help)? We have to comply with Japanese SOX and I need to build a log of whenever a sales order is changed for the…

Is it possible to add color condiytional statements for queries? (graphical, query, or sql query)

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