I’m trying to build a bpm that throws an error if a PO line does not have a reference in its GL Account link when the line is updated. I can get it to work if there is only one line. But, if there are multiple lines I am greeted with the following error. [image] How do I handle more than one reco…

This is the code to throw an exception. throw new Ice.BLException("My awesome exception"); You could also set a variable in code, then use a condition widget and a widget for an exception. But this is easier if you are already in code.

Now what do the Widgets’ contents look like?

@ckrusen , SetArgument 1 = key 1 Db.TranGLC.Where( r =>r.Company == callContextClient.CurrentCompany && r.Key1 == ttPODetailRow.PONUM.ToString() && r.Key2 == ttPODetailRow.POLine.ToString()).Select( r =>r.SegValue1).DefaultIfEmpty("").FirstOrDefault() Condition 0 what does key 1 =? if key1 = “159…

@Doug , Just gave that a try and noticed that that the ttPODetailRow.RowMod is coming in blank. Is this because I am in on a post-process? I have noticed that the error I put at the end of this is not stopping the update process at all. Also, running as a base process gives an error saying there are…

Oh, yeah. If you’re wanting to block the save, you want this as a pre-processing BPM. RowMod being blank means that there are no changes which would be the case in the post-processing method.

Tangentially related, you’ll also see blank RowMods in pre. When you update a row, the temp table will contain two rows: the old data with a blank RowMod and the new data with RowMod “U”. The order that the rows appear in is undefined. Don’t make the mistake of taking First, Single, or FirstOrDefaul…

@krum This is the code im using to pull the item i need which is the segvalue1 in the TranGLC table. Db.TranGLC.Where( r =>r.Company == callContextClient.CurrentCompany && r.Key1 == ttPODetailRow.PONUM.ToString() && r.Key2 == ttPODetailRow.POLine.ToString()).Select( r =>r.SegValue1).DefaultIfEmpty…

The condition I suggested would apply to an enumerable of rows. The error comes from applying it to an enumerable of strings. In your example, you might use it before your Select. But what I described only applies to pre-processing BPMs. It’s just an important thing to know about RowMods in general.…

BPM More Than One Record Error - Help Needed

Epicor ERP 10

Doug.C (Doug Crabtree) December 11, 2020, 10:55pm 6

I would put a condition at the start that the ttPODetailRow.RowMod = “A” or ttPODetailRow.RowMod=“U”. It should only fire then on the update or addition of a record.

Topic		Replies	Views
BPM enquiry Epicor ERP 10 e10	20	1489	March 7, 2023
BPM for Warning Message on Duplicate PO Epicor ERP 10	35	6889	February 21, 2019
How to properly throw an Exception in BPM Epicor ERP 10 e10 , bpm , method-directives	12	5959	March 26, 2026
Set Field BPM - "There are no records in the table" Epicor ERP 10 e10 , bpm	22	6583	January 3, 2019
BPM Creating PO Errors On Second Record Epicor ERP 10 create-po-bpm	3	791	August 24, 2020

BPM More Than One Record Error - Help Needed

Related topics