Sage 100

 View Only

  • 1.  Open a field so it can be written to thru Visual Integrator

    Posted 11-22-2020 20:04
    I am trying to use VI to change the order type on sales orders already created.  The client is on version 2019 - Premium.  I used to do the below.  The keys are not matching up between providex.ddf and providex.dde.  I have searched providex.dde by name and I am not finding sales order header.  Maybe this will not work with Premium?

    1) DFDM - open providexddf\change Key No to ByName\Click the Key magnifying icon and find the table to add fields to.

    2) Switch Key No back to Primary Key and write down the Key= #.

    3) DFDM - open providexdde\enter the key #\edit\ enter 20 for the Field Number, 1 for the Starting Position and 20 for the Length. 

    4) Change the ReadOnly=1 to ReadOnly=0.

    '0' means you can write to the field; '1' means the field is read only.




    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------


  • 2.  RE: Open a field so it can be written to thru Visual Integrator

    Posted 11-23-2020 11:33
    Does OrderType not appear in V/I for you? If so, then changing ReadOnly flag in dictionary would make it visible. For me it's already visible in V/I and not marked as ReadOnly in dict. 

    Since DFDM went underwent enhancements with v2019 the process to find a field in DDE changes, like this:
    1. Backup ProvideX.dde
    2. DFDM ProvideX.ddf. Leave Key No as Primary Key and click on lookup button. When the listbox appears click on Data to sort by it and find SO_SalesOrderHeader. Note the key. It's 000601 for me
    3. DFDM ProvideX.dde. Leave Key No as Primary Key and type in the key from last step. Click the lookup to find the "header" record. Now find OrderType and select it. It's 000601000003 for me.

    ------------------------------
    Alnoor Cassim

    Email: alnoor@asifocus.com
    Ph: 949-689-9887
    Orange County, CA
    ------------------------------



  • 3.  RE: Open a field so it can be written to thru Visual Integrator

    Posted 11-23-2020 15:19
    Yes, I do have order type in the VI Job and I realized this morning that I did not need to take it out of read only mode as it already is.  I need to change the order type on 88 sales orders that have already been entered and some are partially shipped.  Due to encryption you have it indicate to allow changes in DFDM, which is the issue.  I guess I will just have to fix them manually in DFDM.

    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Original Message


Related Content