When a buyer is working with PO Suggestions and they have selected several records to buy and then selects the ‘Generate PO’s’ Actions Menu I need to aggregate the selected rows OrderQty by Supplier and make sure that exceeds a value defined on the Supplier. However, the only Method I can see to us…

Maybe you can glean something from what Jose did with a CTE for Sales Reps (also tilde delimited). [image] Trying to create a BAQ that lists sales by salesperson. Problem is SalesRepList can hold multiple. Help! ERP 10 Here is a Basic BAQ which does this using a CTE (Give…

Is what you are wanting a datatable with each item as a separate column? I assume this needs to be a dynamic number of columns?

I don’t know exactly. I got this partial solution from someone on here. It uses the ZDataField as a source for a unique sequential number list. Add a subquery with ZDataField table and no fields. Add a calculated field: Name: RowNum Type: Int Editor: ROW_NUMBER() OVER(ORDER BY ZDataField.SysRevID A…

I’m guessing you’re doing something like making sure you’re hitting a minimum order value or something similar? The best way I’ve found to do this kinda validation is to ‘cheat’. Replace the the standard button with a custom one. Have it do all your validations and other underhanded deeds, then jus…

[image] Waffqle_De_LaCroix: arrayOfCrap.Dump() [Suspicious Monkey GIF by MOODMAN]

No, I don’t need the tilde delimited items in different columns, but I need them in different rows. My thinking is if I can split the string by Tilde and populate a datatable, I would then use that datatable to query the SugPODtl for those SugNum and summarize OrderQty by Vendor.

Thanks, I’ve been able to Split the list into an array, but now I need to lookup the SuggNums (that’s what the tilde delimited list is) and sum by vendor to make my check. I’m stumped on how to query SugPODtl.SuggNum with an Array. I was hoping to convert the Array to a DataTable and then use the …

Ok, sorry but I am confused. Would you mind backing up an explaining exactly what you are doing and what kind of solution you are looking for? Are you wanting a BAQ that breaks it out, or can you use custom code with LINQ? What kind of output etc?

This is not a BAQ, it’s a BPM that needs to evaluate all the PO Suggestions that have been selected for Buy when the Generate PO’s Action menu option is selected. I ran a trace and what appears to be the only viable Method is the .CheckBuyers, .CheckBuys includes a few parameters, none of which ar…

So would you like it as a datatable, or to show you how to query an array with a datatable?

BPM Query List of Tilde Delimited Values

Kinetic ERP

Mark_Wonsil (Mark Wonsil) May 23, 2023, 2:01pm 2

Maybe you can glean something from what Jose did with a CTE for Sales Reps (also tilde delimited).

Topic		Replies	Views
In need of code critique: Part Deux Epicor ERP 10 e10 , epicor , bpm , linq	3	552	November 3, 2021
Fancy Linq Query to split two fields Epicor ERP 10 bpm	7	3281	September 24, 2019
Trying to create a BAQ that lists sales by salesperson. Problem is SalesRepList can hold multiple. Help! Epicor ERP 10 e10	32	4177	February 6, 2026
Linq Queries Epicor ERP 10 bpm	2	584	February 25, 2021
BPM access table not in dataset Epicor ERP 10 bpm	2	1508	April 20, 2022

BPM Query List of Tilde Delimited Values

Related topics