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...
@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...
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...
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...
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!
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...
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.
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"...
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...
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...
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...
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...
Lbass,
Thank you! It is grouping on the weeks now displaying the Monday of the week; the convert nulls to default values was checked. However, it is still not sorting the years correctly. I'm getting
4/4/2011
4/26/2010
5/02/2011
5/17/2010
Is there a way to correct this? Let me know!! Thanks...
Lbass,
Still getting the same error message-Dates must be between year 1 and year 9999 and its highlighting this part of the formula: date(year({POrel.DueDate}),1,1)
Lbass,
I forgot to mention we have some fields that don't have dates so I'm getting "Dates must be between year 1 and year 9999. How to have it say if the date equals null or 0 or 1/0/1900 then "no date available" else display the formula?
I am working on a report that shows the open order cash commitment for po's and I would like to group them by week and by month. My "by month" formula works when the user chooses that from the parameter; however, my "by week" parameter is a hit and miss. I would the like data below to display...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.