Browse By Tags

  • Web service returning "Process[WS_NAME] - No return code (status[6]) "

    I'm getting the following message on some web services responses. Just in some times.

    "Process[ZWS_NAME] - No return code (status[6]) "

    The web services its a Subprogram web service.

    Has anyone known what is it? And how to fix it?

  • within generate porder from prequest

    Hello everybody

    i'm about generating purchase order from purchase request , the probleme that i want to pass a field value as params from request line or header to all line in the order

    thank you 

  • SO entry screen

    We just did the SAGE 2021 update and something all of our people are finding an issue with is  In SO entry screen under the lines tab we used to be able to have the columns in the order we wanted and have what we wanted to see and it would remember it…

  • Quick Representations/Class Setup for X3V12

    Hi,

    I would like to create more representations using Views/Tables. Requestors are very quick to create in X3V12 using Views/Tables, but very limited functionality specially on Landing Pages. The goal is to give user far more interactive dashboards with…

  • Customer Parent/Child relationship

    Hello Team,

    Could you clarify, is it possible to create the customer Parent/Child relationship in Sage X3?

    If yes, could you provide screenshots on how to do it?

  • ROG - Answering Yes to "Do you want to receive the complete purchase order?" blanks out Item Code with UDFs

    I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years.  Now managers want some of these UDF to be required.  When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…

  • AR invoice optional field setup auto

     Currently trying to insert a AR invoice detail line by line transaction and the optional field is set as auto insert under the AR/Setup optional field.

     Problem: Detail lines are inserted under the AR invoice without the optional field.

     Source code:

  • Adding current Date to an SEI Dashboard

    Hi Everyone, 

    I am trying to add a current date widget to an SEI dashboard. I have tried to add a KPI view with a calculated column containing @@CURDATE without success. 

    Best regards, 

    Tarik

  • Report Setting not defaulting to custom report for some users

    I've recently created some custom versions of reports (AR Aged Invoice Report, for example) and set them as default for all users, but for some users it still defaults to the STANDARD report every time. It is set to the default report via the checkbox…

  • Custom Office for Work Ticket Templates

    Just discovering the power of Custom Office (I'm a newb). I am running into a wall with one particular item. I have worked my way through creating user defined fields and tables and can successfully customize panels in screens and modules, but I'm stuck…

  • Anyone know how to setup an Export template so that it's output is split into multiple files?

    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 to…

  • Add a job cost related field to AR report in Crystal Reports

    I am trying to add the "JobDesc" field to our AR Aged Invoice Report so that we can see what job name corresponds with the invoice on the report. I'm a beginner in Crystal Reports, but here is what I've tried:

    In Crystal Reports designer…

  • Error adding Custom Description field to BOMs and Work Order Screens

    BOMs

    I am trying to add a custom long description field to our Manufacturing BOM screen (BOH0) and receiving this error - 

    I've added a "Before Field" Action to the ITMREF field and added this as the script. 

    Subprog AV_ITMREF(VALEUR)
    Variable…

  • Looking for the sales FOB field in sage x3

    Good day everyone, I am looking for the sales FOB field in sage x3. If there is no field in x3, is there a column in sql? So far I have been unsuccessful in finding said field. Any guidance would be greatly appreciated. 
    Thank you in advance!

  • Use Browse() with "NOT IN" where clause/filter

    Hi, I need to do filtering using the "NOT IN" just like in SQL SERVER, but with Browse() function in ACCPAC library. I try using NOT IN with browse but got error, I guess its not supported. Is there other way to filter similar to "NOT IN"? Thank you.…

  • How to change Screen Input type from "Enter" to "Display" via 4GL?

    I have a need to set the format of fields on a screen to "Display" when a certain value is detected in a field.

    I know how I could suppress it conditionally, but that's not what I want to do.

    Basically... if I were writing the suppress for…

  • AccpacAR3100UICtrl1 : Invalid object name 'POSTDET' error

    Hi !!,

    Need help on above thrown the message from one of the UIAppControls of AccpacAR3100UICtrl1 

    Awaiting soonest reply.

    thanks and regards,

    Joshua

  • ADC location override

    So I have been presented with an interesting challenge.

    In our company we've set X3 to batch allocate all available stock to meet all demand in the system.

    We also heavily leverage X3's ADC functionality.
    Our warehouse users are able to override…

  • Match BOM Production Entry Line Sequence to BOM Maintenance detail line entry

    We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…

  • Attempt to change read-only field 'Header Discount'. when I did not even set the HDRDISC value

    Hi, I encounter this odd behavior while creating a macro to do an OE Invoice Entry. I did not even set the "HDRDISC" value but this error 1144

    "Invoice Detail

    Attempt to change read-only field 'Header Discount'."

    keep popping…

  • Error "The customer or item tax class is not valid for this order." during OE Invoice Entry

    Hi All,

    I am creating a new customize program to import invoice in bulk from excel file while referring to a recorded macro on Sage. The import of Shipment number and its detail lines are fine. But when I try to insert to OEINVH, I got this error "The…

  • Filtering Customers by Company ID in Sage X3

    Hello Team,

    Could you help me with the following question.
    Is it possible to filter Customers by Company ID in Sage X3?

    If yes, could you describe how to do it?

    Regards,
    Andrew

  • User Defined Fields Data

    We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…

  • Transfer custom fields from STOALL to STOJOU

    I have a custom field in the STOALL table that I would like to transfer to the STOJOU table when the transaction is validated/posted.  I've been looking for an entry point to do this, but I can't seem to find it.  Does anybody know if there is an…

  • Excel Addin for Macbook

    Can some one please help me where can i get excel add-in for MacBook.

    If the answer is CSV , than let me elaborate there are few additionally added field those data are not getting captured properly in CSV Format.

    DO we have any work around for this or…