Browse By Tags

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

  • 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:

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

  • I need help verifying a variable on creation of Sales Invoice

    I there,

       I'm struggling to get a verification if a Variable is empty or not on creation of a sales order. 

       The Variable is in each line of the sales order, i need to emmit a warning and block te creation if one of the lines has the var empty 

       Here is…

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

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

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

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

  • Fields not being saved on customized Sales Order form

    I have a client who has a fairly heavily modified SO form (although we cut back from what we had previously done by quite a bit).

    The client will have an issue with the Freight amount not saving on the Total tab.

    I will go in and recreate the customized…

  • Customizer Corruption

    A client asked me to create User Defined fields and add them to their AR Customer Maintenance screen.  When I accessed the DMAIN panel this is what I see.  I stopped immediately because this looks like corruption to me.  I have never seen anything like this…

  • PURCHASE INVOICE BPRVCR CONTROL

    Sage X3 allows a parameter to warn user for duplicate values in BPRVCR. 

    How can this warning be change to an error? 

  • Can't figure out Event hook

    I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel.  The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

  • Business Insights List Query

    Hello!

    I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer.

    It would be nice if i could filter a whole list of orders…

  • Can I combine data from SAGE 100 Job Cost's JobTransactionDetail table and data from Job Cost's JobHistory TransDetail table on the same Crystal Report?

    I would like to combine data from SAGE 100 Job Cost's JobTransactionDetail table and Job Cost's JobHistoryTransDetail table on the same Crystal Report.

    I need to create a summary report that includes data from both tables.  I'm hoping that someone…

  • Creating Crystal Reports Interactive Dashboards for Sage 100

    I have several reports in Crystal 2016. Has anyone created interactive dashboards using crystal reports? The Business Insight Dashboard is canned and not really customizable. Sage Intelligence isn't all that friendly. Your still trapped in a little box…