Anyone know a BO method for shipment to check if there is enough unallocated qty OR does anyone have a function or logic to check it that they'd be willing to share?

Epicor ERP 10
1

Anyone know a BO method for shipment to check if there is enough unallocated qty?

Trying to do the check in a function, but based on the trace I don’t see one.

2

@Jonathan do you know of a method I can call?

3

Don’t know of a BO method, but i’m thinking you might just have to query the Part Alloc table for current allocations/demand, then reference your OHQ from PartBin…

4

Thanks Chance, I will go that route. I was really hoping I could just do a BO method check with the data I already had in my tableset, but I guess I’ll have to do the LINQ statement. Thank you for your input.

5

Not really, if you can see this value somewhere on the UI/Report then I could see if it is simple enough to let you know how to retrieve or calculate yourself. A quick search didn’t provide much, so I’m guessing it is a lot more complicated.

6

:frowning: thank you Jonathan for taking the time to look into it.

7

@cfinley I just realized you can do a try catch on a function call so if the function results in a BL error you can just catch it and then proceed to the next record if you are in a loop.

I will use this methodology to address any errors.

-Utah

8

have yet to dip my toes into functions. excited though!

9

DUDE! You need to play around with it, they are so so so so nice.

10

BAQ BPMs have been my bud as of late. But definitely is on my list!

11

The coolest thing that I learned last year at insights from @Banderson and @josecgomez was the use of an updatable BAQ to get the result set that you need (invokable from many different places and many different methods) and then the fact that you could hijack the updatable BAQ by using a custom BPM action that would invoke functions or any business logic you want.

It’s been extremely useful and versatile.

1 Like
12

Results is a useful dataset

1 Like
13

Exactly what i was talking about. SUPER useful. Worth thanking them as well. Love you guys :heart:

1 Like
14

Getting back ot the orginal question. One method during the process does return a message that states you are going to go into -ve inventory…Is that what your talking about?

15

Yeah but it seems for transfer order shipments, when you go to ship them, the message is never returned in any of the methods… I’ve done a trace looking at the responses and none of them have the message stored in the “allocationmsg” out param or any of the other “message” out params.

16

oh…that’s annoying. It may be that going down the BAQ route as @cfinley suggested originally is the path of least resistance

1 Like
17

Thanks Simon. Yeah I am calling a function that invokes a BO method to ship a transfer order.

I can put that function call in a try catch and then present any exceptions to the user. This makes it so that I don’t have to do any custom logic to try and check for negative quantities or allocation issues before calling the function- I’ll still let the BO call do that…

I didn’t know I could catch a BL error in a try catch.

-Utah

1 Like