Search results

  1. N

    Sign of the times

    People, please stop contacting me. I am not offering this position. I was merely making a point.
  2. N

    Sign of the times

    Experienced ERP consultant wanted for $10/hour!! :eek: Join a fast-growing software company that specializes in the development, sales and support of Advanced Planning and Scheduling (APS) software. - Work with businesses to identify their needs and model their factories in our software. -...
  3. N

    importing excel formula as value

    I'm trying to import a csv file that has formulas. Instead of importing the values, Progress imports the formulas literally. Is there a simple way around this? example: the csv file has a cell equal to "=1+1". I need to import this cell as "2", not "=1+1". Thanks
  4. N

    conditional display in form (urgent)

    Run this code as an example. You should not see any blank lines in your form. def var cmmt like cd_cmmt. def var i as integer. def var k as integer. for each cd_det no-lock: cmmt = "". k = 1. do i = 1 to 15: if cd_cmmt[i] ne "" then assign cmmt[k] = cd_cmmt[i] k = k + 1. end...
  5. N

    Excel output from ChUI

    For those still stuck in ChUI, you can still output to a spreadsheet (not CSV) with all the bells and whistles like formatting, sorting, subtotals, filters, comments etc. You basically output to an XML file and open it with Excel. See the attachment for a simplied example. You can get as...
  6. N

    conditional display in form (urgent)

    def var cmmt like cd_cmmt. form cmmt[1] cmmt[2] cmmt[3] ... etc when assigning cmmt only assign it if cd_cmmt is not blank: k = 1. do i = 1 to 15: if cd_cmmt[i] ne "" then assign cmmt[k] = cd_cmmt[i] k = k + 1. end.
  7. N

    WO not linked to SO

    Try this wrapper around 23.1, 23.2 or 23.3. You will still need to set the order policy to LFL for all parts involved. {mfdeclre.i} def var nbr like so_nbr. on find of mrp_det do: if mrp_dataset = "sod_det" then nbr = mrp_nbr. end. on write of wo_mstr do: wo_so_job = nbr. end. {gprun.i...
  8. N

    WO not linked to SO

    I don't believe there is any way to have MRP link a WO to an SO. If you want to customize it to do so, I would recommending setting the order policy (pt_ord_pol/ptp_ord_pol) to LFL... this will generated WO's for the same quantity as the sod open qty. After the MRP generates the planned orders...
  9. N

    CIM for customized frame

    Handle the frame differently when cim loading. if not batchrun then update xx with frame f-x overlay. else update xx with frame f-y.
  10. N

    List of all subprograms and includes

    I wrote a quick query that will generate a list of all programs that are called from a parent program. I wrote it in a QAD environment. Minor tweaks needed for non QAD.
  11. N

    Select All in a smartBrowser

    Anyone have an answer for this? I'm using v8 so I can't use b1:select-all().
  12. N

    subtotal in Excel - array?

    I can subtotal a single column but am having problems subtotaling for multiple columns. chexcel:selection:subtotal(2,xlsum,xxx,,,). I want to put the equivalent of array(5,6,7) in place of xxx. How do I do this in Progress?? Thank you.
Top