Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by esings2him

  1. esings2him

    Receipt Entry BPM

    Hi all! I'm wanting to create a BPM that will force users to change the receipt date if they delete or change items on a packing slip. Epicor tech support sent me this code - for each ttrcvhead where ttrcvhead.RowMod= 'U' and ttrcvhead.ReceiptDate <> TODAY - and it's partly working, however...
  2. esings2him

    Repeat Field Value

    I didn't try that; I figured out a different solution. I will try the sql expression and let you know how that goes. Thanks for all your help!
  3. esings2him

    Repeat Field Value

    @SalesJob contents: If maximum({Table.TargetJobNum},{@Job Nums 2}) < '6' then "" else maximum({Table.TargetJobNum},{@Job Nums 2}) @Job Nums 2 contents: If instr({Table.JobNum}, "-") =0 then {Table.JobNum} else split({Table.JobNum}, "-")[1] @JobNums2 formula is what I'm grouping on to get all...
  4. esings2him

    Repeat Field Value

    Ian- That is incorrect; I don't have the suppress if duplicated checked; the data doesn't duplicate because the values aren't true for the If statement. lbass-Your formula worked perfect, exactly like I wanted, but I can't group on it or add it as a parameter because the Table.SalesJob is a...
  5. esings2him

    Repeat Field Value

    Hi! I've been having trouble getting a field value to repeat so I can group on it and use it as a parameter. What I would like to see is the sales order number repeated as shown below. SO# Sales Job Parent/Child Jobs TargetJobNum 0000093 WXYZ-0000093_1 001012 WXYZ-0000093_1...
  6. esings2him

    Formula producing correct and incorrect data

    Lbass, It's a Progress DB and I'm working with CR 11 R2. I'll try that or some variation of that and let you know how it goes. Hopefully, I'll get the syntax correct! Thanks for your help!
  7. esings2him

    Formula producing correct and incorrect data

    No, I'm not adding subreports. I mean correspond when I say link. SO# corresponds with TVDB-0000098-1 job number.
  8. esings2him

    Formula producing correct and incorrect data

    I'm wanting to group on it so I can see all of the related jobs associated with it then I will add Sales Order field that will link to the @GPJob field results. Here's a sample look of what I'm wanting in the end. SO# GPJob Jobs Parts Ext. Cost 98...
  9. esings2him

    Formula producing correct and incorrect data

    Lbass, I used your formula and it works properly, but I still can't group on the @GPJob formula. It doesn't show up as one of the options in group expert.
  10. esings2him

    Formula producing correct and incorrect data

    Lbass, Thanks for your help! It always appreciated! Job number is currently sorted by ascending transaction date that is why it is displayed the way it is and that's how the user is wanting it. I used "whilereadingrecords" because I couldn't group on the formula using "whileprintingrecords"...
  11. esings2him

    Formula producing correct and incorrect data

    Hi all! I have a report that has parent and child jobs that need to be linked to the top most job. The parent job is linked to the top most job; however, the children are not. I have a formula that groups all of the parent and child jobs together and I, also, have a formula that groups parent...
  12. esings2him

    How to match and group by a field

    Ian, Thanks for your help! I figured out the rest by adding a summary on the Sales Order field and taking the maximum. I inserted it into your formula and added an else statement and it works perfect! If {JobProd.OrderNum} <> 0 then {JobProd.OrderNum} else salesorder:= Maximum...
  13. esings2him

    How to match and group by a field

    Ian, Thank you! Your group by formula is awesome! However, your sales order formula is still giving me the same results as I displayed before. Job Number Sales Order 1043 (Grouping) 1043 1043 97.00 1043 1043 97.00 1043-PM102 1043 0.00 1043-PM102 1043 0.00...
  14. esings2him

    How to match and group by a field

    Hi! I'm trying to match all jobs that begin with the same first four characters then group by them and also, add or duplicate the sales order number to the jobs that have a zero value. Here's an example of what I have: Job No. Sales Order 1043 97 1043 97 1043-PM102 0...
  15. esings2him

    [b]Grouping By Week[/b]

    Worked like a charm! Thanks Lbass!!

Part and Inventory Search

Back
Top