• Script does not update field value if the line is not entered

    $VERIF_MOD
    
    Local Char ZPRODCOD(30)
    Local Char ZPRODCODOLD(30)
    Local Integer YESNO
    YESNO =2
    
    For i=0 To max([M:POH2]NBLIG -1)
    For [F:ITM] Where [F:ITM]ITMREF = [M:POH2]ITMREF(i)
    
    ZPRODCODOLD = [M:POH2]ZPRODCOD(i)
    ZPRODCOD=[ITM]ZPRODCOD
    
    if…

  • Purchase Receipt Function in Datalinx

    Hello Group,

    I'm hoping for some help or insight into an issue we've encountered using Datalinx & Sage Purchase Receipt Function. This is what we're trying to do:

    We are trying to use the purchase receipt function in Datalinx and receive…

  • Execute ACTION from STD on Sage X3

    Using Sage X3 v12 (2021R3), I try to execute on a TRT the $APRES_CHOI action from STD and SPE.

    My process is the following : Object called ZDK, I'm opening an action AZDK1 that opening a custom selection popup (with screens and backend-code).

    GACTION…
  • Machine Inaccessible error

    Hi team,

    Someone kindly help, am getting the Machine Inaccessible error sometimes when I or my users have lock screens and am trying to terminate them. What might be causing this and how I can permanently resolve?

    Regards

    Emmanuel

  • Counter for NACHA file

    I am creating a NACHA file for Old Second bank.  Their file layout requires a count of all the detail lines.  Is there a way to get a count of the detail records to show in the NACHA file?  How is that done in the "Bank File Definition" screen?…

  • Clear all import/export scripts - Dictionary Validation

    I've noticed in a recent V12 patch set that when performing a Dictionary Validation there is a new option in the Objects to process section titled "Clear all import/export scripts".

    Is anyone familiar with the purpose of this option?

  • Custom messages in standard flyout?

    Hi folks

    I'd like to know if there's an easy way to show custom messages using the standard flyout banner (e.g. shown if record has been updated)?

    I know I can use Infbox to achieve a similar result, but the user should not be forced to click…

  • Payment Terms and Payment Methods link

    Is there a way to setup payment terms without linking the payment method. At the moment it seems you have to duplicate each term for each applicable payment methods. i.e CHK30DaysNet TRF30DaysNet ACH30DaysNet which is not really in line with most accounting…

  • How to store Blob image's type in a table ?

    I created a custom screen where I am displaying images related to a driver.  I am using a datatype of ABB, input of Display, and Graphic object of Photo.I have an issue on how to store those images.
    I know that it is stored in the CBLOB table. In the screen…

  • points debit / tokens credit

    Has anyone used the after sales points debit / tokens credit sections in products? I would like to create a points system for customers. IE purchase this product, receive 100 points. Then use those 100 points towards future purchases. It seems like that…

  • REST Web services Post a record problem

    why I keep getting this error: "Saving has failed" every time I try to create a new record. Is there an option somewhere that prevents it from creating this new record? What am I missing?

  • Import Inventory Value Change values to revalue stock

    Has anyone managed to import values to do a value change of stock?

  • Period Status Change

    Hi,

    User was trying to open period in the new month unfortunately couldn't select "No" in the next months so only intended month's period is opened as a result ended up opening entire year which is not right. Someone kindly assist on how I can change…

  • Global Serial Number Management of Products with Packaging

    We want to trace products at the lot level but maintain traceability to the specific package. Is there a way to produce products to include their packaging? I basically want to serialize (maybe globally) my PAC units such that each one is uniquely identifiable…

  • Manufactured product - Q status as default single item

    How do you have a single product be put in Q status as soon as a case / pallet is made in production? I can see how to do it by "product category" but i only want a single item within that category. 

    Sage X3

  • Purchase Receipt delete not possible, receipt date changed

    Hi All,

    Created a Purchase Receipt and it reflected the Stock with the quantity, later realized the receipt date was wrong. So, user tries to edit the receipt date and click Close receipt.

    Then user created an another Receipt with correct date. Now user…

  • What mechanism sets price for Intersite Orders?

    Hello All,

    Encountering something in our Sage X3 setup that I'm having trouble hunting down the source for. We have some Inter-site orders between us and some distribution companies. For this transaction, we want the gross price to be set to 0 automatically…

  • Function GESPAY Supplier cash payment Error: Open item being matched

    A/P-A/R accounting>Payments>Payment/Receipt(GESPAY)>

    SCAS Supplier Cash Payments> For Advance payment entry, every time a user tries to create the entry faces the following error. need urgent help. 

    X3 Application error: Open item being matched…

  • Using Outlook wrt New email client for Sage X3 workflow notifications post.

  • PJM Financial Overview - Cost Type Issue from PO Transactions

    Hi,

    Has anyone experience an issue where PO transactions are showing under the Site as opposed to the Cost type related to each item on the PO in the Financial Overview screen?

    As per the example below, the Commitment amount of 8k from the PO is displayed…

  • SageX3 - Selection List

    Hi, in a custom selection script like this:

    GSELFAC = 1 : # campo che deve ritornare

    Filter [F:YPROD]
    CRITERE = "[F:YPROD]YITMREF='"+[M:POH2]ITMREF(nolign-1)+"'"

    NBCOL = 0
    NBCOL +=1 : COL(NBCOL) = "[F:YPROD]YCODPROD" : TIT(NBCOL…

  • Quantity in Suspended transaction need to be cleared

    Hi,

    We have some quantity in Suspended transaction for a particular item, which occurred during a Shipment transaction due to the insufficient quantity. Later we received the same item using MISC Receipt, but the suspended quantity not updated, suppose…

  • 3rd party Webservice soap response

    I'm trying to make a call to a 3rd party webservice using Sage X3 scripts on the SDH window, i'm using the func ASYRWEBSER.EXEC_HTTP wich is working fine, it's calling the webservice and receiving the answer of the soap call.


    The Answer:

    <s…
  • Product Description disappeared

    In Sage X3, PU9, Common data Module>Products>Products(GESITM)

    whenever I create a new product or modify the existing product, the data in description 2 and description 3 disappeared. ironically, the previous data in the same field for certain products…

  • Manual Allocation of Substandard Stock in X3

    We sometime have defective or substandard stock we sell at a discount.  This is product that has gone through a QA process and has failed to meet our standard but some customers may not care that the product "looks a little funny".

    We do not…