Browse By Tags

  • [X3v12-4GL] In Script editor, how to open a X3 Storage Area folder to reads its filelist names?

    Hi, 4GL Development question. Not sure the keyword to find for these. In 4GL, I know I can just manually put in the hardcode filepath to open through SYSTEME2 raw OS cmd call but it is very annoying to maintain (about 5+ scripts to update) every time…
  • Product selection fields in Stock Inquiries do not match definition in ITM object

    When using the Product selection icon in any of the STOCK inquiries (Stock by site used for example), the fields in the pop-up window for selection are not those defined by the Product ITM object selection. Where can I find the field definitions used…
  • Users and User Authorizations Report

    Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…
  • Sage 300 Web API - Sage 300 2020

    Getting below error when calling API for AR module. The 2 config files are enabled ( https://www.sagecity.com/support_communities/sage300_erp/f/sage-300-general-discussion/110205/unable-to-make-a-get-call-using-sage-300-web-api ) and in Sage 300 USER…
  • Customer Maint display bill to on sold to main screen

    Does anyone know if you can display the billto customer # in the main screen in customer maintenance on the sold to?
  • Customising Reports with background color for each field

    Hey everyone, We do have many dashboards with different reports telling us what to do next, which are missed deadlines and what my daily performance is. Now I'm wondering if there is a way to change the background color of a field or line based on…
  • DFDM Modifications to Allow UDT Field Lookups

    When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.…
  • Possible to change text color of a locked UDF?

    Is it possible to have a locked UDF field display its contents in red, possibly via a DFDM property change? I've attempted (without success thus far) to update the color via the DFDM Nomads_Color property to 01FF which appears to be the hex code for…
  • Add field EANCOD in the inventory screen

    Hello everyone, Please I have a problem with adding the EANCOD field in the inventory screen, when I add it in the screen the field is displayed but empty. Please help me to solve this problem. thank you
  • Grid Screen

    Hello! I'm Sage X3 developer and I having issues with Grid development. Does someone have a documentation about NBLIG, nolign, counters and grid screen? Thanks.
  • "LNGDES_0" of table ATABDIV invalid column name in SQL query

    Hello, I have written a simple SQL query that returns info about sales returns. I am trying to get the return code description to show up, from the ATABDIV table (Miscellaneous Tables) but it's throwing this notice that the column name, LNGDES_0,…
  • VALUER Action Parameter Empty via Import

    On MISC RECEIPT screen SPE: Subprog AP_LOT(VALEUR) Variable Char VALEUR() The VALUER variable is empty when I use a import template, but not when I use the UI. Help please
  • Sage X3 V12 Shortcuts

    Hi everyone, I came across these excellent and useful to improve navigation on X3 V12. A. Right Panel Actions ESC + N – new ESC + B - save ESC + C - create ESC + D - delete ESC + E - cancel ESC + ALT + U - refresh ESC + ALT + P - print…
  • Using Crystal Reports to customize Ardinvo, how do I add database tables and fields from those tables?

    I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name. Now I want to add some fields to it that are not in the set of data tables already in the report. In the "Field Explorer" I right…
  • Add a Custom UDF for Inventory Price Change

    Does anyone know if you can add a UDF field in Inventory Maintenance that shows the date of the last price change?
  • Function cannot be called in this context

    Hello everyone I built a generic screen "ZTRANSPORTCO" for a customer. The screen is used in multiple windows. The problem is when I try to "Jump to" another window which also has a tab with the generic screen "ZTRANSPORTCO" I get the following…
  • Variable to show the transaction code used to enter screen

    I would like to take action in a screen based on which transaction code was use to enter the screen. Is there a variable available that will show which transaction was chosen when launching the function?
  • Hyperlink on other column on grid

    Hi all, on quote item grid, I need to add hyperlink to the other column, in case something like this happen. Please see row #3, there is no description, hence, no hyperlink, and there is no way to edit this row. Please teach me how to add hyperlink…
  • Tax and Discount percentage in Quote item did not auto calculate

    Hi All, I make the tax and discount percentage and value field available on display on Quote free text item, but it seems I can only enter value on the fields, and it did not auto calculate the tax or discount value. How do I set these value to be calculated…
  • ACLA: Opening the same table twice

    Hi, Planning to move a customized activity code from a Sage X3 server to another Sage X3 server. On the customized activity code Sage X3 server: Did a patch creation. Picked the custom activity code. Pre-load the object. When I press…
  • Hide Delete Button in A/R Receipt

    I'm unable to HIDE the delete button in A/R receipt batch and A/R receipt entry screen using UI profiles. The method works with A/P and other screens. but, not with A/R. Any Advice would be appreciated. Thanks Nish
  • Permanently Enable Button on UI

    I have a button script located on a Cash Receipts Entry screen. Sage disables it by default until a customer number has been entered. The purpose of the button is to assist the user with locating the customer number, so this doesn't work for our use-case…
  • CS0120 data to accpac finder in COM API

    Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …
  • 430 error in macro after PU8

    Installed PU8 on server and now a macro with OCX dropped on userform1 does not work on the server where macro is being developed does weird stuff now like 1. no longer generates _OnRecordChange event 2. Set oHeader = AccpacOE1100UICtrl1.UIDSControls…
  • customized panel

    if an employee has a customized panel (which overrides the all user panel ) how can we return the customized panel back to the all user version? we had an employee accidently create a customized panel and it is not correct how can I get her back to…