Search results for query: *

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...

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...

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...

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...

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...

I am trying to get the group subtotal and ultimately the grand total of the fields I am trying to sum. In my report, I am calculating the cash balance of all open PO's by their due date. I am using the 3 formula method where I have a running total thats resetting to 0 that's working properly...